Copy worksheet to new workbook using VBA

reglarh

New member
Joined
Feb 1, 2019
Messages
9
Reaction score
0
Points
0
Excel Version(s)
2010
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!
 
Back
Top