View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Microsoft Forum Microsoft Forum is offline
external usenet poster
 
Posts: 17
Default Add and rename a worksheet

Hi all,

Sorry for this very simple question: How can I add a new worksheet, and then
immediately rename it?

i.e.

Worksheets.add after:=Worksheets("Sheet1") .. and then how?

Thanks a lot.

Frederick Chow
Hong Kong.

P.S. I don't know why my name changes to "Microsoft Forum"... Any help to
change it?