View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
chrismv48 chrismv48 is offline
external usenet poster
 
Posts: 11
Default Hide rows with value of 0

Hello,

This is a fairly common question relating to hiding rows, but mine comes
with a bit of a twist.

I get a monthly spreadsheet that is generated to have a formatting that
hides a lot of particular rows to begin with. This precludes me from using
filters. In addition to the rows already hidden, I'd like to hide the rows
that contain a 0 in both columns N & R.

Ideally I'd like to be able to run this macro on a selection, but all
suggestions are welcome.

Thanks.