Hello, I would like to be able to click a button and unhide 10 rows. Then click the same button and have them hide those rows. I have the macro to unhide the rows, I just don't know how to make the same button hide them if they aren't hidden. Can anyone help me with that. My understanding of VBA is extremely limited. Thank you in advance. Here is my macro so far:
HTML Code:Sub MultiYear_Show() ' ' MultiYear_Show Macro ' ' Rows("10:20").Select Selection.EntireRow.Hidden = False End Sub