I generally declare my data types based on how I expect the code to execute
and to get the results I need.

"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?