worksheets.Add Befo=worksheets("End")
or if you are copying a "template" sheet
worksheets("Template").Copy Befo=worksheets("End")
--
Regards,
Tom Ogilvy
"J.W. Aldridge" wrote in message
oups.com...
I have found the vb code to allow me to insert sheets based on names
from a list. Next, I found the code that will allow me to add the same
cell values from each sheet: { SUM(START:END!C5) ]. My problem is, when
I add sheets to a workbook from the list, I want the sheet labled "end"
to remain in its place at the end so that my formulas can calculate
from "start" (add all the sheets up until) "end".
Is there any way possible to do this?