Control Location Of New Worksheet

[jo15765]

I have a workbook that I want to add a new worksheet to, and I know this syntax can do it

Please Login or Register  to view this content.

What I can not figure out is how to control where the sheet is added. For example, I want to add a worksheet as the 2nd worksheet in my workbook. I tried this

Please Login or Register  to view this content.

However, it is leaving the "new" sheet that was added through VBA as the 1st worksheet in the workbook. How do I add a new worksheet as the 2nd worksheet in the workbook?

[cytop]

The Add method also has an 'After' parameter

Please Login or Register  to view this content.

[Richard Buttrey]

Hi,

Please Login or Register  to view this content.

[Norie]

There's also the Before parameter.

Please Login or Register  to view this content.