How do I add NOT insert additional worksheet to existing workbook.

[Phyllis]

How can I add - NOT insert - additional worksheet(s) to already existing
workbook?

(as in at the end of the last worksheet, not in between).

Thanks for replies re this.

 

[Bernard Liengme]

You can do it with VBA code - for example
Set wks = Worksheets.Add(after:=Worksheets(Worksheets.Count))

But if you have only a few occasions to add worksheets then just drag the
new sheet's tab to the end of the tab list.

best wishes

 

[Archimedes' Lever]

How can I add - NOT insert - additional worksheet(s) to already existing
workbook?

(as in at the end of the last worksheet, not in between).

Thanks for replies re this.

Click on the little tab just after the tabs that are assigned to
sheets, and a mew one will pop in at the end.

 

[Archimedes' Lever]

You can do it with VBA code - for example
Set wks = Worksheets.Add(after:=Worksheets(Worksheets.Count))

But if you have only a few occasions to add worksheets then just drag the
new sheet's tab to the end of the tab list.

best wishes

Shift+F11

Doh!

 

[Archimedes' Lever]

Yes, but that inserts the sheet BEFORE the current one NOT at the end of the
tabs
Your lever is rusty today!

Absolutely not. It placed it AT the end when I did it, both the little
"add" tab did, as well as the Shift+F11 usage.

Perhaps it relates to which tab is currently active.

 

[Bernard Liengme]

Yes, but that inserts the sheet BEFORE the current one NOT at the end of the
tabs
Your lever is rusty today!

 

[Gord Dibben]

Excel 2007 little "add" button inserts sheet at end no matter which sheet is
selected.

Shift F11 inserts sheet before selected sheet.

There is no little "add" button in Excel 2003 and Shift F11 inserts sheet
before selected sheet...........as does "insert sheet"


Gord Dibben MS Excel MVP