cannot shift items off sheet-published fixes don't work for me

  • Thread starter Thread starter KimC
  • Start date Start date
K

KimC

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.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

"cannot shift objects off sheet" error 8
Excel Move or Copy Stopped Working? 0
Cannot shift objects off sheet 7
Can Vba workout if a selection is part of a group? 0
Changing position of last used cell 4
using named range in VBA 20
Some macros not working on shared workbook 8
Creating a new sheet from specific data in existing sheet 3

Back
Top