Solved: Unable to Hide Columns ... Why??

[Cyberdude]

I have two workbooks that are structured identically. In one workbook I have no difficulty hiding a group of columns. In the other workbook I get the message ?Unable to set the Hidden property of the Range class? when I try to hide the identical columns with the identical VBA code. Here?s the code used:

 Range("AF:AL").Columns.Hidden = True    'Hide the entry

What would normally trigger that message?

[Cyberdude]

Update: I just discovered that I also cannot hide the columns manually using the FORMAT tab. It gives me the error message "Cannot shift objects off sheet". I'll spend some time trying to find out where/what those objects are and see if I can clean it up. (I hate that message!!)

[Bob Phillips]

This article may help

http://support.microsoft.com/default.aspx?kbid=211769
"Cannot shift objects off sheet" error message when you hide columns in Excel

[anandbohra]

can u attach the file with the codes u had used so that i can see where is the problem in executing the code

[Cyberdude]

Hey, XLD, good reference (I printed it out for next time).
Thanx a lot.
Sid

[Bob Phillips]

I have a plethora of links to KB articles <G>.

Glad it helped.