help with copying of excel spread sheet from template trought VB

  • Thread starter Thread starter Mike
  • Start date Start date
dim ws as worksheet
set ws = thisworkbooks.worksheets("???")
ws.copy

change ??? to the sheet name
 
Just a note to Patricks code. If Before:= or After:= is not specified, it
will create a new workbook.
 
Back
Top