I get the above error message when trying to insert a new row into my
spreadsheet. I have reviewed many posts concerning this problem, but none of
the solutions has worked for me. I am using Excel 2007. I deleted the blank
rows below and blank columns to the right of my data. When I press ctrl-end,
the active cell is in the correct location (lower right corner of data
range). The sheet has many formulas, named ranges referenced in macros, and
much formatting so it would not be easy to just copy things to a new workbook
(unless there is a way to copy named ranges from one sheet to another that I
don't know about). Please help. Thanks.