Hi OptionBase1, I think you are right here. I just wrote a Python script to do this, I sheet out of VB, call the .py script
have it store generated values to an array, write the values to a text file, then have VB open the .txt file, import and place
to a column and the values Python creates do match what the Excel sheet formulas return, but when I use Python Im importing
numpy (math sci precision module) and use floats - then the values match what shows in the sheet. The problem tho is
to do all this takes too long, open writing to file, then importing readind from file. So frustrating! I cant imagine why Microsoft
would provide accuracy in the sheet with simple formulas but then cripple a VBA approach so it cant perform as well...
Unbelievable! If I go with Mathematica, I have to leave VB, VBA - very challenging