VBA coding to copy sheets into a new workbook
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 |
VBA coding to copy sheets into a new workbook
have a look he
http://www.rondebruin.nl/tips.htm Corey.... "gitlin" wrote in message ... 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 |
All times are GMT +1. The time now is 08:34 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com