Posts by Danilo • 13 points
4 posts
-
0
votes3
answers132
viewsA: Excel vba - bug when inserting several cells at the same time
Alex, it’s best not to use Offset since the destination of Now() is fixed (column D). Note If i <= 10 before the Cells(i, 4).Value = Now(), which is not to add the result of Now() in all that is…
-
0
votes1
answer108
viewsA: How to create a chart with the last row data automatically when closing the form?
Ideally you would create another range after setting the range1 and using the new range (range_grafico). Whereas the last column (of data) will be column 1 + 9 or "J", since range1 will already be…
-
1
votes1
answer90
viewsA: Replacing and concatenating the contents of a cell
I would take a different approach. Given the information, from what I understand, you don’t need to make any filters. Maybe you just want to make a filter after, to see what was changed (and for…
-
0
votes2
answers936
viewsA: Query Data With VBA Filter
To add to the question, how others may have the same problem. I would approach it differently. First I would go to the second tab and make a loop independent of the number of lines and the presence…