N Neil Holmes Dec 17, 2003 #1 Does anyone know if it is possible to show the worksheet tab name in cell on the worksheet? Any help would be appreciated. Neil.
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 Dec 17, 2003 #2 Sub tabname() [j1].Value = ActiveSheet.Name End Sub -- Don Guillett SalesAid Software (e-mail address removed) Does anyone know if it is possible to show the worksheet tab name in cell on the worksheet? Any help would be appreciated. Neil.
Sub tabname() [j1].Value = ActiveSheet.Name End Sub -- Don Guillett SalesAid Software (e-mail address removed) 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 Dec 17, 2003 #3 =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.
=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.
