Thread
:
inserting formulae
View Single Post
#
3
Posted to microsoft.public.excel.worksheet.functions
JE McGimpsey
Posts: n/a
inserting formulae
Just as in XL, double the quotes:
A1.formulaArray = "=-IF(UPPER($EC$14)=""Y"",AH22*AI22,..."
In article .com,
wrote:
I am a novice in programming excel. I am trying to insert formula
through macro in a cell by using Formulaarray. I am encountering a
peculiar problem.
Formula i want to insert is
=-IF(UPPER($EC$14)="Y",AH22*AI22,AN22)*R22*SUMIF(PAY MENT_INDEX,"="
&F22,RNG_OPT_PREM)/COUNTIF(PAYMENT_INDEX,&F22)
Now if i want to insert it in A1 say,
i would write
A1.formulaArray =
"=-IF(UPPER($EC$14)="Y",AH22*AI22,AN22)*R22*SUMIF(PAY MENT_INDEX,"="
&F22,RNG_OPT_PREM)/COUNTIF(PAYMENT_INDEX,&F22)"
But VBA recognizes the starting inverted commas of the "Y" as the end
of formula and gives me syntax error.
How do i overcome this?
Thanks
Reply With Quote