| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide Column based on Cell Value
I am trying to hide an entire column - column M, based on the value in Cell
I13. I would like column M to be hidden if the value in I13 is "". I am a novice with VB, and have tried numerous things without any luck. Any suggestions or help would be appreciated. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Hide Column based on Cell Value
On 20 Jun., 21:11, tomic wrote:
I am trying to hide an entire column - column M, based on the value in Cell I13. I would like column M to be hidden if the value in I13 is "". I am a novice with VB, and have tried numerous things without any luck. Any suggestions or help would be appreciated. Hi This is an event code, which needs to be in the codesheet for the desired sheet. Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$I$13" Then If Target.Value = "" Then Columns("M").Hidden = True Else Columns("M").Hidden = False End If End If End Sub Regards, Per |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Hide Column based on Cell Value
Thanks very much. That did exactly what I wanted it to do.
"Per Jessen" wrote: On 20 Jun., 21:11, tomic wrote: I am trying to hide an entire column - column M, based on the value in Cell I13. I would like column M to be hidden if the value in I13 is "". I am a novice with VB, and have tried numerous things without any luck. Any suggestions or help would be appreciated. Hi This is an event code, which needs to be in the codesheet for the desired sheet. Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$I$13" Then If Target.Value = "" Then Columns("M").Hidden = True Else Columns("M").Hidden = False End If End If End Sub Regards, Per |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hide or Unhide Column Based on Cell Value | Excel Programming | |||
| Hide column or row based on a cell in the column or row? | Excel Discussion (Misc queries) | |||
| Hide Row/s (single/grouped) based on cell value of column in the r | Excel Programming | |||
| Hide/Unhide column based on cell value | Excel Programming | |||
| Hide column based on data value | Excel Discussion (Misc queries) | |||
Linear Mode
