Repeating Macros

Posted by Eric on May 21, 2001 9:21 AM

I have recorded a relatively simple macro and I want to repeat it 1000 times. Any tips?

Posted by gregc on May 21, 2001 9:25 AM

sample of a macro that repeats 1000 times

For i = 1 To 1000
ActiveCell.Offset(1, 0).Select
ActiveCell = i
Next i

Posted by Eric on May 21, 2001 10:38 AM

Thanks, forgot my BASIC there for a minute