Handy Tip: sheetname without using VBA


=CELL(“filename”) will return the sheet name at the end of the file’s path. For example: C:\My Documents\[PhoneNumbers.xls]Phone
You can then use crazy string magic to get the sheetname from that information. Pretty cool hey?

I needed to get the active sheetname to do a vlookup using the sheetname and found this formula at
http://www.computing.net/answers/office/excel-sheet-name-in-cell/2868.html (thanks Google!)


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s