Worksheet name in cell

Not "yet" an expert seeks assistance.

How does one display the sheet name in a cell that automatically updates if you make any changes?

Any suggestions.

Looked at CELL and was confused as hell......

If you add this macro to the VBA sheet tab, you will get the desired effect.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Cells(1, 1) = ActiveSheet.Name
End Sub

Thanks. I take it there is no Function other than VBA to doing it.

I was trying to avoid VBA too keep the file management simple and small but I guess I have no choice.

Thanks again.

Donovan

You do not need VBA.

The CELL function is what you want.

See Bob Phillips's site for info.

http://www.xldynamic.com/source/xld.xlFAQ0002.html


Gord Dibben MS Excel MVP

On Fri, 9 Jun 2006 16:16:45 -0500, Donovan
<Donovan.295lnb_1149888001.823@excelforum-nospam.com> wrote:

>
>Thanks. I take it there is no Function other than VBA to doing it.
>
>I was trying to avoid VBA too keep the file management simple and small
>but I guess I have no choice.
>
>Thanks again.

but the sheet needs to be SAVED before the name shows up!
--
paul
paul.shepherd@nospamparadise.net.nz
remove nospam for email addy!



"Gord Dibben" wrote:

> Donovan
>
> You do not need VBA.
>
> The CELL function is what you want.
>
> See Bob Phillips's site for info.
>
> http://www.xldynamic.com/source/xld.xlFAQ0002.html
>
>
> Gord Dibben MS Excel MVP
>
> On Fri, 9 Jun 2006 16:16:45 -0500, Donovan
> <Donovan.295lnb_1149888001.823@excelforum-nospam.com> wrote:
>
> >
> >Thanks. I take it there is no Function other than VBA to doing it.
> >
> >I was trying to avoid VBA too keep the file management simple and small
> >but I guess I have no choice.
> >
> >Thanks again.
>
>

This works Great.

IT APPEARS Bob Phillips really knows Excel well...

And how to keep it simple as opposed to elaborate codes.