Function that Returns Worksheet Name

[Guest]

I could have sworn there was a function that returns the Worksheet name.
Similar to how NOW() returns the current date and time. Does it exist? What
is it?

I'm using Excell Professional 2003

 

[JE McGimpsey]

See

http://www.mcgimpsey.com/excel/formulae/cell_function.html

 

[Guest]

in 2002 there is a =Cells("filename")

 

[Barb Reinhardt]

=MID(CELL("filename",A1),SEARCH("]",CELL("filename",A1))+1,LEN(CELL("filename",A1))-SEARCH("]",CELL("filename",A1)))

Have Fun!