Formula works in excel but not in vba

M

mniccole

Can someone please tell me what is wrong with this:
When I paste the formula into cell, it works fine, when I try to go
through visual basic, it craps out.
What am I missing....
THANKS SO MUCH

WORKS:
=SUMPRODUCT((BillingHoldDetails!M2:M3000)*(BillingHoldDetails!$A$2:$A$3000="AR"))

WILL NOT WORK
Worksheets("Menu").Range("C18").Formula =
"=SUMPRODUCT((BillingHoldDetails!M2:M3000)*(BillingHoldDetails!$A$2:$A$3000="AR"))"


Doesn't like this:
="AR"))"
 
Top