424,051 Members | 1,247 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,051 IT Pros & Developers. It's quick & easy.

New sheet name - in excel/VB

P: 1
In the Macro I try to open a new sheet and rename it, but the name of the new sheet is changing (sheet 1/2/3...)

1. How can I give a general name for a sheet?
2.How can I rename it with today's date?
Dec 24 '13 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 5K+
P: 5,285
Please show your work.
Post the code and format it using the [CODE/]
Dec 24 '13 #2

Post your reply

Sign in to post your reply or Sign up for a free account.