A formula that reports sheet names

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?
 
K

Kevin Stecyk

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
 
D

DavidObeid

Dear Kevin,

Thanks, but I kept getting the #Value error

What could I be doing wrong? My filename is "2004.xls"
 
D

DavidObeid

I got it. I made the istake of thinking that I had to substitute my
filename in place of "filename".

Thanks heaps.
 
K

Kevin Stecyk

David,

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

Regards,
Kevin
 
Top