Thanks for the reply, Bob. However, the document you referenced was
mentioned earlier in the thread. None of the solutions worked as Kelly Girl
and eperry also posted. What I really need is a work around. The problem
disappears if I copy my range of used cells to another workbook, but then I
lose all my named ranges (about 50) and would like to know if my only option
is to recreate all the named ranges in the new workbook. Maybe I'll just
bite the bullet and recreate them all.
Thanks, again,
Kim

"Bob Phillips" wrote:

See http://support.microsoft.com/default.aspx?kbid=211769
"Cannot shift objects off sheet" error message when you hide columns in
Excel

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"KimC" wrote in message
...
I have also had this problem and need to resort to a "work around".
However,
when I copy the data in the sheet to another workbook, I lose all my named
ranges referred to in the associated macros. Any ideas?

"Bill Sharpe" wrote:

Kelly Girl wrote:
Hello, I too would like an answer to this one or at least a way to get
around
it. Can you fool the program into letting you add columns? Any help
here
would be appreciated. I upgraded from an older version and none of the
noted
solutions are working. Thanks. Kelly

"eperry" wrote:

Has anyone been able to solve this for you?
I ask only because I have the same problem in Excel 2007 and none of
the
solutions here solves the problem.
This happens on all the sheets in my workbook and I know I do not have
any
hidden data.

"Idaho old guy" wrote:

I am unable to insert rows in an existing spreadheet and a new one I
just
initiated in a book with multiple sheets. What did I do to cause
this and
how do I make it go away?

Excel apparently thinks you have data in the last row of your
spreadsheet. To check this, type Ctrl-End, which should take you to the
last entry of your workbook.
One approach is to delete all the rows after where you have placed data.
A second approach is to highlight all your data, then copy and paste to
another sheet or another workbook.
Sorry if these solutions have already been mentioned in other replies.
My Thunderbird newsreader only shows this one response and not the full
thread.

Bill