D DavidObeid Dec 11, 2003 #1 I am after a way to automatically report the name of a worksheet into a cell. Is there a way to do this?
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 Dec 11, 2003 #2 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
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 Dec 11, 2003 #3 Dear Kevin, Thanks, but I kept getting the #Value error What could I be doing wrong? My filename is "2004.xls"
Dear Kevin, Thanks, but I kept getting the #Value error What could I be doing wrong? My filename is "2004.xls"
D DavidObeid Dec 11, 2003 #4 I got it. I made the istake of thinking that I had to substitute my filename in place of "filename". Thanks heaps.
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 Dec 11, 2003 #5 David, My pleasure. And thank you for coming back to let us know the solution worked. Regards, Kevin
