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?

Frederick,

You want

Worksheets.Add(After:=worksheets("Sheet1")).Name = "Frederick"

Are you using a web portal to the NGs, such as ExcelForum (I know it is not
that one, but you get the idea)? If so, there must be some way to define
your own handle.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Microsoft Forum" wrote in message
...
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?