Re: Sheet Name in Cell

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jay - 17 Aug 2006 15:18 GMT

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,

Reply to this Message

David Billigmeier - 17 Aug 2006 15:21 GMT

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

Signature

Regards,
Dave

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

Reply to this Message

Jay - 17 Aug 2006 15:36 GMT

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.

> Place the following formula in B2. Note your sheet must be saved or else you
> will get a #VALUE! error.
[quoted text clipped - 5 lines]
> >
> > Thanks,

Reply to this Message

Dave Peterson - 17 Aug 2006 18:02 GMT

You have responses at your other post.

> 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
[quoted text clipped - 15 lines]
> > >
> > > Thanks,

Signature

Dave Peterson

Reply to this Message