VBA is Adding @ Symbol to Formula, Making it Not Work!

I have a formula to lookup credit card billing descriptions and find matching payee names. I have named ranges of DescriptionPhrases and matching PayeeNames. For example, the Description Phrase "EXXON" is matched with the Payee Name "ExxonMobil". This matching is necessary since each Exxon station can have a different description in the credit card billing info (such as EXXON ROSEDALE or EXXON #1234). I need any description containing "EXXON" to match to the Payee Name "ExxonMobil". So my formula checks whether each entry in DescriptionPhrases appears anywhere within the description text in the credit card billing info, and (if found) assigns the matching entry from PayeeNames.

My formula (credit card description is in column F) is (for example):

Please Login or Register  to view this content.

The problem arises when I now use macro code to write this formula into a column in my data sheet:

Please Login or Register  to view this content.

When the macro runs, the formula that actually gets pasted in has an ADDED "@" SYMBOL:

Please Login or Register  to view this content.

which causes it to NOT WORK!

Why is VBA adding this "@" symbol that is NOT in my code, and is there any way to prevent this from happening (or some other workaround)?

Try using .Formula2R1C1

Originally Posted by Eeza Goodun

Try using .Formula2R1C1

THANK YOU!! That worked!

No problems. Thanks for the rep.