Hello,
I am having trouble with creating this formula. It keeps giving me the following error, "Compile Error- Expected: )" and it highligths the TRUE part of the code. Can someone please take a look and see if you can identify where the problem is?
Any assistance will be much appreciated.
With Range(Cells(2, iVariable9), Cells(LR, iVariable9))
.Formula = "=IF("AND(" & Cells(2, vVariable9).Address(0, 0) & "<>"""," & _
Cells(2, vVariable9).Address(0, 0) & ">" & Cells(2, vVariable10).Address(0,0) & "), "TRUE", "FALSE"")""
End With
Bookmarks