Conditional hide column
Solved/Closed
Related:
- Conditionally hide columns in excel
- Conditional hiding - Best answers
- Excel conditional hide column - Best answers
- Excel Macro help, hiding columns ✓ - Forum - Excel
- Excel conditional formatting column based on another column ✓ - Forum - Excel
- Compare two columns in excel for partial matches - How-To - Excel
- How to create a drop down list with multiple columns in excel - How-To - Excel
- How to combine debit and credit columns in excel ✓ - Forum - Excel
2 replies
venkat1926
- Posts
- 1864
- Registration date
- Sunday June 14, 2009
- Status
- Contributor
- Last seen
- August 7, 2021
i am rephrasing it
1. if type 1 in A1 column E should be hidden
2. If I type any other number column E should be visible
in that case
right click sheet tab and click view code
in the window that comes up copy this EVENT CODE
now type some number in A1. if it is 1 colum E will be hidden
if it some other number the column E will not be hidden
if you enter in any cell other than A1 nothing will happen
do some experiments.
1. if type 1 in A1 column E should be hidden
2. If I type any other number column E should be visible
in that case
right click sheet tab and click view code
in the window that comes up copy this EVENT CODE
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address <> "$A$1" Then Exit Sub
If Target = 1 Then
Range("e1").EntireColumn.Hidden = True
Else
Range("e1").EntireColumn.Hidden = False
End If
End Sub
now type some number in A1. if it is 1 colum E will be hidden
if it some other number the column E will not be hidden
if you enter in any cell other than A1 nothing will happen
do some experiments.
