Posts by Paulo Kazumiti • 136 points
6 posts
-
0
votes1
answer149
viewsA: Formula R1C1 Macro Error 1004
Copy the formula the way it’s on the spreadsheet. Example: Range("C1").Formula = "=A1+B1" Note that you do not have R1C1
-
1
votes1
answer42
viewsA: Add exception in Cell.Delete
Tip: Preserve G1 cell content in a variable, clear all and then return the value to the cell. Public Function SheetClear(Name As String) Dim s As Worksheet, t As String Dim i As Long, k As Long Dim…
-
0
votes2
answers581
viewsA: Create a spreadsheet with folder names listed from a directory in excel
Good morning! Follow an example, you’ll need adjustments. The idea is basically to check if there is a spreadsheet with the name of the month, otherwise create a new and rename then. Sub…
-
0
votes1
answer244
viewsA: Take the code in a cell and format the e-mail using this value (VBA) (EXCEL)
Good afternoon! Below a very simple code to generate an email in VBA, see if you can adapt. It will need several tweaks, assuming you won’t be doing the email one by one (in which case you wouldn’t…
-
0
votes1
answer132
viewsA: Make macro with loop by changing the line number
This is kind of a "lame" way of doing it, but it works. You just need to know the amount of boundary lines that will work. Sub TESTE() Dim linha As Double For linha = 8 To qtd_linhas…
excel-vbaanswered Paulo Kazumiti 136 -
3
votes1
answer141
viewsA: Bring value from another cell to the formula without being String
Marcos, good afternoon! I think the formula has the variables reversed in your example. I believe the right way would be: =PROCV($T$7;INDIRETO(T8);6;0) Run a test, you might need to use the INDIRETO…
excelanswered Paulo Kazumiti 136