Worksheet name in cell

[Giri]

Hi,

Is it possible to set the worksheet name for a cell. Eg.
In cell A1, how to set A1="Sheet1" if Sheet1 is the
worksheet name. If the worksheet name changes to "abc"
then A1 should reflect "abc".

Any help in this regard is appreciated. Thank You.

Regards,
Giri

 

[Chip Pearson]

Giri,

Try

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


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)

 

[giri]

Hi Chip Pearson,

I set the formula in cell A1, but it seems to be
returning a #VALUE!

Anything that i did wrong ?

Regards,
Giri

-----Original Message-----
Giri,

Try

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


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)

Hi,

Is it possible to set the worksheet name for a cell. Eg.
In cell A1, how to set A1="Sheet1" if Sheet1 is the
worksheet name. If the worksheet name changes to "abc"
then A1 should reflect "abc".

Any help in this regard is appreciated. Thank You.

Regards,
Giri

.

 

[giri]

Hi Chip Pearson,

Sorry for the previous mail. It seems to work if i
change the worksheet name from the default.
Thank You very much.

Regards,
Giri

-----Original Message-----
Giri,

Try

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


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)

Hi,

Is it possible to set the worksheet name for a cell. Eg.
In cell A1, how to set A1="Sheet1" if Sheet1 is the
worksheet name. If the worksheet name changes to "abc"
then A1 should reflect "abc".

Any help in this regard is appreciated. Thank You.

Regards,
Giri

.

 

[Chip Pearson]

The workbook must have been saved in order for the formula to
work.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)

Hi Chip Pearson,

I set the formula in cell A1, but it seems to be
returning a #VALUE!

Anything that i did wrong ?

Regards,
Giri

-----Original Message-----
Giri,

Try

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


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)

Hi,

Is it possible to set the worksheet name for a cell. Eg.
In cell A1, how to set A1="Sheet1" if Sheet1 is the
worksheet name. If the worksheet name changes to "abc"
then A1 should reflect "abc".

Any help in this regard is appreciated. Thank You.

Regards,
Giri

.