Excel 2007 rows limit for Excel 2003 macros
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
精彩评论