| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding a new worksheet to a workbook at the end of existing workbo | Excel Discussion (Misc queries) | |||
| How do I apply a template to one worksheet in existing workbook? | Excel Discussion (Misc queries) | |||
| Need to insert a template with formulas into an existing workbook | Excel Worksheet Functions | |||
| How do I insert a new work sheet into an existing workbook? | Excel Discussion (Misc queries) | |||
| Can't Insert of remove worksheet in an existing workbook | Excel Discussion (Misc queries) | |||
Hybrid Mode
