tab function
 

is there a function that will give me the sheet tab name of a cell or sheet?
--
Boris

tab function
 

BorisS wrote:
is there a function that will give me the sheet tab name of a cell or sheet?
--
Boris


Hi Boris

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

puts the tab name into A1. Workbook must be saved before it will work.

Ken Johnson

tab function
 

Enter this exactly as written in any cell of any sheet to return the Sheet name.

=MID(CELL("Filename",A1),FIND("]",CELL("Filename",A1))+1,255)

Note: workbook must have been saved at least once.

There is no such thing as a sheet tab name of a cell.


Gord Dibben MS Excel MVP


On Mon, 18 Dec 2006 11:33:02 -0800, BorisS
wrote:

is there a function that will give me the sheet tab name of a cell or sheet?

tab function
 

Ken Johnson wrote:
BorisS wrote:
is there a function that will give me the sheet tab name of a cell or sheet?
--
Boris


Hi Boris

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

puts the tab name into A1. Workbook must be saved before it will work.

Ken Johnson

I shouldn't have said "puts the tab name into A1". Obviously it puts
the tab name into the cell with the formula.
Ken Johnson