AddCopy sheet location

[Roderick Prince]

After performing an Workbook.Worksheets.AddCopy(Index) is it possible to move the newly created sheet to a different location within the workbook.

ie.
Start: [Tab 1][Tab 2][Tab 3]
AddCopy(1)
After: [Tab 1][Tab 2][Tab 3][Tab 1_1] <-- new
Some move magic...
Want: [Tab 1][Tab 1_1][Tab 2][Tab 3]

Thanks!

[Administrator]

>After performing an Workbook.Worksheets.AddCopy(Index) is it possible to move the newly created sheet to a different location within the workbook.
>
>ie.
>Start: [Tab 1][Tab 2][Tab 3]
>AddCopy(1)
>After: [Tab 1][Tab 2][Tab 3][Tab 1_1] <-- new
>Some move magic...
>Want: [Tab 1][Tab 1_1][Tab 2][Tab 3]
>
>Thanks!

As I know there is no way to set needed place for Sheet within the Sheets collection

[Administrator]

Hi Roderick, I put together a sample based on your requirements. Please take a look at this sample and let me know if you have any questions. CopyWorkSheetToAnotherWorkBook_4332.zip Best Regards, Seetha. >After performing an Workbook.Worksheets.AddCopy(Index) is it possible to move the newly created sheet to a different location within the workbook. > >ie. >Start: [Tab 1][Tab 2][Tab 3] >AddCopy(1) >After: [Tab 1][Tab 2][Tab 3][Tab 1_1] <-- new >Some move magic... >Want: [Tab 1][Tab 1_1][Tab 2][Tab 3] > >Thanks!