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/

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/

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

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/