I'm not entirely clear what you are after. If you wany to save copies of the whole workbook, you can use SaveCopyAs.
I'm not entirely clear what you are after. If you wany to save copies of the whole workbook, you can use SaveCopyAs.
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'
Posting Permissions
Reply With Quote