Sheet Name in Cell
 

Is there a way to get the sheet name to show up in a cell? Say sheet name;
"Pear" tp show in cell B2 of said sheet?

Thanks,

Sheet Name in Cell
 

Place the following formula in B2. Note your sheet must be saved or else you
will get a #VALUE! error.

=RIGHT(CELL("filename"),LEN(CELL("filename"))-SEARCH("]",CELL("filename")))

--
Regards,
Dave


"Jay" wrote:

Is there a way to get the sheet name to show up in a cell? Say sheet name;
"Pear" tp show in cell B2 of said sheet?

Thanks,

Sheet Name in Cell
 

Thanks, David it worked. Now, what I need is to have the workbook open to the
month sheet based on the current system month, keeping all other sheets minus
the review sheet hidden. Is that possible?

Looking forward to your reply.





"David Billigmeier" wrote:

Place the following formula in B2. Note your sheet must be saved or else you
will get a #VALUE! error.

=RIGHT(CELL("filename"),LEN(CELL("filename"))-SEARCH("]",CELL("filename")))

--
Regards,
Dave


"Jay" wrote:

Is there a way to get the sheet name to show up in a cell? Say sheet name;
"Pear" tp show in cell B2 of said sheet?

Thanks,

Sheet Name in Cell
 

You have responses at your other post.

Jay wrote:

Thanks, David it worked. Now, what I need is to have the workbook open to the
month sheet based on the current system month, keeping all other sheets minus
the review sheet hidden. Is that possible?

Looking forward to your reply.

"David Billigmeier" wrote:

Place the following formula in B2. Note your sheet must be saved or else you
will get a #VALUE! error.

=RIGHT(CELL("filename"),LEN(CELL("filename"))-SEARCH("]",CELL("filename")))

--
Regards,
Dave


"Jay" wrote:

Is there a way to get the sheet name to show up in a cell? Say sheet name;
"Pear" tp show in cell B2 of said sheet?

Thanks,



--

Dave Peterson