Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hiding Rows in a Range based on column A value
I've been rummaging through the posts regarding finding the last row in
a range. They don't quite get me what I need. My ultimate goal is to created a sub that will hide all rows with the value of "1" in column A. Without creating a loop for the entire worksheet I want to limit the loop to a named range, let's say "print_range". To do that I need to be able to identify the last row of the named range. I don't think that the Count property will give me the last row if the range doesn't begin in row 1. Let's say my named range is from A5:Z999. Any ideas or insights would be greatly appreciated. TIA |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hiding rows in a range based on TRUE/FALSE value in each row | Excel Discussion (Misc queries) | |||
Hiding Specific Rows Based on Values in Other Rows | Excel Worksheet Functions | |||
Need help hiding/unhiding column based on autofilter selection in a different column | Excel Programming | |||
Hiding rows based on a value | Excel Discussion (Misc queries) | |||
Hiding rows based on date | Excel Worksheet Functions |