Handy Tip: sheetname without using VBA

=MID(CELL(“filename”,A1:A1),(FIND(“]”,CELL(“filename”,A1:A1))+1),(LEN(CELL(“filename”,A1:A1))-FIND(“]”,CELL(“filename”,A1:A1))+1))

=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!)

Advertisements

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s