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
|