New sheet name - in excel/VB

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • amoyalyair
    New Member
    • Dec 2013
    • 1

    New sheet name - in excel/VB

    Hi,
    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?
  • zmbd
    Recognized Expert Moderator Expert
    • Mar 2012
    • 5501

    #2
    Please show your work.
    Post the code and format it using the [CODE/]

    Comment

    Working...