{"id":1330,"date":"2018-04-03T01:22:16","date_gmt":"2018-04-02T19:22:16","guid":{"rendered":"http:\/\/xlfxs.com\/?p=1330"},"modified":"2018-04-03T01:22:16","modified_gmt":"2018-04-02T19:22:16","slug":"worksheet-name-dynamically-using-formula","status":"publish","type":"post","link":"https:\/\/xlfxs.com\/?p=1330","title":{"rendered":"Worksheet name, dynamically using formula"},"content":{"rendered":"<p>Get the name of the active worksheet in active workbook, using formulas only<\/p>\n<pre>This function needs to have workbook saved<\/pre>\n<p>Then, you just paste below formula into any cell &#8230;<\/p>\n<p><!--more--><\/p>\n<p>Other than A1 \ud83d\ude42<\/p>\n<p>&nbsp;<br \/>\n<code>=MID(CELL(\"filename\",$A$1),SEARCH(\"]\",CELL(\"filename\",$A$1))+1,500)<\/code><\/p>\n<p><a href=\"http:\/\/xlfxs.com\/wp-content\/uploads\/2018\/04\/Screenshot_1-2.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-1333\" src=\"http:\/\/xlfxs.com\/wp-content\/uploads\/2018\/04\/Screenshot_1-2-300x230.jpg\" alt=\"\" width=\"300\" height=\"230\"><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Get the name of the active worksheet in active workbook, using formulas only This function needs to have workbook saved Then, you just paste below formula into any cell &#8230;<\/p>\n","protected":false},"author":1,"featured_media":1331,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[70,40,52],"tags":[],"class_list":["post-1330","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-cell","category-mid","category-search"],"_links":{"self":[{"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/posts\/1330","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1330"}],"version-history":[{"count":0,"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/posts\/1330\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/media\/1331"}],"wp:attachment":[{"href":"https:\/\/xlfxs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1330"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1330"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1330"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}