Excel 2003宏的Excel 2007行限制 [英] Excel 2007 rows limit for Excel 2003 macros
本文介绍了Excel 2003宏的Excel 2007行限制的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
我了解Excel 2003的行数限制为65,536，在Excel 2007中增加到1,048,576.
I understand that Excel 2003 has 65,536 rows limitation which was increased to 1,048,576 in Excel 2007.
我的问题是:如果宏以Excel 2003为目标并在Excel 2007中打开，则65,536行的限制是否仍然适用?
My question is : If a macro targets Excel 2003, and is opened in Excel 2007, does the 65,536 rows limit still apply?
谢谢.
推荐答案
如果您在2007年工作，则该限制为1,048,576行.
If you're working inside 2007 the limit that will apply is 1,048,576 rows.
请参见以下示例，以了解破坏您的聚会的情况:
See this for an example of what can break your party:
