Name of Worksheet into cell 1

[lrfcbabe]

Excuse me for asking this again but I am confused on one thing. If I open an Excel spreadsheet ("Myfile.xls") it opens up using the Excel application. This is also for the most part considered a "Workbook", for me anyway being a VB(A) kinda person. In that "Workbook" there are multiple "Worksheets", the tabs that run along the bottom of the "Workbook". I used "worksheet name into cell" for my search criteria. I get back something other than what I would expect, like putting the filename into a cell or something. My question is how do I get the name of a "Worksheet" into a cell?

 

[lrfcbabe]

Thanks all but I abandoned "=RIGHT(CELL("filename"),LEN(CELL("filename"))-FIND("]",CELL("filename")))" alltogether, it is not getting me what I want.
If I saved and closed the file and opened it back up the cell that had the formula would inherit the name of the wrksht that was active at the time it was saved...throwing everything else off.

This is what I ended up doing.
wrksht/tab 1 i named "12-26-2008"
C4 = '12-26-2008'
wrksht/tab 2 i named "1-9-2009"
C4 = '12-26-2008'!C4+14
wrksht/tab 3 i named "1-23-2009"
C4 = '1-3-2008'!C4+14
and so on.

I was hoping to update the cells as I changed the wrksht/tab name..I still do with the addition of updating C4 in the first wrksht/tab.
I wonder can I change the wrksht/tab name to what is in the cell?

Anyway, stars for all...can I give stars to all?

 

[xlbo]

<cough>FAQs</cough>

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[SkipVought]

wrksht/tab 1 i named "12-26-2008"
C4 = '12-26-2008'
wrksht/tab 2 i named "1-9-2009"
C4 = '12-26-2008'!C4+14
wrksht/tab 3 i named "1-23-2009"

You do realize that in almost all cases, this is a VERY BAD workbook design -- chopping similar data up into different sheets.

1. It multiplies maintenance.
2. It defeats the plethora of rich data analysis & data reporting features, making these tasks orders of magnitude more difficult, lending to error. Heck, you're ALREADY in the throes of anguish that you have wreaked upon yourself, as demonstrated by this thread.

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}