hidding rows depending on content cells

[paul]

Hi

is it possible to hide rows or colums depending on a cells
value.

paul

 

[Bob Phillips]

Paul,

Can be done with worksheet event VBA code

Here's an example that tests for Y in A1:A100

Private Sub Worksheet_Change(ByVal Target As Range)

Application.EnableEvents = False
On Error GoTo ws_exit
If Not Intersect(Target, Range("A1:A100")) Is Nothing Then
If Target.Value = "Y" Then
Target.EntireRow.Hidden = True
End If
End If

ws_exit:
Application.EnableEvents = True
End Sub

As worksheet cod, it goes in the appropriate worksheet code mosule.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Ken Wright]

Rows can be easily hidden by selecting your data, headings included, and then
using Data / Filter / Autofilter / Custom / Not equal to..........