tryingmybest418
New Member
- Joined
- Jan 22, 2018
- Messages
- 32
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!
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!