Cannot Shift Objects off Sheet....?

[Darin Kramer]

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

 

[Bob Phillips]

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]

Perfect!!! Thanks!! solved the problem!

Regards

Darin


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