Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA - Insert new sheet as the last sheet
Good Morning All, I have a spreadsheet with a lovely piece of code that inserts a shee into the workbook via a button. The sheet is inserted to the left of the sheet with the button. Is there a way to get the sheet to be inserted to the right of th sheet with the button? I am probably being a bit thick - I apologise in advance!! Thanks, MoonWeaze -- MoonWeaze ----------------------------------------------------------------------- MoonWeazel's Profile: http://www.excelforum.com/member.php...nfo&userid=211 View this thread: http://www.excelforum.com/showthread.php?threadid=26273 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA - Insert new sheet as the last sheet
Hi Moon Weazel,
ActiveWorkbook.Worksheets.Add After:=ActiveSheet --- Regards, Norman "MoonWeazel" wrote in message ... Good Morning All, I have a spreadsheet with a lovely piece of code that inserts a sheet into the workbook via a button. The sheet is inserted to the left of the sheet with the button. Is there a way to get the sheet to be inserted to the right of the sheet with the button? I am probably being a bit thick - I apologise in advance!! Thanks, MoonWeazel -- MoonWeazel ------------------------------------------------------------------------ MoonWeazel's Profile: http://www.excelforum.com/member.php...fo&userid=2119 View this thread: http://www.excelforum.com/showthread...hreadid=262739 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
insert sheet tab is not functioning and can't add new sheet | Excel Worksheet Functions | |||
excel sheet bootom half sheet goes behind top part of sheet | Excel Worksheet Functions | |||
Duplicate sheet, autonumber sheet, record data on another sheet | Excel Worksheet Functions | |||
insert query into excell sheet to update excell sheet and pivot table | Excel Discussion (Misc queries) | |||
Inserting a row in sheet A should Insert a row in sheet B, removing a row in Sheet A should remove the corresponding row in sheet B | Excel Programming |