To overcome 65,536 rows limit,
cut rows 10,000 to end, paste in sheet3
cut rows 5,001 to end, paste in sheet2

then in each sheet (you only have 3)
for i=5000 to 2 step -1
for j=1 to 5
rows(i).insert
next j
next i

You now have the additional rows you want.

This is your job?
C) change a certain piece of a part number to multiple diffent things, (ie:
slx60sr10wh,
slx60sr12wh, slx60sg10wh, slx60sg12wh, etc) but with multiple options for
every small option

[i'm about to add 8 rows to every one]
You mean the original row1 becomes row1 to row6, and now becomes row1 to
row14?
then [every 5th row ] is now not correct.

Now you have more than 1 sheet, you need to loop instead of selecting 15,000
cells then.

"DOR" wrote in message
oups.com...
You may have to reconsider what you are trying to do, or how you are
trying to do it, because Excel can have no more than 65,536 rows per
sheet!

Are you sure you want to manipulate that many rows with Excel?

If you could describe what you are trying to achieve with these
inserted rows someone may have a creative solution.

Declan O'R