Hiding Columns produces error <----HELP PLEASE
 

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!

Hiding Columns produces error <----HELP PLEASE
 

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

Hiding Columns produces error <----HELP PLEASE
 

Thanks Garry, will give this a try.