View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Marita Marita is offline
external usenet poster
 
Posts: 3
Default Repeat a macro until the last line is empty or repeat it 1400 time

I have done a macro that insert 20 lines, do some copying exercises and stops
1 line down the insertet ones. Instead of repeat the command run for about
1400 times I like to configure a "loop" that runs this macro until there's no
more lines to copy.
Another solution could be to repeat the macro 1400 times, maybe that it is
easier to write a WBA code for.