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. |
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. |
All times are GMT +1. The time now is 11:15 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com