ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How to hide rows? (https://www.excelbanter.com/excel-programming/307676-how-hide-rows.html)

John Wirt[_6_]

How to hide rows?
 
I'm stumped on hiding all the rows in a range.

How can this be done?

Thanks.

John Wirt



Bruno[_2_]

How to hide rows?
 
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





Bob Umlas

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








All times are GMT +1. The time now is 03:02 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com