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