Copy/Insert rows
 

Hello,

I am copying rows and inserting them further down the sheet. Trouble is, I
can only select and copy 10 rows before Excel claims it's out of "resources".
That's a bit annoying since I need to copy 200 rows - repeatedly.
Is there a way to free up "resources" so that I could, copy, say, 20 rows at
a time?
Or are there better methods altogether? I am essentially replicating data,
although every 200 row chunk is slightly different; find/replace takes care
of that.

Thank you.

Copy/Insert rows
 

Haha, never mind.
The "fix" is called "ignore the error message and pretend it never
happened", at least with the Office clipboard on.

Copy/Insert rows
 

Niniel;

I am glad you found a work around. That's great. But it could increase your
file size fairly significantly. You can keep the file size down by locating
the row you wish to use and keying the formula =A1 (whatever column) and then
draggin that formula down the row. I am not much for keyboard shortcuts, but
I am sure you can use a keyboard shortcut instead of mouse dragging.

Frank

"Niniel" wrote:

Haha, never mind.
The "fix" is called "ignore the error message and pretend it never
happened", at least with the Office clipboard on.