excel worksheet name (2003)

[Guest]

hi community

can anybody enlighten me on this task ??

when i rename an excel worksheet, say,

i rename sheet1 to another name, to the name, "OverTime Payment"
and
when I do the renaming and press "Enter" key, the new name, "OverTime
Payment", will also be able to be display at say, cell A1 ....?

is it possible ?....if can....how do I go about it to do that ???

much appreciated to anybody for the assistance

 

[Cortez]

I am using this code to do what you are asking:

make A1 =

=MID(CELL("filename",A2),FIND("]",CELL("filename",A2))+1,255)

Don't ask me to explain it.

TK

 

[Guest]

thanks for the code much appreciated !!
but
when I write the code into cell A1
it gives me an #VALUE! output
and
after renaming sheet1 to a new name,
there is nothing being display out at A1....

is it that I must use VBA to write it ???

thanks again for further assistance
oldLearner57

I am using this code to do what you are asking:

make A1 =

=MID(CELL("filename",A2),FIND("]",CELL("filename",A2))+1,255)

Don't ask me to explain it.

TK

hi community

can anybody enlighten me on this task ??

when i rename an excel worksheet, say,

i rename sheet1 to another name, to the name, "OverTime Payment"
and
when I do the renaming and press "Enter" key, the new name, "OverTime
Payment", will also be able to be display at say, cell A1 ....?

is it possible ?....if can....how do I go about it to do that ???

much appreciated to anybody for the assistance

 

[Guest]

thanks Cortez and very much appreciated now I got it

thanks community as well
--
oldLearner57

I am using this code to do what you are asking:

make A1 =

=MID(CELL("filename",A2),FIND("]",CELL("filename",A2))+1,255)

Don't ask me to explain it.

TK

hi community

can anybody enlighten me on this task ??

when i rename an excel worksheet, say,

i rename sheet1 to another name, to the name, "OverTime Payment"
and
when I do the renaming and press "Enter" key, the new name, "OverTime
Payment", will also be able to be display at say, cell A1 ....?

is it possible ?....if can....how do I go about it to do that ???

much appreciated to anybody for the assistance