wsname value of range name
 

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?

wsname value of range name
 

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

HTH
Cordially
Pascal

"Helmut" a écrit dans le message de news:
...
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?

wsname value of range name
 

I get compile error: expected =

"papou" wrote:

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

HTH
Cordially
Pascal

"Helmut" a écrit dans le message de news:
...
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?

wsname value of range name
 

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

"Helmut" a écrit dans le message de news:
...
I get compile error: expected =

"papou" wrote:

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

HTH
Cordially
Pascal

"Helmut" a écrit dans le message de
news:
...
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?