Just so we are all on the same page... 16bit variables such as integers lose
their benefits since the systems all 32bit. There is actually extra overhead
to deal with an integer over a long... so long is more efficient.

--
HTH...

Jim Thomlinson


"Dave Peterson" wrote:

For numbers???

I use "As Long", never "As Integer".
I use "As Double", never "As Single".

No matter how small/large they may be.


R Tanner wrote:

Hi,

Do you choose the data type you will declare at the beginning of a
macro based on what range you know your values will be between?

--

Dave Peterson