{"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\/es\/excel-vba-coding-pattern-named-range\/","title":{"rendered":"Patr\u00f3n de codificaci\u00f3n VBA: rango con nombre"},"content":{"rendered":"<p>Incluso si la direcci\u00f3n de referencia de Range se cambia durante la codificaci\u00f3n de VBA, si usa Named Range (rango con nombre), puede evitar que el c\u00f3digo fuente cambie independientemente del cambio de direcci\u00f3n de referencia. Veamos lo siguiente.<\/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;Tabla de contenidos&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=\"Pesta\u00f1a de contenido alternativo\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Palanca<\/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\/es\/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. Referencia de rango usando direcci\u00f3n absoluta<\/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\/es\/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. Hacer referencia a un rango por nombre<\/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\/es\/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. Crear un rango con nombre<\/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\/es\/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. Escriba el c\u00f3digo de referencia del nombre<\/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\/es\/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. Ventajas de usar nombres<\/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. Referencia de rango usando direcci\u00f3n absoluta<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Entre los muchos m\u00e9todos para hacer referencia a Range en Excel VBA, el m\u00e9todo m\u00e1s utilizado es el siguiente.<\/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>En Rango (&quot;B2&quot;), &quot;B2&quot; representa la direcci\u00f3n absoluta de la celda en la hoja de Excel. Al agregar una fila o columna cambiando la forma de una hoja, &quot;B2&quot; debe cambiarse a &quot;B3&quot; o &quot;C2&quot;. Si la direcci\u00f3n absoluta de la celda est\u00e1 solo en un lugar en el c\u00f3digo VBA, se puede cambiar f\u00e1cilmente.<\/p>\n\n\n\n<p>Si el cambio en el rango al que se har\u00e1 referencia no afecta los cambios en el c\u00f3digo VBA, asigne un nombre al rango para que el c\u00f3digo VBA se refiera al nombre en lugar de a la direcci\u00f3n absoluta de la celda, y si la ubicaci\u00f3n a la que se hace referencia cambia, el nombre Puede cambiar la direcci\u00f3n de la celda especificada en .<\/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. Hacer referencia a un rango por nombre<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. Crear un rango con nombre<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Primero, cree un nombre para el rango ejecutando el siguiente proceso. F\u00f3rmulas &gt; Administrador de nombres &gt; Nuevo\u2026 correr (Ver la siguiente figura)<\/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>Figura 1. crear nombre<\/figcaption><\/figure>\n<\/div>\n\n\n<p>En la ventana &quot;Nuevo nombre&quot;, establezca el nombre, el rango, la descripci\u00f3n y el objetivo de referencia.<\/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>Figura 2. escoger un nombre<\/figcaption><\/figure>\n<\/div>\n\n\n<p>Aqu\u00ed, &quot;alcance&quot; significa el alcance para referirse al nombre, y puede elegir uno de los dos.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Hoja (p. ej., Hoja1): solo se puede hacer referencia a \u00e9l por su nombre en el c\u00f3digo VBA escrito en esa hoja<\/li><li>Libro de trabajo: se puede hacer referencia a la hoja completa, el m\u00f3dulo, la clase, etc. por nombre<\/li><\/ul>\n\n\n\n<p>Como referencia, los nombres definidos en la hoja se copian juntos al copiar la hoja. En este momento, si necesita hacer referencia al mismo nombre en varias hojas, config\u00farelo en &quot;Hoja&quot;, y si no necesita hacer referencia al mismo nombre, config\u00farelo en &quot;Libro de trabajo&quot;. Cuando crea un nombre, puede verificar el resultado de la siguiente manera.<\/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>Figura 3. resultado de creaci\u00f3n de nombre<\/figcaption><\/figure>\n<\/div>\n\n\n<p>Si selecciona la celda donde se define el nombre, el nombre se muestra en el cuadro de nombre.<\/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>Figura 4. Mostrar el nombre al seleccionar un rango con nombre<\/figcaption><\/figure>\n<\/div>\n\n\n<p>Si selecciona una celda cuyo nombre no est\u00e1 definido, la direcci\u00f3n absoluta de la celda se muestra en el cuadro de nombre.<\/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>Figura 5. Al seleccionar un rango sin nombre, se muestra la direcci\u00f3n absoluta del rango.<\/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. Escriba el c\u00f3digo de referencia del nombre<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Despu\u00e9s de definir el nombre, escriba el c\u00f3digo VBA que hace referencia al nombre definido. Un ejemplo sencillo es:<\/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. Ventajas de usar nombres<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Si se cambia la direcci\u00f3n absoluta, se puede cambiar la direcci\u00f3n absoluta a la que hace referencia el nombre correspondiente. Es conveniente porque no hay necesidad de buscar y cambiar todo el c\u00f3digo fuente de VBA.<\/p>\n\n\n\n<p>Cuando se agrega o elimina una columna o fila, la direcci\u00f3n absoluta a la que hace referencia el nombre cambia autom\u00e1ticamente. Por ejemplo, si hay un nombre que se refiere a la celda &quot;B2&quot;, agregar una fila entre las filas 1 y 2 lo cambiar\u00e1 autom\u00e1ticamente a &quot;B3&quot;.<\/p>\n\n\n\n<p>Mejora la legibilidad al leer c\u00f3digo VBA. Para averiguar qu\u00e9 significa &quot;B2&quot; en el c\u00f3digo fuente, debe abrir y mirar la hoja, pero si usa nombres como &quot;BaseRange&quot;, &quot;TableListBase&quot;, &quot;ColumnListBase&quot; y &quot;ValueListBase&quot;, puede entender el significado sin abrir la hoja. Esto lo hace mucho m\u00e1s simple<\/p>\n\n\n\n<p>Informaci\u00f3n Adicional <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\">Utilice el Administrador de nombres de Excel (microsoft.com)<\/a> puede encontrarse en<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity is-style-dots\"\/>\n\n\n\n<p>En lo anterior, vimos el m\u00e9todo y las ventajas de usar un nombre para un rango. Espero que le ayude con la codificaci\u00f3n de VBA, y si tiene alguna pregunta, deje un comentario.<\/p>","protected":false},"excerpt":{"rendered":"<p>Incluso si la direcci\u00f3n de referencia de Range se cambia durante la codificaci\u00f3n de VBA, si usa Named Range (rango con nombre), puede evitar que el c\u00f3digo fuente cambie independientemente del cambio de direcci\u00f3n de referencia. Veamos lo siguiente. 1. Referencia de rango utilizando direcci\u00f3n absoluta El m\u00e9todo m\u00e1s utilizado entre muchos m\u00e9todos para hacer referencia a un rango en Excel VBA es el siguiente. En Rango(\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":[17,74,75,94,95],"class_list":["post-11620","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-vba-coding-pattern","tag-vba","tag-74","tag-codding-pattern","tag-named-range","tag-95"],"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\/es\/excel-vba-coding-pattern-named-range\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\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\/es\/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=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Zerom\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutos\" \/>\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\":[\"\uc5d1\uc140VBA\",\"\ucf54\ub529\ud328\ud134\",\"Codding Pattern\",\"Named Range\",\"\uba85\uba85\ub41c \ubc94\uc704\"],\"articleSection\":[\"\uc5d1\uc140 VBA \ucf54\ub529\ud328\ud134\"],\"inLanguage\":\"es\",\"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\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/prodskill.com\\\/excel-vba-coding-pattern-named-range\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@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\":\"es\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#\\\/schema\\\/person\\\/bbad0870c78008c82edbe0960fe768bd\",\"name\":\"Zerom\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@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\\\/es\\\/author\\\/proda\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Patr\u00f3n de codificaci\u00f3n VBA: rango con nombre - Habilidad de productividad","description":"Al programar en VBA, usar un rango con nombre garantiza que el c\u00f3digo fuente permanezca inalterado, independientemente de los cambios en la direcci\u00f3n de referencia. Simplemente cree un nombre y escriba el c\u00f3digo usando la referencia con nombre.","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\/es\/excel-vba-coding-pattern-named-range\/","og_locale":"es_ES","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\/es\/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":{"Escrito por":"Zerom","Tiempo de lectura":"4 minutos"},"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":["\uc5d1\uc140VBA","\ucf54\ub529\ud328\ud134","Codding Pattern","Named Range","\uba85\uba85\ub41c \ubc94\uc704"],"articleSection":["\uc5d1\uc140 VBA \ucf54\ub529\ud328\ud134"],"inLanguage":"es","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":"Patr\u00f3n de codificaci\u00f3n VBA: rango con nombre - Habilidad de productividad","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":"Al programar en VBA, usar un rango con nombre garantiza que el c\u00f3digo fuente permanezca inalterado, independientemente de los cambios en la direcci\u00f3n de referencia. Simplemente cree un nombre y escriba el c\u00f3digo usando la referencia con nombre.","breadcrumb":{"@id":"https:\/\/prodskill.com\/excel-vba-coding-pattern-named-range\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/prodskill.com\/excel-vba-coding-pattern-named-range\/"]}]},{"@type":"ImageObject","inLanguage":"es","@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":"Habilidades de productividad","description":"Meta Pensamiento, Meta Trabajo","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":"es"},{"@type":["Person","Organization"],"@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd","name":"Cerom","image":{"@type":"ImageObject","inLanguage":"es","@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\/es\/author\/proda\/"}]}},"_links":{"self":[{"href":"https:\/\/prodskill.com\/es\/wp-json\/wp\/v2\/posts\/11620","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prodskill.com\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prodskill.com\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prodskill.com\/es\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prodskill.com\/es\/wp-json\/wp\/v2\/comments?post=11620"}],"version-history":[{"count":0,"href":"https:\/\/prodskill.com\/es\/wp-json\/wp\/v2\/posts\/11620\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prodskill.com\/es\/wp-json\/wp\/v2\/media\/11621"}],"wp:attachment":[{"href":"https:\/\/prodskill.com\/es\/wp-json\/wp\/v2\/media?parent=11620"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prodskill.com\/es\/wp-json\/wp\/v2\/categories?post=11620"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prodskill.com\/es\/wp-json\/wp\/v2\/tags?post=11620"}],"curies":[{"name":"gracias","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}