Also, I have no shapes on the sheet (I created on and then tried to tab to
the next one and there were none). And, I have a few small comments, but
deleted them all. Between all these edits I saved, closed, and reopened the
sheet.

"KimC" wrote:

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.