I got the Worksheet_Calculate but am struggling to get the correct code to do what I need.
The following code works using the Worksheet_Activate event but i want it to work using Worksheet_calculate! The code needs to refer to say "sheet1" and I cannot seem to get it right!
Any ideas?
If Range("O54") = 0 Then Range("O54").EntireRow.Hidden = True
If Range("O54") > 0 Then Range("O54").EntireRow.Hidden = False