Excel 2003 - VBA - Error - Cannot Shift Objects off Sheet.

[Craig Brandt]

Hi Guys:

I have a spread sheet where I insert about 42 columns and shift right. This
worked for a while, then I started getting an Error "Cannot Shift Objects
Off Sheet" . I did find a button that had been shifted so I deleted it. Not
change, still got the error. I then selected all cells and deleted. Still no
change.

Does anyone have any idea of what is happening here?

Craig

 

[Dave Peterson]

Maybe...

XL: "Cannot Shift Objects Off Sheet" Error Hiding Columns
http://support.microsoft.com/default.aspx?scid=kb;en-ca;211769

Remember to look for comments and merged cells.

 

[Craig Brandt]

Dave:

For a short time fix I deleted the sheet and created another. Right after
doing that I was ready for a stiff drink as I realized that I had deleted a
bunch of procedures with the sheet. Fortunately, I was able to do a quick
recovery by copying the procedures from a down rev copy.
The deletion and subsequent replacement, fixed the immediate problem as I no
longer get the error, but expect it to show up any day now and will now know
what to look for. This sheet is called "Misc" and I use it like a scratch
pad. One of the routines that used it may have merged cells and therefore,
that was what I was trying to shift off the sheet (they would have been
difficult to visually see). If that is the case it would be highly unlikely
to occur again, as some routines do a cells.clearformats and others delete
all cells.

Dave, Thanks again for your timely help. It is much appreciated.
Craig

 

[Dave Peterson]

Backups pay off again!

A little disk space is pretty cheap compared to the time it would take to
recreate the code, huh?