Check these articles
http://support.microsoft.com?kbid=170081
XL97: "Cannot Shift Objects Off Sheet" Error Hiding Columns
http://support.microsoft.com/default.aspx?kbid=211769
"Cannot shift objects off sheet" error message when you hide columns in
Excel
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"Darin Kramer" wrote in message
...
Hi there
I have several defined names in a workbook. The names define groupings
of columns.
Eg - Cols C - H defined as Cats
Cols I - L defined as dogs.
When I select a range of defined names (ie cats:dogs), and I try hide
those columns, i get the error message "cannot shift objects off Sheet".
Any ideas???? (Im just hiding not inserting, so rather confused!!!
*** Sent via Developersdex http://www.developersdex.com ***