- Joined
- Aug 30, 2010
- Messages
- 1
- Reaction score
- 0
Can't insert a row from one worksheet into another.
I found the answer - number of columns in second worksheet is 16387 per Excel 2007 but the old 2003 worksheet has only 256 columns. Open the Excel 2003 workbook in Excel 2007, then save as .xlsm if it had macros or .xlsx if it had no macros. When I reopen it, is has 16387 columns and my old macro runs perfectly.
I found the answer - number of columns in second worksheet is 16387 per Excel 2007 but the old 2003 worksheet has only 256 columns. Open the Excel 2003 workbook in Excel 2007, then save as .xlsm if it had macros or .xlsx if it had no macros. When I reopen it, is has 16387 columns and my old macro runs perfectly.
Last edited: