Worksheet name in cell

[Donovan]

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

[mrice]

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

[Donovan]

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.

[Gord Dibben]

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
<[email protected]> 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.

[paul]

but the sheet needs to be SAVED before the name shows up!
--
paul
[email protected]
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
> <[email protected]> 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.
>
>

[Donovan]

This works Great.

IT APPEARS Bob Phillips really knows Excel well...

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