how do you make a macro execute x number of times?

[Guest]

How do you make a macro execute x number of times? I have created a macro
that searches for text, goes to the beginning of that line, highlights to the
end, copies it, and then moves it to an adjacent column. I need that macro
to execute about 1200 times and I don't want to do that manually. Any advice?

 

[Greg]

Shellyey,

Maybe something like:

Dim i as Integer

For i = 1 to 1200
'Your code
Next i