So what you are trying to do is grab a worksheet from another workbook and
put it in the new workbook... or are you just trying to insert a new
worksheet?

"mcnewsxp" wrote:

i need the VBA code to insert a worksheet that is used as a template into
another workbook. the code may include 1 or more insertions of different
templates so i 'd like to get them on sequential wortksheets within the
workbook.
tia,
mcnewsxo