GS
I added this line to the code
Application.SheetsInNewWorkbook = 1
Now that the new workbook contains the newly moved worksheets and one
default worksheet Sheet1
I want delete Sheet1
and sort the newly moved worksheets
The sheet names are week ending dates ie: 2-04-06 and so on
They display like this in the new workbook:
3-04-06
2-25-06
2-18-06
2-11-06
2-4-06
Sheet1
I would like them to display like this:
2-4-06
2-11-06
2-18-06
2-25-06
3-04-06
Thaks for the help
Charles
--
mrdata
------------------------------------------------------------------------
mrdata's Profile:
http://www.excelforum.com/member.php...o&userid=17899
View this thread:
http://www.excelforum.com/showthread...hreadid=519020