Hi

Look at this:

Sheets(1).Move Befo=Sheets(Sheets.Count)
Sheets("Sheet1").Copy Befo=Sheets(Sheets.Count)

Regards,
Per

"Jimbob" skrev i meddelelsen
...
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