Insert Excel wooksheet name in cell 1

[jnix]

How can I get excel to insert the worksheet name in a cell on the worksheet?thanks,
jnxi

 

[RoyVidar]

Hi!

You could try something like:

[tt]=CELL("FILENAME",F10)[/tt]

"Stolen from" xlbo's excellent faq faq68-2561

HTH Roy-Vidar

 

[RoyVidar]

Of course I stole and pasted the wrong formula, sorry. Previous one displays complete path, this one should provide sheet name:

[tt]=MID(CELL("FILENAME",F10),FIND("",CELL("FILENAME",F10))+1,255)[/tt]

In my version i had to tweak it a little to:

[tt]=MID(CELL("FILENAME",F10),FIND("]",CELL("FILENAME",F10))+1,255)[/tt]

 

[KenWright]

Don't forget, file needs to have been saved first for it to work.

Regards
Ken...............

----------------------------------------------------------------------------
Attitude - A little thing that makes a BIG difference
----------------------------------------------------------------------------