Worksheet name in cell

  • Thread starter Thread starter Giri
  • Start date Start date
G

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



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


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



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


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

giri said:
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)



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


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