Numeric precision in Microsoft Excel: Difference between revisions

Revision as of 16:12, 2 July 2010

Revision as of 10:49, 3 July 2010

Line 139:

</ref>), [[Visual basic for applications|VBA]] has a variety of data types. The ''Double'' data type is 8 bytes, and the ''Integer'' data type is 2 bytes.<ref name=John_Walkenbach>

{{cite book |title=Excel 20072010 powerPower programmingProgramming with VBA |chapter=Defining data types |pages=194–197198 ''ff'' and Table 8-1|isbn=04700440120470475358 |author=John Walkenbach |year=20072010 |publisher=Wiley |url=http://books.google.com/books?id=HxhXwdUSTe0CdtSdrjjVXrwC&pg=PA194PA198}}

</ref> Choice of variable types in a VBA calculation involves consideration of storage requirements, accuracy and speed.