Solved: hiding Rows using index number

[Salvo]

Using VBA I am trying to reference a cluster of rows to hide in an excel spreadsheet using indexes. Because the rows are variable I can not use a statement such as rows("4:12").hide which only references fixed rows. I can hide each row individually but i find this takes a long time as there are numerous rows to delete (even with screen updating turned off) and the row locations are variable.
Can anyone suggest a way to achieve my aim.
Many thanks

[Bob Phillips]

[vba]

Rows(myVar).Resize(12).Hidden = True
[/vba]

[mdmackillop]

Turning Bob's code into a routine to which you can easily refer

[VBA]
Sub test()
Call HideRows(4, 12)
End Sub

Sub HideRows(Strt As Long, Rws As Long)
Rows(Strt).Resize(Rws).Hidden = True
End Sub

[/VBA]

[Bob Phillips]

Turning Bob's code into a routine to which you can easily refer

[VBA]
Sub test()
Call HideRows(4, 12)
End Sub

Sub HideRows(Strt As Long, Rws As Long)
Rows(Strt).Resize(Rws).Hidden = True
End Sub

[/VBA]

Maybe it would be best to make the visibility parameterised as well

[vba]

Sub test()
Call HideRows(4, 12, True)
End Sub

Sub HideRows(Strt As Long, Rws As Long, state As Boolean)
Rows(Strt).Resize(Rws).Hidden = state
End Sub
[/vba]