Forum Discussion

vonryan's avatar
vonryan
Brass Contributor
Apr 27, 2019

Hide Rows Help

Dear All,   I am trying to hide rows on certain conditions. These conditions being that is the Date in a particular row is in the past and an adjacent cell has zero value then hide the entire row. ...
Macros and VBA
aazirasif's avatar
aazirasif
Copper Contributor
Apr 27, 2019
change this code
Case if(Range of Cells (B5:B10) is <= TODAY() AND Cells (E5:E10) > 0, EntireRow.Hidden = True
  • vonryan's avatar
    vonryan
    Brass Contributor
    Apr 27, 2019

    Hi aazirasif 

     

    Thank you for your response. Please advise what to change it too as I do not know.