Hi:
I am trying to create an array of sheetnames in a workbook using vba.
The sheetnames are days of the week, but some weeks only have specific week days, Not all seven.
If I border the sheetnames in the Workbook with two blank sheets, First & Last, how can I create an array of the sheetnames that fall between those two blank sheets, First & Last.
( Maybe only Sunday to Wednesday ) for that week.
The workbook has other sheets.
I'm calling the array DaysArray
If there's a better way to do this, I'm interested.
Thanks