hiding rows based on cell contents
 

I want to hide certain rows in one worksheet based on the value from another
worksheet. For example, hide rows 1-10 based on the value of FALSE in cell
A1 from the other worksheet. I am assuming VBA code is needed, but I am not
that familiar with VBA other than creating simple macros. Any help would be
greatly appreciated!!

Thanks.

hiding rows based on cell contents
 

Hi Jason

Try
Sub hiderows()
Sheets("Sheet1").Rows("1:10").EntireRow.Hidden = False
If Sheets("Sheet2").Range("A1") = False Then
Sheets("Sheet1").Rows("1:10").EntireRow.Hidden = True
End If
End Sub

--
Regards

Roger Govier


"Jason M" wrote in message
...
I want to hide certain rows in one worksheet based on the value from
another
worksheet. For example, hide rows 1-10 based on the value of FALSE in
cell
A1 from the other worksheet. I am assuming VBA code is needed, but I
am not
that familiar with VBA other than creating simple macros. Any help
would be
greatly appreciated!!

Thanks.