HIDING ROWS BASED ON TWO CELL VALUES

Hello from Australia.   I am new to VBA (cut my teeth on Fortran, so I am an old timer).

I need to have the VBA that tests

   The trigger cell (Y/N) to hide rows, and if Y

      then to test the value of the last cell in each row (=0 or 1),

         and the hide those cells having the last cell in a row = 0.

Also, to reverse the above action, by the trigger value being N.

 

Would very much appreciate your assistance.

 

Andy

By: Andy MCNABB

Leave a Reply

Your email address will not be published. Required fields are marked *