Hi,
I am trying to hide rows 78 to 84 if cell C75 is populated with 'Hold', 'Insolvency' or 'other' and show if any other option is selected 'Plan' or 'SST' but it is hiding only row 79 and 80. Can anybody help?
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address(0, 0) =...