A formula that reports sheet names

  • Thread starter Thread starter DavidObeid
  • Start date Start date
D

DavidObeid

I am after a way to automatically report the name of a worksheet into a
cell.

Is there a way to do this?
 
Hi David,

From: David McRitchie ([email protected])
Subject: Re: worksheet tab
View: Complete Thread (14 articles)
Original Format
Newsgroups: microsoft.public.excel.misc
Date: 2002-12-31 06:51:28 PST


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

I found this using Google Excel newsgroup search.

Hope this helps.

Regards,
Kevin
 
Dear Kevin,

Thanks, but I kept getting the #Value error

What could I be doing wrong? My filename is "2004.xls"
 
I got it. I made the istake of thinking that I had to substitute my
filename in place of "filename".

Thanks heaps.
 
David,

My pleasure. And thank you for coming back to let us know the solution
worked.

Regards,
Kevin
 
Back
Top