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


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

Worksheet name in cell
 

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

Worksheet name in cell
 

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

Worksheet name in cell
 

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.

Worksheet name in cell
 

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.

Worksheet name in cell
 

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