@ appears in my sheet reference formula - macro

Hi everyone

=INDEX(Notes!K5:K122,(MATCH(1,IF(Notes!$H$5:$H$122<=Sheet2!C6,IF(Notes!$I$5:$I$122>=Sheet2!C6,1)),0)))

So I have the above formula and i am trying to populate the same in a cell using a macro, but when i run the macro it changes to =INDEX(Notes!K5:K122,(MATCH(1,IF(@Notes!$H$5:$H$122<=Sheet2!C6,IF(@Notes!$I$5:$I$122>=Sheet2!C6,1)),0))) and the formula doesn't work, but i remove the "@" it works fine.  

Any idea why the "@" is coming up ?   I think its the new way of referencing a sheet in the new excel, but not sure what should be the correct version