hiding rows based on cell contents

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.
 
R

Roger Govier

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hide and Show Rows based on Cell Value 2
Hiding rows or columns based on cell contents 3
How to insert new worksheet based on # of rows in a data sourch 2
Disabling hiding rows 2
How to hide rows in an Excel worksheet based on a variable 2
Macro to hide sheets based upon cell value 3
Enabling option „Format rows“ to hide/unhide rows using VBA-code? 0
hiding or showing rows based on a cell value 6

Top