Forum Discussion
Excel inserts '@' Symbol into formulars, which breaks them
Hey Tech community, I am facing the following challenge and hope someone here can explain why it is happening and how to prevent the issue: I have created an Excel template that uses formulars to l...
Do you still get the '@' if you substitute
--(color<>"Blue")
for
IF(A5:A20<>"Blue",1,0)using a defined name for the array and not using IF to coerce the Booleans to values.
Thanks for the reply. When using a defined name for this I get #Value! error in the cell. The error is A value used in the formula is of the wrong datatype.
- I'm using VB.NET not VBA, don't think this is an option.
Doesn't Excel Interop use the same objects, methods and properties as Excel VBA?
