Have you turned off any error handlers (such as on error resume next) .

then run it and see if you get an error.

Do you have functions written in VBA used in your worksheet. If so, make
sure they don't create an error or that it is handled.

Your problem statement is very light on details or sample code.
--
Regards,
Tom Ogilvy


"Tomas Stroem" wrote in message
...
I want to insert a certain number of row texts into 20 identical
spreadsheets.
When I copy the area I want to insert then my macro stops after the first
of
the 20 sheets.
I use "for x=1 to 20" "Next x" to acheive the repeated copy.

Is there a simple way to get the result i want?
--
Tomas S