You could do this with a worksheet_change event.
Right click sheet tabview codeinsert thismodify to suitSAVE

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address < "$J$2" Then Exit Sub
If Target = 1 Then
Range("a1,a4,a8").EntireRow.Hidden = True
ElseIf Target < 1 Then
Cells.EntireRow.Hidden = False
End If
End Sub

--
Don Guillett
SalesAid Software

wrote in message
ups.com...
I have a system of IF functions that contain vlookups on a worksheet.
They pull data from a separate "raw data" page. Depending on certain
values in the data page, I have it set up so that some rows come up
entirely blank on my view page.

I would like to automatically hide these blank rows so that if the
right thing is changed on the data page, these rows will reappear with
the relevant information. Does this make sense? Anybody know how to
do this?

Thanks!