error - Cannot shift objects off sheet.

[Darin Kramer]

Howdie...

Im trying to hide a column - Why would it be that I get the error
message "Cannot shift objects off sheet"? Im hiding not trying to
insert. Also I do not always get the same error message on the same
column? ie sometimes I get it, othertimes not - Its the reason another
Macro is stopping working half way, because the Macro calls for this
column to be hidden, but cant because of the above error. Any ideas what
Excel thinks Im trying to shift objects off sheet...?

Regards

D

*** Sent via Developersdex http://www.developersdex.com ***

 

[Norman Jones]

Hi Dave,

See:

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

 

[Darin Kramer]

AWESOME AWESOME AWESOME Norman!!!

Thanks - saved me!

Regards

D

*** Sent via Developersdex http://www.developersdex.com ***