I have tried to write code to show a message if either H11 or H24 has a value that is not zero
No message box pops up where there is a zero that is not zero
It would be appreciated if someone could amend this
No message box pops up where there is a zero that is not zero
Code:
Private Sub Variance()
With Sheets("Sales Recon")
If .Range("H11") Or .Range("H24") <> 0 Then
MsgBox "There is a variance"
End With
End Sub
It would be appreciated if someone could amend this