PaulFogel123
Member
I have a line of code in my workbook that distinguishes between two different conditions:
where TrueMonth3 and Month3 are named cells. I'm trying to duplicate this formula in VBA:
AND(TrueMonth3,Month3Total>0), AND(TrueMonth3,Month3Total=0).
Yet the macro executes the code that follows as if these two statements aren't even there!
I can't send the file because it's huge. Any ideas?
If Range("TrueMonth3") = True And Range("Month3Total") > 0 Then |
If Range("TrueMonth3") = True And Range("Month3Total") = 0 Then |
where TrueMonth3 and Month3 are named cells. I'm trying to duplicate this formula in VBA:
AND(TrueMonth3,Month3Total>0), AND(TrueMonth3,Month3Total=0).
Yet the macro executes the code that follows as if these two statements aren't even there!
I can't send the file because it's huge. Any ideas?