View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Santa-D Santa-D is offline
external usenet poster
 
Posts: 34
Default Macro to hide rows based on criteria

I am in the process of doing end of year financial reporting analysis
and I want to be able to run a macro that hides empty rows based on a
specific criteria.

Column C lists the accounts codes, column G is the YTD Actuals and
column H is the YTD Budget.

What I want to do, is.....

If there is a value in a row in Column C and if the value of the cell
in both column G & H is 0 the hide the row.

If anyone can point me in the right direction to research this further
would be sincerely appreciated.

PS: I am using MS Excel 2003