What Excel function returns the current worksheet name?

[jr]

It sounds simple, but short of running a macro that puts the worksheet name
into a cell, I can't find an Excel function that returns the active worksheet
name.

Anybody have a good idea for me?

 

[NH]

type this where you want the file name displayed
=cell("filename",a1)

 

[Frank Kabel]

Hi
see:
http://www.xldynamic.com/source/xld.xlFAQ0002.html