Copy/Insert rows

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Haha, never mind.
The "fix" is called "ignore the error message and pretend it never
happened", at least with the Office clipboard on.
 
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
 
Back
Top