Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to insert rows that copy cell content of the row above | Excel Discussion (Misc queries) | |||
Macro to copy previous row and insert two blank rows | Excel Discussion (Misc queries) | |||
Macro that will Cut rows and then insert-copy or append | Excel Discussion (Misc queries) | |||
Copy/Insert rows with formulas | Excel Worksheet Functions | |||
Activate a macro to insert a row and copy the formuals from the rows above to the blank row | Excel Discussion (Misc queries) |