If ndate is a proper date then
Consider saving though as "yyyy_mm_dd" which will show in Explorer in date order.savedate = Format(ndate, "dd_mm_yyyy")
If ndate is a proper date then
Consider saving though as "yyyy_mm_dd" which will show in Explorer in date order.savedate = Format(ndate, "dd_mm_yyyy")
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