Excel Worksheet Names

[ceecld]

I was wondering if it is possible to get excel to show the worksheet name in a cell?

i can get this to work the other way round e.g. i can select a certain worksheet based on a cell value using the INDIRECT function.

Thanks

 

[SkipVought]

Hi,
[tt]
=RIGHT(CELL("filename",I1),LEN(CELL("filename",I1))-FIND("]",CELL("filename",I1)))
[/tt]


Skip,

_{[red]Be advised:[/red] Researchers have found another Descartes trueism, "Cogito ergo spud."
"I think; therefore, I YAM!}

 

[ceecld]

nice one

thanks.

 

[xlbo]

There is a FAQ as well if you need any more info like that (eg file name / path etc)

Rgds, Geoff

"Having been erased. the document thjat you are seeking. Must now be retyped"

Please read FAQ222-2244 before you ask a question