Excel VBA（错误 6） 溢出:当赋值超出目标的限制时，就会发生溢出。此错误有以下的原因和解决方法： Excel VBA (error 6) Overflow: When the assignment beyond the target limit, it will overflow. This error has the following causes and solutions: 赋值、计算或数据类型的结果的转换太大，以致于不能在变量类型所允许的范围内表示出来。赋值给足够表示值的范围的类型的变量上。 Assignment, calculation results or data type conversion is too large, so that the variable type can not be allowed within that out. Enough that the value assigned to the range of types of variables. 给属性的赋值超过属性能接受的最大值。确保赋值适合属性的范围。试图在计算中使用一个数字，并且该数字被强制为一个整数，但是结果超过了整数的范围，例如： Assign properties to the property exceeds the maximum acceptable. Ensure that the scope of the assignment for the property. Trying to use a number in the calculation, and the number is forced to an integer, but the results exceeded the range of integers, for example: Dim x As Long x = 2000 * 365 ‘ 错误: 溢出要解决这个问题，请按如下方式键入该数字：To solve this problem, type the number as follows: Dim x As Long x = CLng(2000) * 365详细信息，可选取有问题的项目，并按下 F1 （在Windows中）或HELP（在Macintosh中）键。For more information, select the item in question and press F1 (in Windows) or HELP (Macintosh) key. 因为有梦，所以勇敢出发，选择出发，便只顾风雨兼程。
