How to hide rows?

John Wirt · Aug 22, 2004

I'm stumped on hiding all the rows in a range.

How can this be done?

Thanks.

John Wirt

Bruno · Aug 22, 2004

Rows("10:19").Select
Selection.EntireRow.Hidden = True

Bob Umlas · Aug 22, 2004

Don't select.
Rows("10:19").hidden = true

Bob Umlas
Excel MVP