View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
chrismv48 chrismv48 is offline
external usenet poster
 
Posts: 11
Default 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?