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

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.

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

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
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"Phyllis" wrote in message
...
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.

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

On Sat, 31 Oct 2009 17:27:01 -0700, Phyllis
wrote:

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.

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

On Sat, 31 Oct 2009 22:22:14 -0300, "Bernard Liengme"
wrote:

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!

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

On Sun, 1 Nov 2009 09:16:29 -0400, "Bernard Liengme"
wrote:

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.

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

Yes, but that inserts the sheet BEFORE the current one NOT at the end of the
tabs
Your lever is rusty today!
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"Archimedes' Lever" wrote in message
...
On Sat, 31 Oct 2009 22:22:14 -0300, "Bernard Liengme"
wrote:

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!

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

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

On Sun, 01 Nov 2009 04:59:45 -0800, Archimedes' Lever
wrote:

On Sun, 1 Nov 2009 09:16:29 -0400, "Bernard Liengme"
wrote:

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.