How about As Byte?
I understand there is no point in using Integer instead of
Long as Long is faster (but maybe not measurable) than Integer plus
there is less chance of an overflow error.

RBS


"Dave Peterson" wrote in message
...
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