Resolved Question: Help with macro to hide rows in excel on button push?
I need a button activated macro to hide/show a set of rows. I am a beginner on VBA, and currently I have been working on the following, but it currently doesn't work:-
Sub Hide_initial()
Set hidden1923 = Range("B19:B23")
'rows I would like to hide
Range("B19:B19").Select
If cell.EntireRow.Hidden = true Then
For Each cell In hidden1923
EntireRow.Hidden = false
End If
Next
If cell.EntireRow.Hidden = False Then
For Each cell In hidden1923
EntireRow.Hidden = True
End If
Next
End Sub
Any help would be much appreciated!
Many thanks in advance
Cheers
Darren
