Help prevent "@" from being added to VBA written OFFSET formulas

[braindiesel]

I have code writing a complex function... what the formula does is irrelevant...
ActiveCell.Formula = "=HOUR(SMALL((OFFSET($A$2,MATCH(F3,$A$3:$A$" & myBot & ",0),1,COUNTIF($A$3:$A$" & myBot & ",F3),1))*(OFFSET($A$2,MATCH(F3,$A$3:$A$" & myBot & ",0),2,COUNTIF($A$3:$A$" & myBot & ",F3),1)=1),ROWS($G$3:G3)+COUNTBLANK(OFFSET($A$2,MATCH(F3,$A$3:$A$" & myBot & ",0),2,COUNTIF($A$3:$A$" & myBot & ",F3),1))))"

In the cell, the macro writes what I want but adds in two @ characters
=HOUR(SMALL((@OFFSET($A$2,MATCH(F3,$A$3:$A$12,0),1,COUNTIF($A$3:$A$12,F3),1))*(@OFFSET($A$2,MATCH(F3,$A$3:$A$12,0),2,COUNTIF($A$3:$A$12,F3),1)=1),ROWS($G$3:G3)+COUNTBLANK(OFFSET($A$2,MATCH(F3,$A$3:$A$12,0),2,COUNTIF($A$3:$A$12,F3),1))))

It results in a NUM! error.
When I remove the 2 added @ symbols, the formula works perfectly

How do I prevent Excel from breaking my formula

 

[MARK858]

The OP does not have his version in his profile so this did not occur to me. Thanks.

A problem with a fair few posters at the moment I'm afraid ?
Happy the info Helped.

I teach Microsoft Office. I have all of the versions but living in 365 now

It would be a great help to the responders if you could update your profile when you get time. Thanks

 

[braindiesel]

A problem with a fair few posters at the moment I'm afraid ?
Happy the info Helped.


It would be a great help to the responders if you could update your profile when you get time. Thanks

Looking for where to put in info now.

 

[MARK858]

Click Where your Avatar and UserName is at the top of the page and it is under Account Details