asked on Excel 2010 Numerical Accuracy
I have a large Excel workbook with VBA macros. I runs it in both Excel 2010 64 bit and Excel 2016 64 bit. However, the output results are different. Any thoughts?
VBAMicrosoft Excel
Last Comment
Martin Liss
Please describe the difference.
However, the output results are different. Any thoughts?could be formatting or data issues?
running both in same machine?
ASKER
The discrepancy is in some of the numerical results written to worksheet cells. There are no problems with the formatting and both the Excel 2010 and 2016 workbooks are running with the same input datafile contained in a separate workbook.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thanks
You’re welcome and I’m glad I was able to help.
If you expand the “Full Biography” section of my profile you’ll find links to some articles I’ve written that may interest you.
Marty - Microsoft MVP 2009 to 2017
Experts Exchange MVE 2015
Experts Exchange Top Expert Visual Basic Classic 2012 to 2017
If you expand the “Full Biography” section of my profile you’ll find links to some articles I’ve written that may interest you.
Marty - Microsoft MVP 2009 to 2017
Experts Exchange MVE 2015
Experts Exchange Top Expert Visual Basic Classic 2012 to 2017