In Excel is there a way to read the name of the sheets tab and di.

[Guest]

I would like to display the name of the sheet (the tab name) in a cell - or
vise versa. So the user could change it just once.

 

[JE McGimpsey]

Take a look here:

http://www.mcgimpsey.com/excel/formulae/cell_function.html

 

[Frank Kabel]

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

 

[Gord Dibben]

Which takes care of putting the sheet name in a cell.

For the vice versa.........

Sub SheetName22()
ActiveSheet.Name = Range("c1")
End Sub

Gord Dibben Excel MVP