VBA generates the @ symbol in a formula

[nigelk]

I have the following code

.Range("aN4").formula = "=MAX(IF((C3:C" & rownumber & "=$Aj$4), F$3:F" & rownumber & "))"

However this generates : =MAX(IF((@C3:C30=$AJ$4), F$3:F30))
It doesn't work unless I manually remove the symbol. Is there a way to stop it?

 

[Joe4]

Try:

.Range("aN4").formula2 = "=MAX(IF((C3:C" & rownumber & "=$Aj$4), F$3:F" & rownumber & "))"

 

[nigelk]

Try:

.Range("aN4").formula2 = "=MAX(IF((C3:C" & rownumber & "=$Aj$4), F$3:F" & rownumber & "))"

Thanks works just fine thanks. What a pain that @ is.

 

[Joe4]

You are welcome.