View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default Cannot Shift Objects off Sheet....?

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 ***