Excel 2007 rows limit for Excel 2003 macros

1
votes

I understand 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.

1
excelexcel-2007

1 Answers

1
votes

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