@symbol showing in formula when using VBA

[BradleyS]

When I manually enter this formula (using DNRs):
IF(REASONTBL<>"<No Selection>",REASONTBL=K2,1) into a cell it works fine.

However, when I use VBA
Range("L2").Formula = "=IF(REASONTBL<>""<No Selection>"",REASONTBL=K2,1)"

it shows in the cell as: IF(@REASONTBL<>"<No Selection>",@REASONTBL=K2,1) and doesn't work due to the @ symbols that have appeared.

Why is it doing this and how can I resolve it?

 

[Fluff]

You need to use Formula2, rather than Formula.

I would also suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[BradleyS]

Thank you that worked great. I have also updated my account details.

 

[Fluff]

Thank you that worked great.

You're welcome & thanks for the feedback.

I have also updated my account details.

Thanks for that, however if you are getting the @ sign then you must be using either 365 or 2021.

 

[BradleyS]

I am personally, but when I use it at the office, they only have 2010, so I always need to make sure it works in 2010.

 

[Fluff]

Ok, fair enough, but using Formlua2 will probably return an error when using 2010 as it didn't exist then.

 

[BradleyS]

Ah. OK so the @ symbol will not appear in 2010, which means I can still use "formula" and it will still work. Even though it's showing an error in my 365 version.
I can work with that. Thank you

 

[Fluff]

OK so the @ symbol will not appear in 2010, which means I can still use "formula" and it will still work

That's right.

 

[BradleyS]

Thank you for all your help.

 

[Fluff]

My pleasure.