Hello,
Our agency recently upgraded to Excel for Microsoft 365 MSO (version 2302).
In one of my VBA scripts, I have this formula:
When I run my script, I see this in Cell(s,6)
But this gives me a result of #DIV/0
When I remove the @ symbol, I get the correct answer.
How can I prevent @ from showing up?
Thank you!
Dennis
Our agency recently upgraded to Excel for Microsoft 365 MSO (version 2302).
In one of my VBA scripts, I have this formula:
VBA Code:
Cells(s, 6) = "=sum(1/countif(F8:F" & s - 1 & ", F8:F" & s - 1 & "))"
When I run my script, I see this in Cell(s,6)
Code:
=SUM(1/COUNTIF(F8:F26,@ F8:F26))
But this gives me a result of #DIV/0
When I remove the @ symbol, I get the correct answer.
How can I prevent @ from showing up?
Thank you!
Dennis