I'm trying to add 2 worksheets to an array.
I know the first sheetname is "Sheet1" however, the other sheetname is derived from the current month.
My code to determine it is like this;
The 2nd sheetname is the name of the current monthDim MySht Worksheets(MySht).Activate
How do I put both sheets into an array and copy them to a new Workbook and save it ?