Error in VBA for formula array - IF ISNA MATCH

[jwoo89]

Hi All -

I am getting an error when i post this into my VBA maco as a formula array.

=IF(ISNA(MATCH(LEFT(AJ3,3)&" * ",Indexes!$A$1:$A$100,0)),AM3,AM3*100)

But when i post it to excel as a regular formula it works.

Can someone please provide some help?

Thank you!

 

[Joe4]

Why don't you turn on your Macro Recorder, and record yourself entering the formula into the worksheet.
Then, if you stop the Macro Recoder and view your code, you should have the VBA code you require.

 

[Alex Blakenburg]

Did you double the quote marks ?

ActiveCell.Formula = "=IF(ISNA(MATCH(LEFT(AJ3,3)&"" * "",Indexes!$A$1:$A$100,0)),AM3,AM3*100)"