Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide rows of active selection
Hello--
I have a huge amount of information that comes in monthly that is always formatted/positioned in the exact same way. Only differences are cell values. I'd like to build a macro that would allow the user to automatically hide rows that contain a 0 for column's N and K. However there are blocks of data for which I would not want to hide, so I was thinking if the user can just select the relevant data he/she wants to run the macro on, that'd be best. Any suggestions? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Active range/selection? | Excel Worksheet Functions | |||
Object Type of a selection... counting rows in a selection | Excel Programming | |||
Changing active selection cursor | Excel Discussion (Misc queries) | |||
Hide Rows based on Time Selection in timesheet. | Excel Programming | |||
Looping thru the active selection | Excel Programming |