Worksheet name in cell

D

Donovan

Not "yet" an expert seeks assistance.

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

Any suggestions.

Looked at CELL and was confused as hell...... :eek
 
M

mrice

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

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

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 smal
but I guess I have no choice.

Thanks again
 
D

Donovan

This works Great.

IT APPEARS Bob Phillips really knows Excel well...

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