N
Nils
I used the following information from
value is entered into a cell.
However, one last question, how do I use it together on
the same sheet to hide a row and colum at the same time?
=====================================================
and it is excellent for rows and colums to be hidden if aEarl Kiosterud
mvpearl omitthisword at verizon period net
value is entered into a cell.
However, one last question, how do I use it together on
the same sheet to hide a row and colum at the same time?
=====================================================
========================================================Private Sub Worksheet_Change(ByVal Target As Range)
Set TestCell = Range("J5")
TestValue = "stuff"
If TestCell = TestValue Then
Range("B1").EntireColumn.Hidden = True
Else
Range("B1").EntireColumn.Hidden = False
End If
End Sub