MrExcel Publishing
Your One Stop for Excel Tips & Solutions

How to add and name a workshheet


Posted by yogesh k. potdar on October 30, 2001 4:48 AM

How do I add a new worksheet and name it "Summary"?
thanks
-Yogesh


Posted by Mark W. on October 30, 2001 5:11 AM

See the Excel Help Index topics for "Insert a new
worksheet" and "Rename a sheet".

Posted by EDDIE G on October 30, 2001 5:54 AM

Sheets.Add
ActiveSheet.Name = "summary"

Posted by yogesh k. potdar on October 30, 2001 9:56 AM

The following didnot work!! (: Any other VB thing I can type in a macro??


Posted by Barrie Davidson on October 30, 2001 10:11 AM


Try,

Sheets.Add before:=ActiveSheet
ActiveSheet.Name = "Summary"


BarrieBarrie Davidson

Posted by yogesh k. potdar on October 30, 2001 10:31 AM

Re: This worked!!


Cool!! That worked!!

Thanks a lot!!

-Yogesh