Dan presented the following explanation :
Hello -
Below is a snipit of code I have for hding columns. I am getting the
Runtime Error "Unable to set the Hidden Property of the Range Class".
I'm using Excel 2007 and wonder if there is a limit to the amount of
columns I can hide in VBA.
Else
Columns("S:AW").Hidden = True
Columns("AX:AX").Hidden = False
Columns("AY:ZZ").Hidden = True
Columns("AAA:WWW").Hidden = True
Columns("WWX:XAA").Hidden = True
Columns("XAB:XDD").Hidden = True
Columns("XDE:XFD").Hidden = True
I basically want to hide columns AY:XFD, but can't seem to make it
work in one line of code. I appreciate any advice.
Thanks!
Try...
Columns("S:XFD") = True: Columns("AX").Hidden = False
--
Garry
Free usenet access at
http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc