View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Niniel Niniel is offline
external usenet poster
 
Posts: 80
Default 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.