VBA TIPS
Formula to determine sheet name

The following formula returens the name of the worksheet.

=MID(CELL("filename",$A$1),FIND("]",CELL("filename",$A$1))+1,31)





CELL returns information about the formatting, location, or contents of the upper-left cell in a reference.
And the syntax is CELL(info_type,reference).

Filename is an argument for info_type and it's stands for (including full path) of the file that contains reference, as text. Returns empty text ("") if the worksheet that contains reference has not yet been saved.

| HOME |
Copyright © cellmasters.net - colo's junk room All Right Reserved
ABOUT
WORKS
THE CELL MASTERS
CONTACT
LINKS
Tips and Information about Microsoft Excel|Masaru Kaji aka Colo