I have a sheet with regions listed and a selector to choose whether or not to "enable" the region. If "yes" is selected, the value 1 is returned, if "no" is selected the value 0 is returned.
I want to write the macro like the one below, but instead of listing the rows as ranges I need to refer to multiple, specific rows. Ex. 15, 18, 23.
Thanks![]()
Private Sub Worksheet_Calculate() If Range("D7").Value = 0 Then Rows("15:25").Hidden = False Want to list specific rows here, not a range of rows End If If Range("D7").Value = 0 Then Rows("26:35").Hidden = True End If
Bookmarks