Moving worksheets
 

I have a workbook that under different situations will have a
different number of worksheets.

I want to move a new worksheet after a particular worksheet. I want
to use the name of the worksheet. NOT the number of the worksheet.

Is this possible?

Thanks

Moving worksheets
 

Worksheets("x").Move After:=Worksheets("y")

--

Vasant

"Excel" wrote in message
om...
I have a workbook that under different situations will have a
different number of worksheets.

I want to move a new worksheet after a particular worksheet. I want
to use the name of the worksheet. NOT the number of the worksheet.

Is this possible?

Thanks