hiding rows based on cell contents

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
Back
Top