Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hiding Columns produces error <----HELP PLEASE
Thanks Garry, will give this a try.
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
hiding columns, error message says cannot shift objects off sheet | Excel Discussion (Misc queries) | |||
Why do I get an error message hiding excel columns | Excel Worksheet Functions | |||
Refresh produces #N?A error | Excel Discussion (Misc queries) | |||
hiding columns in Excell error message | Excel Discussion (Misc queries) | |||
CreateObject produces error | Excel Programming |