referencing a worksheet name in a cell

  • Thread starter Thread starter Stacey Snyder
  • Start date Start date
S

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
 
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..
 
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


Stacey Snyder said:
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
Click to expand...


.
Click to expand...
 
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

Stacey Snyder said:
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


Stacey Snyder said:
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
Click to expand...


.
Click to expand...
Click to expand...
 
Back
Top