View Single Post
  #2   Report Post  
Spencer101 Spencer101 is offline
Senior Member
 
Posts: 663
Default

Quote:
Originally Posted by François Delepine View Post
I have a big worksheet containing historical cash flow movements. I need to automatically hide the rows where the first cell (column A) of the row is containing a specific value (999).
Is there a way to achieve this without a macro? If not what would be the code to insert?
You could use a filter set to column A does not equal 999.

That would hide all of those rows.

Is that what you mean?