How to Name a Sheet Referencing a VBA Variable

[lleifsen]

Dim MyDate
MyDate = Date

Sheets("Summary").Name = "MyDate"

Hello,

When I run this Code, it names my sheet "MyDate" instead of the actual date(5/19/11).

Does anyone have any pearls of wisdom for me?

I would greatly appreciate it.

 

[Gary McMaster]

No quotes around MyDate.

Gary

 

[lleifsen]

Thanks Gary, but that is a no go.

It gives me a Runtime Error 1004.

I have tried several different quote and () combinations.


Lee

 

[Gary McMaster]

Try like this instead:

Sheets("Summary").Name = Format(Date, "mm-dd-yy")

Gary

 

[lleifsen]

Perfect!


Thank you much!