Forum Discussion
GeorgieAnne
Mar 22, 2025Iron Contributor
Why is MS-Excel adding an "@" to my formula and breaking it???
Hello Excellers, This is so annoying and it is breaking my formula. I hope someone has a good solution: In VBA I have these two lines: Range("N1").Value = "3/24/2025" Range("N2").Formula = "=I...
- Mar 22, 2025
Use
Range("N2").Formula2 = "..."
HansVogelaar
Mar 22, 2025MVP
Use
Range("N2").Formula2 = "..."
- GeorgieAnneMar 26, 2025Iron Contributor
Thank You HansVogelaar
That did the trick. After your reply I went to read up on the differences between Formula and Formula2.