excel hiddden rows and colums - one last question

Giganews Newsgroups
Subject: excel hiddden rows and colums - one last question
Posted by:  Nils (anonymo…@discussions.microsoft.com)
Date: Tue, 28 Oct 2003

I used the following information from
>Earl Kiosterud
>mvpearl omitthisword at verizon period net
and it is excellent for rows and colums to be hidden if a
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
========================================================

Replies