Name of active worksheet in cell

[Ditch1983]

Is there a simple way to make cell A1 the name of the active worksheet?

[LJMetzger]

Hi Ditch,

Try:

Please Login or Register  to view this content.

The following function gets the full name of the file. The rest of the code above extracts just the sheet name from the formula below:

Please Login or Register  to view this content.

The following link has some other useful formulas. Chip Pearson's site is full of good stuff. Thank you Chip. http://www.cpearson.com/excel/FileFolderNames.aspx


Lewis

[Ditch1983]

sorry forgot to say im using google drive, that did not work i got error: Unknown function name CELL

[LJMetzger]

I apologize for not reading what platform you were using. I have no knowledge of 'Google Drive', so I can't help you any further.

If you don't get an answer today, I suggest you close this thread as solved.

Then, start a new thread, and make sure you mention that you are using 'Google Drive' in the post. Also make a reference to this post, or the Forum Moderators will yell at you for asking the same question twice.

Lewis

[LJMetzger]

The following post may help you:
http://webapps.stackexchange.com/que...le-spreadsheet

[Ditch1983]

that works thanks for your help.

[LJMetzger]

I'm glad it worked out for you. I hate to give a wrong answer, and have someone else fix my mess. Now I feel better about the whole thing.