wsname value of range name

[Guest]

I have this formula

Worksheets("Master (2)").Name = Worksheets("Master (2)").Range("month").value

the result is 38838 which is the numerical value of the date - what I need
is the either mmm-yy value of the Range("month").value

in other words, I would like the worksheetname to be: May or May 06

can anyone help?

 

[papou]

Hello
Use Format:
Format(Worksheets("Master (2)").Range("month").value,"mmm-yy")

HTH
Cordially
Pascal

 

[Guest]

I get compile error: expected =

Hello
Use Format:
Format(Worksheets("Master (2)").Range("month").value,"mmm-yy")

HTH
Cordially
Pascal

 

[papou]

Helmut
This was just to show what you needed to amend in your code.
So your code should look like this:
Worksheets("Master (2)").Name = _
Format(Worksheets("Master (2)").Range("month").value,"mmm-yy")

HTH
Cordially
Pascal