I often see questions relating to
Overflow errors with vba.
My question is why use the
integer variable declaration instead of just defining all numerical variables (excluding
double etc.) as
Unless you're performing an operation like in a for loop where you can guarantee that the value won't exceed the 32,767 limit, is there an impact on performance or something else that would dictate not using