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