Hiding Columns produces error <----HELP PLEASE

  • Thread starter Thread starter Dan
  • Start date Start date
D

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!
 
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!
Click to expand...

Try...

Columns("S:XFD") = True: Columns("AX").Hidden = False
 
Back
Top