Can you post the code for a single iteration of this loop so that we can
work on that?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"marita" wrote in message
...
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.