Greeting!
I am using the following to hide rows (rows 25 - 43, with column L may or may not contain "Hide"), however I cannot figure out how to rewrite the code to un-hide all the rows (even the rows containing "Hide").
Sub Allen_Hide_1() For a = 25 To 43 Sheet11.Rows(a).Hidden = IIf(Sheet11.Cells(a, 12).Value = "Hide", True, False) Next End Sub
Bookmarks