I have this formula below in excel that hide and unhide row. I want to make it a dynamic reference. So instead of using Range "B50" or range "51:68". I would like to set the said reference to a cell value so that I can change them any time without opening VBA.
Formula:
If Not Intersect(Target, Range("B50")) Is Nothing Then Cancel = True
If (Not Intersect(Target, Range("B50")) Is Nothing) And (Target.Count = 1) Then
Set hideRows = Range("51:68")
hideRows.EntireRow.Hidden = Not hideRows.EntireRow.Hidden
End If
If Not Intersect(Target, Me.Range(Sheet1.Range("A1").Value) Is Nothing Then
– Tim Williams