"can not shift object off sheet"

[Tony Barrios]

when hiding the column it gives this error message. Please if anyone can
advice if similar problems. Office 2003 sp1

thanks

 

[Nick Hodge]

Tony

You have some data, (it may not be visible)that is in the far right or
bottom reaches of the sheet

To re-size your used range, check here

http://www.nickhodge.co.uk/tipstrick.htm#usedrangereset

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)