Complie error: Expected: end of statement
Hi,
Firstly it's not an array formula and so no need for FormulaArray and second
double up on the quotes to solve your problem
Range("A1").Formula = "=if(B1=""Loan"",D1,0)"
Mike
"diepvic" wrote:
Hi,
I've got a macro code as below:
Range("A1").FormulaArray = _
"=if(B1="Loan",D1,0)"
And it causes a compile error. How should I fix it if I want to keep the
text Loan in my formula.
Thanks so much
|