By spreadsheets do you mean 20 different workbooks or do you mean 20
different sheets in 1 workbook. Also post your code.
--
HTH...

Jim Thomlinson


"Tomas Stroem" wrote:

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