Hi
I have a worksheet change event that looks at a range of 11 cells
If any of those changed, then there are 11 If/Else statements under it to either hide or unhide rows on a different tab.
My question is, do I have to do this 11 times or is there a cleaner/better way?
I've named all the various ranges in a similar fashion.
If Sheet2.Range("s8_yn01") = "N" Then
If Sheet8.Range("s8_g01").EntireRow.Hidden = False Then
Sheet8.Range("s8_g01").EntireRow.Hidden = True
Sheet1.Range("s8_v01") = 1 'hidden
End If
Else
If Sheet8.Range("s8_g01").EntireRow.Hidden = True Then
Sheet8.Range("s8_g01").EntireRow.Hidden = False
Sheet1.Range("s8_v01") = 0 'unhidden
End If
End If
If Sheet2.Range("s8_yn02") = "N" Then
If Sheet8.Range("s8_g02").EntireRow.Hidden = False Then
Sheet8.Range("s8_g02").EntireRow.Hidden = True
Sheet1.Range("s8_v02") = 1 'hidden
End If
Else
If Sheet8.Range("s8_g02").EntireRow.Hidden = True Then
Sheet8.Range("s8_g02").EntireRow.Hidden = False
Sheet1.Range("s8_v02") = 0 'unhidden
End If
End If
Bookmarks