Excel VBA

Hi Bob

A variable type Single will hold pretty large numbers.

Bu as a default excel treats numbers entered into worksheets as Doubles.

I have talked to some people who say the extra precision Doubles provide means most algorithms don't need to be optimized for prevention of rounding error. This means that if you use Doubles the numbers will be more accurate in the long run.

So the general consensus is that although Double takes up more memory space it deals with the numbers faster and more accurately than Single

Hope this helps

Carlos