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

Neil · Nov 13, 2004

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 · Nov 13, 2004

Take a look here:

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

Frank Kabel · Nov 13, 2004

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

Gord Dibben · Nov 13, 2004

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

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

Neil

JE McGimpsey

Frank Kabel

Gord Dibben