| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
SHow Hide COlumns based on cell value
Hello! I want to put validation on a cell call it cell C1 and I will require
the user to select a number between 1 and 6. Whenever the end user changes the value in cell c1 I want the respective number of columns between column C and H to be shown. Therefore, if the user puts a 1 in cell C1 I want column "C" visible and columns "D"through "H" hidden. If the number is 2, I want columns "C"&"D" visible and "E" through "H" hidden, and so on. Can anyone help? Thanks.... |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hide Columns based on a cell value | Excel Worksheet Functions | |||
| Hide columns based on related cell | Excel Programming | |||
| Hide/Show Rows based on Cell Value with Data Validation | Excel Programming | |||
| Hide or Unhide certain columns based on a cell value | Excel Programming | |||
| Macro to Hide/Show Columns based on control cell value | Excel Programming | |||
Threaded Mode
