| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Retrieving value from range name
I have a one-cell range on Sheet1 named First_Column_to_Hide. The value
of First_Column_to_Hide is always a column address. Is there a way I can retrieve the value from First_Column_to_Hide to substitute for the ZZZ (placeholder) in the code segment below? Sub HideUnhideColumns() Application.ScreenUpdating = False ActiveSheet.Columns("N:BE").EntireColumn.Hidden = False ActiveSheet.Columns("ZZZ:BE").EntireColumn.Hidden = True Application.ScreenUpdating = True End Sub I would appreciate any help on this. Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Retrieving Data Range for Chart | Excel Programming | |||
| Retrieving Data: Speed of beating down rows vs retrieving from array? | Excel Programming | |||
| Retrieving comment using range name | Excel Discussion (Misc queries) | |||
| Retrieving range string from named range | Excel Programming | |||
| Retrieving the SQL query of the external data range | Excel Programming | |||
Threaded Mode
