Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to hide rows?
I'm stumped on hiding all the rows in a range.
How can this be done? Thanks. John Wirt |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Group rows (or hide rows) like in MS Project | Excel Worksheet Functions | |||
Macro code to hide rows and not calculate hidden rows | Excel Discussion (Misc queries) | |||
Enabling option „Format rows“ to hide/unhide rows using VBA-code? | Excel Discussion (Misc queries) | |||
cut rows without cutting hide rows | Excel Discussion (Misc queries) | |||
Hide Rows - copy and paste only rows that show | Excel Worksheet Functions |