Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Insert Worksheet At the End Of Workbook
I am using Excel 2003.
I want to add a worksheet into my workbook but when i click on insert\workbook a new workbook is cretaed to the left of my last worksheet. How do I get it to insert as the last worksheet? Thank you |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Insert Worksheet At the End Of Workbook
Only way I know is, instead of Insert, pick Move or Copy. Click Create a
Copy. Then, you will have the option to (move to end). Course, this means the sheet you are copying will be recreated... "laitkens" wrote: I am using Excel 2003. I want to add a worksheet into my workbook but when i click on insert\workbook a new workbook is cretaed to the left of my last worksheet. How do I get it to insert as the last worksheet? Thank you |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Insert Worksheet At the End Of Workbook
With your workbook open, hit Alt + F11 and CTRL + r
Select your workbook/project and InsertModule. Paste the following macro into that module. Alt + q to return to the Excel window. Sub Add_Sheet() Worksheets.Add After:=Sheets(ThisWorkbook.Sheets.Count) End Sub Run it by going to ToolsMacroMacros. Gord Dibben MS Excel MVP On Wed, 8 Oct 2008 13:11:03 -0700, laitkens wrote: I am using Excel 2003. I want to add a worksheet into my workbook but when i click on insert\workbook a new workbook is cretaed to the left of my last worksheet. How do I get it to insert as the last worksheet? Thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Workbook won't allow me to insert worksheet. How can I add one? | Excel Discussion (Misc queries) | |||
Insert a worksheet from different workbook | Excel Discussion (Misc queries) | |||
workbook won't let me insert new worksheet | Excel Discussion (Misc queries) | |||
How do I insert just one worksheet of a workbook into an email? | Excel Discussion (Misc queries) | |||
MY WORKBOOK WON'T LET INSERT ANOTHER WORKSHEET. | Excel Worksheet Functions |