Sorry if this has been covered before but I cannot find a similar requirement!
I have a workbook with 4 sheets. The 4th sheet is created by substantial VBA code from the first three. This all works.
My question is this - how do I code creating a new workbook and copying the 4th sheet into the new workbook and then closing the new workbook?
Thanks!
I have a workbook with 4 sheets. The 4th sheet is created by substantial VBA code from the first three. This all works.
My question is this - how do I code creating a new workbook and copying the 4th sheet into the new workbook and then closing the new workbook?
Thanks!