Question about Macros in Excel
Is it possible to make a macro repeat a specific amount of lines or be able to start from any cell?
The workbook I have I update on a semi-regular basis. 3 lines are updated when I update the workbook. The macro was recorded to start on a specific cell. When I went to test the macro for a 2nd update, I noticed the macro didn't work properly. When I looked at the code, I saw that the starting point was a specific cell.
The goal would be to edit the macro code to where I could either start it on any cell in the workbook or more specific to be able to use the same macro every 4 rows(the 4th row being the last blank row).
|