View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Bob Umlas Bob Umlas is offline
external usenet poster
 
Posts: 301
Default How to hide rows?

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

Bob Umlas
Excel MVP

"Bruno" wrote in message
...
Rows("10:19").Select
Selection.EntireRow.Hidden = True


"John Wirt" wrote in message
...
I'm stumped on hiding all the rows in a range.

How can this be done?

Thanks.

John Wirt