Current location - Plastic Surgery and Aesthetics Network - Plastic surgery and medical aesthetics - Ask the teacher to help explain this VBA code, and analyze the 32767 line error overflow (error 6) option Ex.
Ask the teacher to help explain this VBA code, and analyze the 32767 line error overflow (error 6) option Ex.
Size is out of range of integer type:

Integer data type

Integer variables are stored in the form of 16 bits (2 bytes) ranging from -32768 to 32767. The type declaration character of an integer is a percent sign (%).

Long data type

Long integer variables are stored as 32-bit (4 bytes) signed values ranging from -2,147,483,648 to 2,147,483,647. The type declaration character of Long is ampersand; )。

Just change all Integer to Long. If you need a larger number, you can delete this type.