Can Sheet Tab = Cell

[RMontani]

Is there a way for the sheet tab to equal a cell. If I put a name in a cell, say "B3", can I get it to load as the sheet tab name or the opposite way.

[mudraker]

The only way I know of doing that is via a macro

If you are going to type the name into a cell why don't you just rename the sheet?

[RMontani]

So I can't find a code or something that would automaticaly do this.

[Hans_Gruber]

You could possibly do it the other way around - get the cell to display the tab name. I'm pretty sure I've seen it done before.

[RMontani]

Any Ideas on how to do that?

[RMontani]

Or can cell = sheet tab name?

[shg]

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

... will return the tab name of the sheet on which it resides if the workbook has been saved.

[Trebor76]

Put the following formula into the desired output cell - just note that the workbook needs to have been previously saved for it to work:

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

[RMontani]

Thanks shg (AGAIN) and Trebor76