I am putting together a template in Excel for rolling up and summing data. I was planning on using arrays to collect the necessary numbers and then sum them in the end using application.worksheetfunction.sum. However, I am wondering will I lose any accuracy if I use a data type of variant for the arrays? Or should I use double? Is there a big difference?
Red Flag Submitted
Thank you for helping keep Eng-Tips Forums free from inappropriate posts. The Eng-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Eng-Tips forums is a member-only feature.
Cities are ceaseless engines of engineering activity. Itâ€™s likely that while you were on your way to work, you encountered a number of infrastructure development projects under construction. Download Now
When was the last time you drove down the highway without seeing a commercial truck hauling goods?The ubiquity of these machines underscores the important roll they play in modern commerce. Download Now