Hi,
You don't need to increase rows in Excel 2007/2010 to 1048576 from 65536. Also, there is no way to accomplish it. The problem you're facing is due to the use of .xls file which are of Excel 2003 or prior format. Workaround: 1. Save your .xls file as .xlsx (if there are no macros in it) or as .xlsm(if there are macros in it) This step don't increase the rows as if you'll see the title bar of Excel, it still says Combatibility mode. 2. To come out of it, close the saved workbook and re-open it. ------------------------------ Excel VBA Interview Questions<http://www.excelitems.com/2010/12/excel-vba-interview-questions.html> Collection of Excel VBA Macros<http://www.excelitems.com/2008/09/vba-macro-codes-examples-collection.html> VLOOKUP<http://www.excelitems.com/2009/03/how-to-use-vlookup-function.html> OFFSET<http://www.excelitems.com/2011/01/use-offset-function-dynamic-range.html#more> ARRAY formulas<http://www.excelitems.com/2010/06/array-or-cse-formulas-and-functions-in.html> ------------------------------ Excel 2003 Style Menu in Excel 2007<http://www.excelitems.com/2010/12/excel-2003-style-menu-in-excel-20072010.html> Custom Number Format<http://www.excelitems.com/2011/01/custom-cell-formatting-number-date-text.html> SUMIFS<http://www.excelitems.com/2009/09/difference-between-sumif-and-sumifs.html> CONTACT a TRAINER<http://www.excelitems.com/2009/03/callcontact-trainer-for-excelvbavsto.html> <http://www.excelitems.com/2010/12/excel-2003-style-menu-in-excel-20072010.html> ------------------------------ Thanks & Regards ------------------------------ Ashish Jain (Microsoft Certified Application Specialist) (Microsoft Certified Professional) http://www.excelitems.com http://www.openexcel.com Facebook <http://www.facebook.com/eXceLiTems> Twitter<http://www.twitter.com/eXceLiTems> LinkedIn <http://in.linkedin.com/in/ashishjain08> LiveJournal<http://livejournal.excelitems.com/> Digg <http://digg.com/excelitems> Delicious<http://www.delicious.com/save?new=1&url=http%3A%2F%2Fwww.excelitems.com%2F&title=MS%20Excel%20VBA%20%26%20VSTO%20Macros%2C%20Functions%2C%20Tutorials%20%26%20Downloads&type=BOOKMARK&jump=http://www.delicious.com%2Fmountint&key=Nyn3Hc9oMaEzmGO_Fg_jkAwe1hI-©user=mountint&via=mountint©tags=eXceLitems+Office+Microsoft+Functions+Formulas+VBA+VSTO+Excel2010+Excel2007+excel2003+Excel+Bookmarks_Menu+eXceLiTems.com> Subscribe by Email<http://feedburner.google.com/fb/a/mailverify?uri=excelitems> ------------------------------ -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel