referencing a worksheet name in a cell

[Stacey Snyder]

Does anyone know how to reference the value of a worksheet
name in a cell?

I know that if I type in the name "Stacey" in cell A1 and
then put the formula =A1 in cell A2 I'll get "Stacey"
there as well.

So if I have a worksheet named "Billing" what formula can
I put into cell A1 so that I get the word "Billing" there?

That way if I change the name of a worksheet cell A1 will
change as well.

Any clues?

Regards,
Stacey Snyder

 

[Peo Sjoblom]

Try

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,34)

put in A1, it will not create a circular ref..

The workbook has to be saved for it to work..

 

[Stacey Snyder]

This seems to work for the name of the worksheet that you
are in. Would anyone know how to do this for an
additional worksheet?
So a formula in A1 of sheet1 that will put the name of
sheet2?

thanks,
Stacey

-----Original Message-----
Try

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1)) +1,34)

put in A1, it will not create a circular ref..

The workbook has to be saved for it to work..

--

Regards,

Peo Sjoblom

Does anyone know how to reference the value of a worksheet
name in a cell?

I know that if I type in the name "Stacey" in cell A1 and
then put the formula =A1 in cell A2 I'll get "Stacey"
there as well.

So if I have a worksheet named "Billing" what formula can
I put into cell A1 so that I get the word "Billing" there?

That way if I change the name of a worksheet cell A1 will
change as well.

Any clues?

Regards,
Stacey Snyder

.

 

[Gilbert De Ceulaer]

At http://longre.free.fr you'll find the "morefunc"-add-inns that contain a
sheetname-function that makes this possible
Helps ?
By the way, have a look at the setv-getv-function, it's great !
Gilbert

This seems to work for the name of the worksheet that you
are in. Would anyone know how to do this for an
additional worksheet?
So a formula in A1 of sheet1 that will put the name of
sheet2?

thanks,
Stacey

-----Original Message-----
Try

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1)) +1,34)

put in A1, it will not create a circular ref..

The workbook has to be saved for it to work..

--

Regards,

Peo Sjoblom

Does anyone know how to reference the value of a worksheet
name in a cell?

I know that if I type in the name "Stacey" in cell A1 and
then put the formula =A1 in cell A2 I'll get "Stacey"
there as well.

So if I have a worksheet named "Billing" what formula can
I put into cell A1 so that I get the word "Billing" there?

That way if I change the name of a worksheet cell A1 will
change as well.

Any clues?

Regards,
Stacey Snyder

.