View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Munster Munster is offline
external usenet poster
 
Posts: 10
Default 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).