using formulas in excel vba

[Bedlam]

Hi, I have a formula that works when i manually put it into excel... =IF(AND(ISTEXT($A12),ISERROR(MATCH($A12,$C:$C,0))),$A12,"") However when I try to use vba to put it into cell E12 I get compile error 1004 this is giving me a headache so I thought I would ask here... I'm not sure if this would copy the formula down all the way to the end of the loop and change the values like it would if you pressed ctrl + d in excel, if someone could help me out i would appreciate it. Here is my code

Please Login or Register  to view this content.

[arlu1201]

You have not assigned "NumRows" to anything. Since it is empty, the loop will not work at all.

Also you will need to use the formula this way -

Please Login or Register  to view this content.

[Bedlam]

no i just did a snippet of my code. I have already defined it...

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[royUK]

Why do you need to?

I can't tell what NumRows but this might be what you want

Please Login or Register  to view this content.