开发者

Excel 2007 rows limit for Excel 2003 macros

开发者 https://www.devze.com 2023-01-11 09:29 出处:网络
I un开发者_运维百科derstand that Excel 2003 has 65,536 rows limitation which was increased to 1,048,576 in Excel 2007.

I un开发者_运维百科derstand that Excel 2003 has 65,536 rows limitation which was increased to 1,048,576 in Excel 2007.

My question is : If a macro targets Excel 2003, and is opened in Excel 2007, does the 65,536 rows limit still apply?

Thanks in advance.


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:

http://www.excelforum.com/excel-programming/649719-problem-excel-2003-row-limit-65k-affecting-my-excel2007-macros.html

0

精彩评论

暂无评论...
验证码 换一张
取 消