Add Debug.print File and check the output in the Immediate window or post your workbook
Add Debug.print File and check the output in the Immediate window or post your workbook
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'