Hiding Columns produces error <----HELP PLEASE

[Dan]

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!

 

[GS]

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

 

[Dan]

Thanks Garry, will give this a try.