Hi all,
I wonder if i may ask a question
I have a simple macro to hide rows of which i have 4 different, 3 of these work fine on one tab but the other is the same as the first one but on another tab but takes ages to run
Would there be a way to speed this up like the other 3?
Sub Hide_1()
With Rows("13:20016")
.EntireRow.Hidden = Not .EntireRow.Hidden
End With
End Sub
Sub Hide_2()
With Rows("20025:20528")
.EntireRow.Hidden = Not .EntireRow.Hidden
End With
End Sub
Sub Hide_3()
With Rows("20537:20590")
.EntireRow.Hidden = Not .EntireRow.Hidden
End With
End Sub
Sub Hide_4()
With Rows("13:20016")
.EntireRow.Hidden = Not .EntireRow.Hidden
End With
End Sub
Many thanks for any help
I wonder if i may ask a question
I have a simple macro to hide rows of which i have 4 different, 3 of these work fine on one tab but the other is the same as the first one but on another tab but takes ages to run
Would there be a way to speed this up like the other 3?
Sub Hide_1()
With Rows("13:20016")
.EntireRow.Hidden = Not .EntireRow.Hidden
End With
End Sub
Sub Hide_2()
With Rows("20025:20528")
.EntireRow.Hidden = Not .EntireRow.Hidden
End With
End Sub
Sub Hide_3()
With Rows("20537:20590")
.EntireRow.Hidden = Not .EntireRow.Hidden
End With
End Sub
Sub Hide_4()
With Rows("13:20016")
.EntireRow.Hidden = Not .EntireRow.Hidden
End With
End Sub
Many thanks for any help