Do...Loop Macro

[Cass]

I have a macro that I want to automatically repeat. How
and where to I plug in the Do Loop.

Ex. I have text that I want to Cut and Paste on a line,
that procedure needs to run about 10 times. How to I tell
my macro to keep repeating itself?

 

[Chip Pearson]

Cass,

You would write the code something like

Do Until (some_condition = False)
' your existing code here
Loop

The some_condition depends on your application. This should
return a value of TRUE as long as you want to continue looping.
When some_condition equals FALSE, the loop will terminate and
execution will continue at the first line of code following the
Loop statement.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Frank Kabel]

Hi
have a look at
For next
in the VBA help