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


--
Donovan
------------------------------------------------------------------------
Donovan's Profile: http://www.excelforum.com/member.php...o&userid=35234
View this thread: http://www.excelforum.com/showthread...hreadid=550478

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


--
mrice

Research Scientist with many years of spreadsheet development experience
------------------------------------------------------------------------
mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=550478

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
------------------------------------------------------------------------
Donovan's Profile: http://www.excelforum.com/member.php...o&userid=35234
View this thread: http://www.excelforum.com/showthread...hreadid=550478

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

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


--
Donovan
------------------------------------------------------------------------
Donovan's Profile: http://www.excelforum.com/member.php...o&userid=35234
View this thread: http://www.excelforum.com/showthread...hreadid=550478