{"id":2490,"date":"2023-08-24T19:29:22","date_gmt":"2023-08-24T23:29:22","guid":{"rendered":"https:\/\/blog.jungwon.kim\/?p=2490"},"modified":"2023-08-24T19:29:22","modified_gmt":"2023-08-24T23:29:22","slug":"highlight-the-active-row-and-column-in-an-excel-worksheet","status":"publish","type":"post","link":"https:\/\/blog.jungwon.kim\/?p=2490","title":{"rendered":"Highlight the active row and column in an Excel worksheet"},"content":{"rendered":"\n<p><a href=\"https:\/\/globalexcelsummit.com\/post\/highlight-the-active-row-and-column-in-an-excel-worksheet\">https:\/\/globalexcelsummit.com\/post\/highlight-the-active-row-and-column-in-an-excel-worksheet<\/a><\/p>\n\n\n\n<p>Private Sub Worksheet_SelectionChange(ByVal Target As Range)<br>If Application.CutCopyMode = False Then<br>Application.Calculate<br>End If<br>End Sub<\/p>\n","protected":false},"excerpt":{"rendered":"<p>https:\/\/globalexcelsummit.com\/post\/highlight-the-active-row-and-column-in-an-excel-worksheet Private Sub Worksheet_SelectionChange(ByVal Target As Range)If Application.CutCopyMode = False ThenApplication.CalculateEnd IfEnd Sub<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"class_list":["post-2490","post","type-post","status-publish","format-standard","hentry","category-cs"],"_links":{"self":[{"href":"https:\/\/blog.jungwon.kim\/index.php?rest_route=\/wp\/v2\/posts\/2490","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.jungwon.kim\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.jungwon.kim\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.jungwon.kim\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.jungwon.kim\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2490"}],"version-history":[{"count":1,"href":"https:\/\/blog.jungwon.kim\/index.php?rest_route=\/wp\/v2\/posts\/2490\/revisions"}],"predecessor-version":[{"id":2491,"href":"https:\/\/blog.jungwon.kim\/index.php?rest_route=\/wp\/v2\/posts\/2490\/revisions\/2491"}],"wp:attachment":[{"href":"https:\/\/blog.jungwon.kim\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2490"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.jungwon.kim\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2490"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.jungwon.kim\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2490"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}