Showing Worksheet Tab Name in Cell

N

Neil Holmes

Does anyone know if it is possible to show the worksheet tab name in cell on the worksheet?

Any help would be appreciated.

Neil.
 
D

Don Guillett

Sub tabname()
[j1].Value = ActiveSheet.Name
End Sub


--
Don Guillett
SalesAid Software
[email protected]
Does anyone know if it is possible to show the worksheet tab name in cell on the worksheet?

Any help would be appreciated.

Neil.
 
P

Peo Sjoblom

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,32)

the workbook has to be saved

--

Regards,

Peo Sjoblom

Does anyone know if it is possible to show the worksheet tab name in cell on
the worksheet?

Any help would be appreciated.

Neil.
 
Top