Don't use "As Integer"; use "As Long".

Don't use "As Single"; use "as double".



JingleRock wrote:

I have read that the Overflow Error is frequently associated with
variable declaration. Do you have any suggestions, other than trial
and error in changing declarations, for troubleshooting this error?
Thanks for your help.

--

Dave Peterson