Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide rows outside a known range of rows
Using Office 2003 on Windows XP;
Suppose I have two variables containing a row number such as: lRowLO = 558 lRowHI = 672 I want to programmatically hide all rows outside of those contained within that range. The low and high delimiter row numbers should not be hidden. Also, the ranges contained by the variables are dynamic. Anyone got some code to do this quickly and cleanly? Thanks much in advance for your assistance. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide rows outside a known range of rows
Something like:
Rows("1:557").Select Selection.EntireRow.Hidden = True Rows("673:999").Select Selection.EntireRow.Hidden = True Not sure if it will break if you don't have 999 rows though... "XP" wrote: Using Office 2003 on Windows XP; Suppose I have two variables containing a row number such as: lRowLO = 558 lRowHI = 672 I want to programmatically hide all rows outside of those contained within that range. The low and high delimiter row numbers should not be hidden. Also, the ranges contained by the variables are dynamic. Anyone got some code to do this quickly and cleanly? Thanks much in advance for your assistance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hide rows within a range IF... | Excel Programming | |||
Hide all rows within a range except one? | Excel Discussion (Misc queries) | |||
Hide columns & rows that contain "0" or blank in a range of cells | Excel Worksheet Functions | |||
Hide blank rows in a range | Excel Programming | |||
Hide Unused Cols & Rows in a Range | Excel Programming |