Add and rename a worksheet

M

Microsoft Forum

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Referencing worksheet controls 2
Return the name of a range 4
Dynamically create procedures in a sheet module 2
Exclusive OR question 8
Q about making a function 4
VBComponents question 2
Uninstall and install Publisher 365 0
Workbook and Window object question 6

Top