with workbooks("book2.xls")
activesheet.copy _
befo=.sheets(.sheets.count)
end with

"Jimbob" wrote:

I have a macro which pastes a worksheet into a 15 sheet workbook. How can I
get the new sheet into the desired poisition (2nd to last) programmatically?

Thanks in advance