Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Emergency ( Adding Worksheets dynamically in Workbookds)
Hi, i am in a hurrey, how to add worksheets dynamically in Excel Work
Books , i want to know this thing that how to do that with the help of Code. --- Message posted from http://www.ExcelForum.com/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Emergency ( Adding Worksheets dynamically in Workbookds)
Emergency,
Worksheets.Add Rob "Ussiddiqui " wrote in message ... Hi, i am in a hurrey, how to add worksheets dynamically in Excel Work Books , i want to know this thing that how to do that with the help of Code. --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Emergency ( Adding Worksheets dynamically in Workbookds)
Just in case you want to add a name to your worksheet
Worksheets.Add ActiveSheet.Name = ("whatever") Rocke -- Message posted from http://www.ExcelForum.com |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Emergency ( Adding Worksheets dynamically in Workbookds)
or even:
i = Worksheets.count + 1 sName = "Sheet" & i Worksheets.Add(after:=Worksheets(Worksheets.Count) ).Name = sName -- Regards, Tom Ogilvy "Rockee052 " wrote in message ... Just in case you want to add a name to your worksheet Worksheets.Add ActiveSheet.Name = ("whatever") Rockee --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamically Adding Textbox To Frame | Excel Worksheet Functions | |||
EMERGENCY Hyperlink within Woirksheets EMERGENCY | Excel Discussion (Misc queries) | |||
Adding button dynamically | Excel Programming | |||
Dynamically Adding Code to Buttons on an existing UserForm | Excel Programming | |||
Adding a webBrowser object dynamically to a sheet | Excel Programming |