Guys/Ladies, I need to copy template sheet in the work book with VB. Anubody help?? Mike
M Mike Jul 25, 2009 #1 Guys/Ladies, I need to copy template sheet in the work book with VB. Anubody help?? Mike
P Patrick Molloy Jul 25, 2009 #2 dim ws as worksheet set ws = thisworkbooks.worksheets("???") ws.copy change ??? to the sheet name
J JLGWhiz Jul 25, 2009 #3 Just a note to Patricks code. If Before:= or After:= is not specified, it will create a new workbook.
Just a note to Patricks code. If Before:= or After:= is not specified, it will create a new workbook.
