VBA coding to copy sheets into a new workbook

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm coding a macro and want it to copy existing sheets as an array into a new
workbook, then I want to edit the copied sheets in the new workbook. I'm
having trouble with the code, I've got the below, but don't know how to
activate the new workbook for editting.


Sheets(Array("Summary", "Pace", "Topline Media", "Media Detail",
"Creative Trending", "Creative Detail", "Creative Opt", "CTD", "Formula
Definitions")).Copy

Windows(MacroFileName).Activate
 
Back
Top