I need to change my macro code so the macro will use a range based upon a name I've given it (insert -> Name->Define), instead of a fixed cell range. Currently my code is as follows:
Private Sub ComboBox10_Change()
Application.ScreenUpdating = False
Select Case ComboBox10.Value
Case "0"
Rows("754:817").EntireRow.Hidden = True
Case Else
Rows("754:817").EntireRow.Hidden = False
End Select
End Sub
The range in the sample is 754:817. I need it to just look up a name range that has those cells, like the range list1, for example. Any help is appreciated.
If you don't understand what I'm asking for then please reply and I'll clarify.
Bookmarks