Try the following
Sub HideRows_Based_On_Values() If Range("C2").Value = "n" then For each cell in Range("C3:C20") .entireRow.Hidden = True Next Cell End If End Sub
Try the following
Sub HideRows_Based_On_Values() If Range("C2").Value = "n" then For each cell in Range("C3:C20") .entireRow.Hidden = True Next Cell End If End Sub
Remember To Do the Following....
Use [Code].... [/Code] tags when posting code to the thread.
Mark your thread as Solved if satisfied by using the Thread Tools options.
If posting the same issue to another forum please show the link
Posting Permissions
Reply With Quote