Error 6: Overflow VBA

Cause:  An overflow results when you attempt an assignment that exceeds the limits of the assignment’s target.


To correct this error

1.Make sure that results of assignments, calculations, and data type conversions are not too large to be represented within the range of variables allowed for that type of value, and assign the value to a variable of a type that can hold a larger range of values, if necessary.
2.Make sure assignments to properties fit the range of the property to which they are made.
3.Make sure that numbers used in calculations that are coerced into integers do not have results larger than integers.