Hi. I'm getting a Run-time 1004 error when trying to insert 3 blank lines (it pops up at the first "Insert" line). Excel is complaining about shifting non-blank cells off the page, but doing "CTRL-END" highlights cell D198, which is the extent of my data, so I don't understand the problem. The step before this was copying a pivot table, pasting as values, then pasting as formats. Any help on fixing this would be greatly appreciated.
Thanks, John
Please Login or Register to view this content.
Last edited by jomili; 09-20-2010 at 12:58 PM.
Hello jomili,
This errors occurs when a formula has been added to the entire worksheet, or if formatting (such as a borders or colored cells) have been added to an entire column or row. Remove these from the first cell past your data to the end of the row or column.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
I understand what you're saying, but not necessarily how it applies in this situation. I create a new sheet, copy the pivot table (Tablerange1) from another sheet, do a pastespecial values, pastespecial format, so at the point I'm inserting lines no other formatting has taken place. My one formula was only for the range A4:A200. I got it working by rearranging things a bit.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks