Error Inserting Formula using VBA

[tryingmybest418]

Hi all,

I'm trying to get my macro to insert a formula into a cell. Basically, if the value in the column "Start Date" is found in the group US_Dates (which I've stored in AI2:AI60), then leave N9 blank. Otherwise, show "ERROR"

It's throwing:
Run-time error '1004':
Application-defined or object-defined error

Range("N9").FormulaR1C1 = "=IF(ISNUMBER(MATCH(Table1[@[Start Date]],US_Dates,0)),""""=,""ERROR"")"

Thanks!

 

[VBA Geek]

"=IF(ISNUMBER(MATCH(Table1[@[Start Date]],US_Dates,0)),""""=,""ERROR"")"

i think that needs to go

 

[tryingmybest418]

Hahaha wow... thank you. I think I've been staring at this too long.