{"id":11620,"date":"2022-09-26T15:42:45","date_gmt":"2022-09-26T06:42:45","guid":{"rendered":"https:\/\/prodskill.com\/?p=11620"},"modified":"2022-10-04T23:06:22","modified_gmt":"2022-10-04T14:06:22","slug":"excel-vba-coding-pattern-named-range","status":"publish","type":"post","link":"https:\/\/prodskill.com\/en\/excel-vba-coding-pattern-named-range\/","title":{"rendered":"VBA Coding Pattern: Named Range"},"content":{"rendered":"<p>Even if the reference address of Range is changed during VBA coding, if you use Named Range (named range), you can prevent the source code from changing regardless of the reference address change. Let&#039;s look at the following.<\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">&lt;&lt;Table of Contents&gt;&gt;<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewbox=\"0 0 24 24\" version=\"1.2\" baseprofile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/prodskill.com\/en\/excel-vba-coding-pattern-named-range\/#1_%EC%A0%88%EB%8C%80%EC%A3%BC%EC%86%8C%EB%A5%BC_%EC%82%AC%EC%9A%A9%ED%95%9C_Range_%EC%B0%B8%EC%A1%B0\" >1. Range reference using absolute address<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/prodskill.com\/en\/excel-vba-coding-pattern-named-range\/#2_%EC%9D%B4%EB%A6%84%EC%9D%84_%EC%82%AC%EC%9A%A9%ED%95%9C_Range_%EC%B0%B8%EC%A1%B0\" >2. Referencing a Range by Name<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/prodskill.com\/en\/excel-vba-coding-pattern-named-range\/#21_Named_Range_%EB%AA%85%EB%AA%85%EB%90%9C_%EB%B2%94%EC%9C%84%EC%83%9D%EC%84%B1\" >2.1. Create a Named Range<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/prodskill.com\/en\/excel-vba-coding-pattern-named-range\/#22_%EC%9D%B4%EB%A6%84_%EC%B0%B8%EC%A1%B0_%EC%BD%94%EB%93%9C_%EC%9E%91%EC%84%B1\" >2.2. Write name reference code<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/prodskill.com\/en\/excel-vba-coding-pattern-named-range\/#23_%EC%9D%B4%EB%A6%84_%EC%82%AC%EC%9A%A9%EC%9D%98_%EC%9E%A5%EC%A0%90\" >2.3. Advantages of using names<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\" id=\"1._\uc808\ub300\uc8fc\uc18c\ub97c_\uc0ac\uc6a9\ud55c_Range_\ucc38\uc870\"><span class=\"ez-toc-section\" id=\"1_%EC%A0%88%EB%8C%80%EC%A3%BC%EC%86%8C%EB%A5%BC_%EC%82%AC%EC%9A%A9%ED%95%9C_Range_%EC%B0%B8%EC%A1%B0\"><\/span>1. Range reference using absolute address<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Among the many methods of referencing Range in Excel VBA, the most frequently used method is as follows.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"visualbasic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-auto-translation=\"\">Dim sVal As String\nsVal = Range(\"B2\").Value2\nDebug.Print sVal<\/pre>\n\n\n\n<p>In Range(\u201cB2\u201d), \u201cB2\u201d represents the cell absolute address on the Excel sheet. When adding a row or column by changing the form of a sheet, \u201cB2\u201d must be changed to \u201cB3\u201d or \u201cC2\u201d. If the cell absolute address is only in one place in the VBA code, it can be easily changed.<\/p>\n\n\n\n<p>If the change in the range to be referenced does not affect changes in the VBA code, assign a name to the range so that the VBA code refers to the name rather than the absolute address of the cell, and if the referenced location changes, the name You can change the cell address specified in .<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"2._\uc774\ub984\uc744_\uc0ac\uc6a9\ud55c_Range_\ucc38\uc870\"><span class=\"ez-toc-section\" id=\"2_%EC%9D%B4%EB%A6%84%EC%9D%84_%EC%82%AC%EC%9A%A9%ED%95%9C_Range_%EC%B0%B8%EC%A1%B0\"><\/span>2. Referencing a Range by Name<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"2.1._\uc774\ub984_\uc0dd\uc131\"><span class=\"ez-toc-section\" id=\"21_Named_Range_%EB%AA%85%EB%AA%85%EB%90%9C_%EB%B2%94%EC%9C%84%EC%83%9D%EC%84%B1\"><\/span>2.1. Create a Named Range<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>First, create a name for the Range by executing the following process. Formulas &gt; Name Manager &gt; New\u2026 run (See the following picture)<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-174.png\"><img loading=\"lazy\" decoding=\"async\" width=\"636\" height=\"682\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-174.png\" alt=\"\uadf8\ub9bc1. \uc774\ub984 \uc0dd\uc131\" class=\"wp-image-11621\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-174.png 636w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-174-280x300.png 280w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-174-11x12.png 11w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-174-22x24.png 22w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-174-34x36.png 34w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-174-45x48.png 45w\" sizes=\"auto, (max-width: 636px) 100vw, 636px\" \/><\/a><figcaption>Figure 1. create name<\/figcaption><\/figure>\n<\/div>\n\n\n<p>In the \u201cNew Name\u201d window, set the name, range, description, and reference target.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-175.png\"><img loading=\"lazy\" decoding=\"async\" width=\"316\" height=\"239\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-175.png\" alt=\"\uadf8\ub9bc2. \uc774\ub984 \uc124\uc815\" class=\"wp-image-11622\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-175.png 316w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-175-300x227.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-175-16x12.png 16w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-175-24x18.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-175-36x27.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-175-48x36.png 48w\" sizes=\"auto, (max-width: 316px) 100vw, 316px\" \/><\/a><figcaption>Figure 2. set name<\/figcaption><\/figure>\n<\/div>\n\n\n<p>Here, \u201cscope\u201d means the scope to refer to the name, and you can choose one of the two.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Sheet (e.g. Sheet1): can only be referenced by name in VBA code written on that sheet<\/li><li>Workbook: Full sheet, module, class, etc. can be referenced by name<\/li><\/ul>\n\n\n\n<p>For reference, the names defined in the sheet are copied together when copying the sheet. At this time, if you need to refer to the same name in multiple sheets, set it to \u201cSheet\u201d, and if you do not need to refer to the same name, set it to \u201cWorkbook\u201d. When you create a name, you can check the result as follows.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-176.png\"><img loading=\"lazy\" decoding=\"async\" width=\"566\" height=\"439\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-176.png\" alt=\"\uadf8\ub9bc3. \uc774\ub984 \uc0dd\uc131 \uacb0\uacfc\" class=\"wp-image-11623\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-176.png 566w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-176-300x233.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-176-15x12.png 15w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-176-24x19.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-176-36x28.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-176-48x37.png 48w\" sizes=\"auto, (max-width: 566px) 100vw, 566px\" \/><\/a><figcaption>Figure 3. name creation result<\/figcaption><\/figure>\n<\/div>\n\n\n<p>If you select the cell where the name is defined, the name is displayed in the name box.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-177.png\"><img loading=\"lazy\" decoding=\"async\" width=\"255\" height=\"279\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-177.png\" alt=\"\uadf8\ub9bc4. \uc774\ub984\uc774 \ubd80\uc5ec\ub41c \ubc94\uc704 \uc120\ud0dd\uc2dc \ud574\ub2f9 \uc774\ub984 \ud45c\uc2dc\" class=\"wp-image-11624\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-177.png 255w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-177-11x12.png 11w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-177-22x24.png 22w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-177-33x36.png 33w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-177-44x48.png 44w\" sizes=\"auto, (max-width: 255px) 100vw, 255px\" \/><\/a><figcaption>Figure 4. Display the name when selecting a named range<\/figcaption><\/figure>\n<\/div>\n\n\n<p>If you select a cell whose name is not defined, the absolute address of the cell is displayed in the name box.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-178.png\"><img loading=\"lazy\" decoding=\"async\" width=\"255\" height=\"279\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-178.png\" alt=\"\uadf8\ub9bc5. \uc774\ub984\uc774 \ubd80\uc5ec\ub418\uc9c0 \uc54a\uc740 \ubc94\uc704 \uc120\ud0dd\uc2dc \ubc94\uc704 \uc808\ub300\uc8fc\uc18c \ud45c\uc2dc\" class=\"wp-image-11625\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-178.png 255w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-178-11x12.png 11w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-178-22x24.png 22w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-178-33x36.png 33w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-178-44x48.png 44w\" sizes=\"auto, (max-width: 255px) 100vw, 255px\" \/><\/a><figcaption>Figure 5. When selecting an unnamed range, the absolute address of the range is displayed.<\/figcaption><\/figure>\n<\/div>\n\n\n<h3 class=\"wp-block-heading\" id=\"2.2._\uc774\ub984_\ucc38\uc870_\ucf54\ub4dc_\uc791\uc131\"><span class=\"ez-toc-section\" id=\"22_%EC%9D%B4%EB%A6%84_%EC%B0%B8%EC%A1%B0_%EC%BD%94%EB%93%9C_%EC%9E%91%EC%84%B1\"><\/span>2.2. Write name reference code<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>After defining the name, write VBA code referring to the defined name. A simple example is:<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"visualbasic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-auto-translation=\"\">Dim sVal As String\nsVal = Range(\"BaseRange\").Value2\nDebug.Print sVal<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"2.3._\uc774\ub984_\uc0ac\uc6a9\uc758_\uc7a5\uc810\"><span class=\"ez-toc-section\" id=\"23_%EC%9D%B4%EB%A6%84_%EC%82%AC%EC%9A%A9%EC%9D%98_%EC%9E%A5%EC%A0%90\"><\/span>2.3. Advantages of using names<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>If the absolute address is changed, the absolute address referred to by the corresponding name can be changed. It is convenient because there is no need to find and change the entire VBA source code.<\/p>\n\n\n\n<p>When a column or row is added or deleted, the absolute address to which the name refers is automatically changed. For example, if there is a name referring to cell \u201cB2\u201d, adding a row between rows 1 and 2 will automatically change it to \u201cB3\u201d.<\/p>\n\n\n\n<p>Improves readability when reading VBA code. To find out what \u201cB2\u201d means in the source code, you have to open and look at the sheet, but if you use names such as \u201cBaseRange\u201d, \u201cTableListBase\u201d, \u201cColumnListBase\u201d, and \u201cValueListBase\u201d, you can understand the meaning without opening the sheet. this makes it much simpler<\/p>\n\n\n\n<p>additional information <a href=\"https:\/\/support.microsoft.com\/ko-kr\/office\/excel-%EC%9D%B4%EB%A6%84-%EA%B4%80%EB%A6%AC%EC%9E%90-%EC%82%AC%EC%9A%A9-4d8c4c2b-9f7d-44e3-a3b4-9f61bd5c64e4\" target=\"_blank\" rel=\"noreferrer noopener\">Use Excel Name Manager (microsoft.com)<\/a> can be found in<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity is-style-dots\"\/>\n\n\n\n<p>In the above, we looked at the method and advantages of using a name for a Range. I hope it will help you with VBA coding, and if you have any questions, please leave a comment.<\/p>","protected":false},"excerpt":{"rendered":"<p>Even if the reference address of Range is changed during VBA coding, if you use Named Range (named range), you can prevent the source code from changing regardless of the reference address change. Let&#039;s look at the following. 1. Range reference using absolute address The most frequently used method among many methods to refer to a Range in Excel VBA is as follows. In Range(\u201cB2\u201d)...<\/p>","protected":false},"author":1,"featured_media":11621,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[29],"tags":[75,94,95,17,74],"class_list":["post-11620","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-vba-coding-pattern","tag-codding-pattern","tag-named-range","tag-95","tag-vba","tag-74"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>VBA \ucf54\ub529 \ud328\ud134: Named Range (\uba85\uba85\ub41c \ubc94\uc704) - \uc0dd\uc0b0\uc131 Skill<\/title>\n<meta name=\"description\" content=\"VBA \ucf54\ub529\uc2dc Range\uc758 \ucc38\uc870\uc8fc\uc18c\uac00 \ubcc0\uacbd\ub418\ub354\ub77c\ub3c4 Named Range (\uba85\uba85\ub41c \ubc94\uc704)\ub97c \uc0ac\uc6a9\ud558\uba74 \ucc38\uc870\uc8fc\uc18c \ubcc0\uacbd\uacfc \uc0c1\uad00\uc5c6\uc774 \uc18c\uc2a4\ucf54\ub4dc\uac00 \ubcc0\uacbd\ub418\uc9c0 \uc54a\ub3c4\ub85d \ud560 \uc218 \uc788\ub2e4. \uc774\ub984\uc744 \uc0dd\uc131\ud558\uace0, \uc774\ub984 \ucc38\uc870\ub97c \uc0ac\uc6a9\ud558\uc5ec \ucf54\ub4dc\ub97c \uc791\uc131\ud558\uba74 \ub41c\ub2e4.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/prodskill.com\/en\/excel-vba-coding-pattern-named-range\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"VBA \ucf54\ub529 \ud328\ud134: Named Range (\uba85\uba85\ub41c \ubc94\uc704) - \uc0dd\uc0b0\uc131 Skill\" \/>\n<meta property=\"og:description\" content=\"VBA \ucf54\ub529\uc2dc Range\uc758 \ucc38\uc870\uc8fc\uc18c\uac00 \ubcc0\uacbd\ub418\ub354\ub77c\ub3c4 Named Range (\uba85\uba85\ub41c \ubc94\uc704)\ub97c \uc0ac\uc6a9\ud558\uba74 \ucc38\uc870\uc8fc\uc18c \ubcc0\uacbd\uacfc \uc0c1\uad00\uc5c6\uc774 \uc18c\uc2a4\ucf54\ub4dc\uac00 \ubcc0\uacbd\ub418\uc9c0 \uc54a\ub3c4\ub85d \ud560 \uc218 \uc788\ub2e4. \uc774\ub984\uc744 \uc0dd\uc131\ud558\uace0, \uc774\ub984 \ucc38\uc870\ub97c \uc0ac\uc6a9\ud558\uc5ec \ucf54\ub4dc\ub97c \uc791\uc131\ud558\uba74 \ub41c\ub2e4.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/prodskill.com\/en\/excel-vba-coding-pattern-named-range\/\" \/>\n<meta property=\"og:site_name\" content=\"\uc0dd\uc0b0\uc131 Skill\" \/>\n<meta property=\"article:published_time\" content=\"2022-09-26T06:42:45+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-10-04T14:06:22+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-174.png\" \/>\n\t<meta property=\"og:image:width\" content=\"636\" \/>\n\t<meta property=\"og:image:height\" content=\"682\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Zerom\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Zerom\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-coding-pattern-named-range\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-coding-pattern-named-range\\\/\"},\"author\":{\"name\":\"Zerom\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#\\\/schema\\\/person\\\/bbad0870c78008c82edbe0960fe768bd\"},\"headline\":\"VBA \ucf54\ub529 \ud328\ud134: Named Range (\uba85\uba85\ub41c \ubc94\uc704)\",\"datePublished\":\"2022-09-26T06:42:45+00:00\",\"dateModified\":\"2022-10-04T14:06:22+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-coding-pattern-named-range\\\/\"},\"wordCount\":57,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#\\\/schema\\\/person\\\/bbad0870c78008c82edbe0960fe768bd\"},\"image\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-coding-pattern-named-range\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/image-174.png\",\"keywords\":[\"Codding Pattern\",\"Named Range\",\"\uba85\uba85\ub41c \ubc94\uc704\",\"\uc5d1\uc140VBA\",\"\ucf54\ub529\ud328\ud134\"],\"articleSection\":[\"\uc5d1\uc140 VBA \ucf54\ub529\ud328\ud134\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/prodskill.com\\\/excel-vba-coding-pattern-named-range\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-coding-pattern-named-range\\\/\",\"url\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-coding-pattern-named-range\\\/\",\"name\":\"VBA \ucf54\ub529 \ud328\ud134: Named Range (\uba85\uba85\ub41c \ubc94\uc704) - \uc0dd\uc0b0\uc131 Skill\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-coding-pattern-named-range\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-coding-pattern-named-range\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/image-174.png\",\"datePublished\":\"2022-09-26T06:42:45+00:00\",\"dateModified\":\"2022-10-04T14:06:22+00:00\",\"description\":\"VBA \ucf54\ub529\uc2dc Range\uc758 \ucc38\uc870\uc8fc\uc18c\uac00 \ubcc0\uacbd\ub418\ub354\ub77c\ub3c4 Named Range (\uba85\uba85\ub41c \ubc94\uc704)\ub97c \uc0ac\uc6a9\ud558\uba74 \ucc38\uc870\uc8fc\uc18c \ubcc0\uacbd\uacfc \uc0c1\uad00\uc5c6\uc774 \uc18c\uc2a4\ucf54\ub4dc\uac00 \ubcc0\uacbd\ub418\uc9c0 \uc54a\ub3c4\ub85d \ud560 \uc218 \uc788\ub2e4. \uc774\ub984\uc744 \uc0dd\uc131\ud558\uace0, \uc774\ub984 \ucc38\uc870\ub97c \uc0ac\uc6a9\ud558\uc5ec \ucf54\ub4dc\ub97c \uc791\uc131\ud558\uba74 \ub41c\ub2e4.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-coding-pattern-named-range\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/prodskill.com\\\/excel-vba-coding-pattern-named-range\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-coding-pattern-named-range\\\/#primaryimage\",\"url\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/image-174.png\",\"contentUrl\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/image-174.png\",\"width\":636,\"height\":682},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-coding-pattern-named-range\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"VBA \ucf54\ub529 \ud328\ud134: Named Range (\uba85\uba85\ub41c \ubc94\uc704)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#website\",\"url\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/\",\"name\":\"\uc0dd\uc0b0\uc131 Skill\",\"description\":\"Meta Thinking, Meta Working\",\"publisher\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#\\\/schema\\\/person\\\/bbad0870c78008c82edbe0960fe768bd\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#\\\/schema\\\/person\\\/bbad0870c78008c82edbe0960fe768bd\",\"name\":\"Zerom\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/productivity_clockgear.png\",\"url\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/productivity_clockgear.png\",\"contentUrl\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/productivity_clockgear.png\",\"width\":512,\"height\":512,\"caption\":\"Zerom\"},\"logo\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/productivity_clockgear.png\"},\"url\":\"https:\\\/\\\/prodskill.com\\\/en\\\/author\\\/proda\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"VBA Coding Pattern: Named Range - Productivity Skill","description":"When coding in VBA, using a Named Range ensures that your source code remains unchanged, regardless of changes to the reference address. Simply create a name and write your code using the named reference.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/prodskill.com\/en\/excel-vba-coding-pattern-named-range\/","og_locale":"en_US","og_type":"article","og_title":"VBA \ucf54\ub529 \ud328\ud134: Named Range (\uba85\uba85\ub41c \ubc94\uc704) - \uc0dd\uc0b0\uc131 Skill","og_description":"VBA \ucf54\ub529\uc2dc Range\uc758 \ucc38\uc870\uc8fc\uc18c\uac00 \ubcc0\uacbd\ub418\ub354\ub77c\ub3c4 Named Range (\uba85\uba85\ub41c \ubc94\uc704)\ub97c \uc0ac\uc6a9\ud558\uba74 \ucc38\uc870\uc8fc\uc18c \ubcc0\uacbd\uacfc \uc0c1\uad00\uc5c6\uc774 \uc18c\uc2a4\ucf54\ub4dc\uac00 \ubcc0\uacbd\ub418\uc9c0 \uc54a\ub3c4\ub85d \ud560 \uc218 \uc788\ub2e4. \uc774\ub984\uc744 \uc0dd\uc131\ud558\uace0, \uc774\ub984 \ucc38\uc870\ub97c \uc0ac\uc6a9\ud558\uc5ec \ucf54\ub4dc\ub97c \uc791\uc131\ud558\uba74 \ub41c\ub2e4.","og_url":"https:\/\/prodskill.com\/en\/excel-vba-coding-pattern-named-range\/","og_site_name":"\uc0dd\uc0b0\uc131 Skill","article_published_time":"2022-09-26T06:42:45+00:00","article_modified_time":"2022-10-04T14:06:22+00:00","og_image":[{"width":636,"height":682,"url":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-174.png","type":"image\/png"}],"author":"Zerom","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Zerom","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/prodskill.com\/excel-vba-coding-pattern-named-range\/#article","isPartOf":{"@id":"https:\/\/prodskill.com\/excel-vba-coding-pattern-named-range\/"},"author":{"name":"Zerom","@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd"},"headline":"VBA \ucf54\ub529 \ud328\ud134: Named Range (\uba85\uba85\ub41c \ubc94\uc704)","datePublished":"2022-09-26T06:42:45+00:00","dateModified":"2022-10-04T14:06:22+00:00","mainEntityOfPage":{"@id":"https:\/\/prodskill.com\/excel-vba-coding-pattern-named-range\/"},"wordCount":57,"commentCount":0,"publisher":{"@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd"},"image":{"@id":"https:\/\/prodskill.com\/excel-vba-coding-pattern-named-range\/#primaryimage"},"thumbnailUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-174.png","keywords":["Codding Pattern","Named Range","\uba85\uba85\ub41c \ubc94\uc704","\uc5d1\uc140VBA","\ucf54\ub529\ud328\ud134"],"articleSection":["\uc5d1\uc140 VBA \ucf54\ub529\ud328\ud134"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/prodskill.com\/excel-vba-coding-pattern-named-range\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/prodskill.com\/excel-vba-coding-pattern-named-range\/","url":"https:\/\/prodskill.com\/excel-vba-coding-pattern-named-range\/","name":"VBA Coding Pattern: Named Range - Productivity Skill","isPartOf":{"@id":"https:\/\/prodskill.com\/ko\/#website"},"primaryImageOfPage":{"@id":"https:\/\/prodskill.com\/excel-vba-coding-pattern-named-range\/#primaryimage"},"image":{"@id":"https:\/\/prodskill.com\/excel-vba-coding-pattern-named-range\/#primaryimage"},"thumbnailUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-174.png","datePublished":"2022-09-26T06:42:45+00:00","dateModified":"2022-10-04T14:06:22+00:00","description":"When coding in VBA, using a Named Range ensures that your source code remains unchanged, regardless of changes to the reference address. Simply create a name and write your code using the named reference.","breadcrumb":{"@id":"https:\/\/prodskill.com\/excel-vba-coding-pattern-named-range\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/prodskill.com\/excel-vba-coding-pattern-named-range\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/prodskill.com\/excel-vba-coding-pattern-named-range\/#primaryimage","url":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-174.png","contentUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-174.png","width":636,"height":682},{"@type":"BreadcrumbList","@id":"https:\/\/prodskill.com\/excel-vba-coding-pattern-named-range\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/prodskill.com\/ko\/"},{"@type":"ListItem","position":2,"name":"VBA \ucf54\ub529 \ud328\ud134: Named Range (\uba85\uba85\ub41c \ubc94\uc704)"}]},{"@type":"WebSite","@id":"https:\/\/prodskill.com\/ko\/#website","url":"https:\/\/prodskill.com\/ko\/","name":"Productivity Skills","description":"Meta Thinking, Meta Working","publisher":{"@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/prodskill.com\/ko\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd","name":"Zerom","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/productivity_clockgear.png","url":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/productivity_clockgear.png","contentUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/productivity_clockgear.png","width":512,"height":512,"caption":"Zerom"},"logo":{"@id":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/productivity_clockgear.png"},"url":"https:\/\/prodskill.com\/en\/author\/proda\/"}]}},"_links":{"self":[{"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/posts\/11620","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/comments?post=11620"}],"version-history":[{"count":0,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/posts\/11620\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/media\/11621"}],"wp:attachment":[{"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/media?parent=11620"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/categories?post=11620"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/tags?post=11620"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}