Thread: loop a macro
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
jnjwilliams94 jnjwilliams94 is offline
external usenet poster
 
Posts: 3
Default loop a macro

Thank you - it worked!

Ron de Bruin wrote:
Hi jnjwilliams94

You can do this

Dim I As Integer
For I = 1 To 750
Range("A" & I & ":K" & I).PrintOut preview:=True
Next I

Delete preview:=True if it is workin OK

I would like to be able to loop my macro. I have 750 rows and need to print
out 1 row at a time each on a seperate piece of paper. My macro is the

[quoted text clipped - 8 lines]

Can someone tell me how to get this to continue to "A725:K725"