Posts by luis_almeida • 1 point
5 posts
-
0
votes1
answer48
viewsA: I need to insert photos automatically in a spreadsheet in Excel but my VBA code does not work the way I want
The problem is this: .Left = rngCell.Left .Top = rngCell.Top Every time you pass by you put the value Set rngCell = Range("F2"). You need to place a variable and increment that value with a loop.…
-
0
votes1
answer238
viewsA: VBA-Excel: Range of a cell contained in a variable
Want to copy the values of certain cells and put in a single variable. valor = ThisWorkbook.Worksheets("Folha9").Range("A" & 20, "E" & 20) In this example we take the values from A 20 to E…
excel-vbaanswered luis_almeida 1 -
0
votes2
answers2132
viewsA: How to replace Comma by Point in VBA
something like this ? Sub teste() Dim valor_range As Range For Each valor_range In ActiveSheet.Range("A1:Z500") valor_range.Replace What:=",", Replacement:=".", MatchCase:=True Next End Sub In the…
-
0
votes1
answer24
viewsA: Copy from one spreadsheet to another
Do you want to copy the value in the correct cell ? From what I understand you only want to copy the value so you can use the following code: For i = 0 To 367 step 1 if…
excel-vbaanswered luis_almeida 1 -
0
votes2
answers440
viewsA: VBA reverses day with month in variables of type Date
I tested the code and no error appears... if you insert it into an excel cell try to format that cell for date first. With Worksheets("sheet1").Range("B1") .NumberFormat = "dd/mm/yyyy" .Value = Date…