{"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\/de\/excel-vba-coding-pattern-named-range\/","title":{"rendered":"VBA-Codierungsmuster: Benannter Bereich"},"content":{"rendered":"<p>Selbst wenn die Referenzadresse von Range w\u00e4hrend der VBA-Codierung ge\u00e4ndert wird, k\u00f6nnen Sie bei Verwendung von Named Range (benannter Bereich) verhindern, dass sich der Quellcode unabh\u00e4ngig von der \u00c4nderung der Referenzadresse \u00e4ndert. Schauen wir uns das Folgende an.<\/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;Inhaltsverzeichnis&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=\"Inhaltsverzeichnis umschalten\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Umschalten<\/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\/de\/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. Bereichsreferenz mit absoluter Adresse<\/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\/de\/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. Verweisen auf einen Bereich nach Namen<\/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\/de\/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. Erstellen Sie einen benannten Bereich<\/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\/de\/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. Schreiben Sie den Namensreferenzcode<\/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\/de\/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. Vorteile der Verwendung von Namen<\/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. Bereichsreferenz mit absoluter Adresse<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Unter den vielen Methoden zum Referenzieren von Range in Excel VBA ist die am h\u00e4ufigsten verwendete Methode wie folgt.<\/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(\u201eB2\u201c) repr\u00e4sentiert \u201eB2\u201c die absolute Zellenadresse auf dem Excel-Blatt. Wenn Sie eine Zeile oder Spalte hinzuf\u00fcgen, indem Sie die Form eines Blattes \u00e4ndern, muss \u201eB2\u201c in \u201eB3\u201c oder \u201eC2\u201c ge\u00e4ndert werden. Wenn die absolute Zellenadresse nur an einer Stelle im VBA-Code steht, kann sie leicht ge\u00e4ndert werden.<\/p>\n\n\n\n<p>Wenn sich die \u00c4nderung des zu referenzierenden Bereichs nicht auf die \u00c4nderung des VBA-Codes auswirkt, weisen Sie dem Bereich einen Namen zu, sodass der VBA-Code auf den Namen und nicht auf die absolute Adresse der Zelle verweist, und wenn sich die referenzierte Stelle \u00e4ndert, den Namen Sie k\u00f6nnen die in angegebene Zellenadresse \u00e4ndern.<\/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. Verweisen auf einen Bereich nach Namen<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. Erstellen Sie einen benannten Bereich<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Erstellen Sie zun\u00e4chst einen Namen f\u00fcr den Bereich, indem Sie den folgenden Prozess ausf\u00fchren. Formeln &gt; Namensverwaltung &gt; Neu\u2026 Lauf (Siehe folgende Abbildung)<\/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>Abbildung 1. Namen erstellen<\/figcaption><\/figure>\n<\/div>\n\n\n<p>Legen Sie im Fenster \u201eNeuer Name\u201c den Namen, den Bereich, die Beschreibung und das Referenzziel fest.<\/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>Figur 2. Name einsetzen<\/figcaption><\/figure>\n<\/div>\n\n\n<p>Hier bedeutet \u201eBereich\u201c den Bereich, der auf den Namen verweist, und Sie k\u00f6nnen einen der beiden ausw\u00e4hlen.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Blatt (z. B. Blatt1): kann nur namentlich im auf diesem Blatt geschriebenen VBA-Code referenziert werden<\/li><li>Arbeitsmappe: Vollst\u00e4ndiges Blatt, Modul, Klasse usw. k\u00f6nnen namentlich referenziert werden<\/li><\/ul>\n\n\n\n<p>Als Referenz werden die im Blatt definierten Namen beim Kopieren des Blattes zusammenkopiert. Wenn Sie zu diesem Zeitpunkt in mehreren Bl\u00e4ttern auf denselben Namen verweisen m\u00fcssen, stellen Sie ihn auf \u201eBlatt\u201c ein, und wenn Sie nicht auf denselben Namen verweisen m\u00fcssen, stellen Sie ihn auf \u201eArbeitsmappe\u201c ein. Sie k\u00f6nnen das Ergebnis wie folgt \u00fcberpr\u00fcfen.<\/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>Figur 3. Ergebnis der Namensbildung<\/figcaption><\/figure>\n<\/div>\n\n\n<p>Wenn Sie die Zelle ausw\u00e4hlen, in der der Name definiert ist, wird der Name im Namensfeld angezeigt.<\/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>Figur 4. Zeigen Sie den Namen an, wenn Sie einen benannten Bereich ausw\u00e4hlen<\/figcaption><\/figure>\n<\/div>\n\n\n<p>Wenn Sie eine Zelle ausw\u00e4hlen, deren Name nicht definiert ist, wird die absolute Adresse der Zelle im Namensfeld angezeigt.<\/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>Abbildung 5. Bei Auswahl eines unbenannten Bereichs wird die absolute Adresse des Bereichs angezeigt.<\/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. Schreiben Sie den Namensreferenzcode<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Nachdem Sie den Namen definiert haben, schreiben Sie VBA-Code, der sich auf den definierten Namen bezieht. Ein einfaches Beispiel ist:<\/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. Vorteile der Verwendung von Namen<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Wenn die Absolutadresse ge\u00e4ndert wird, kann die mit dem entsprechenden Namen bezeichnete Absolutadresse ge\u00e4ndert werden. Dies ist praktisch, da nicht der gesamte VBA-Quellcode gesucht und ge\u00e4ndert werden muss.<\/p>\n\n\n\n<p>Wenn eine Spalte oder Zeile hinzugef\u00fcgt oder gel\u00f6scht wird, wird die absolute Adresse, auf die sich der Name bezieht, automatisch ge\u00e4ndert. Wenn sich beispielsweise ein Name auf die Zelle \u201eB2\u201c bezieht, wird durch Hinzuf\u00fcgen einer Zeile zwischen den Zeilen 1 und 2 automatisch \u201eB3\u201c angezeigt.<\/p>\n\n\n\n<p>Verbessert die Lesbarkeit beim Lesen von VBA-Code. Um herauszufinden, was \u201eB2\u201c im Quellcode bedeutet, m\u00fcssen Sie das Blatt \u00f6ffnen und es sich ansehen, aber wenn Sie Namen wie \u201eBaseRange\u201c, \u201eTableListBase\u201c, \u201eColumnListBase\u201c, \u201eValueListBase\u201c usw. verwenden, ist dies der Fall macht es viel einfacher<\/p>\n\n\n\n<p>zus\u00e4tzliche 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\">Verwenden Sie den Excel-Namensmanager (microsoft.com)<\/a> kann gefunden werden in<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity is-style-dots\"\/>\n\n\n\n<p>Oben haben wir uns die Methode und die Vorteile der Verwendung eines Namens f\u00fcr einen Bereich angesehen. Ich hoffe, es hilft Ihnen bei der VBA-Codierung, und wenn Sie Fragen haben, hinterlassen Sie bitte einen Kommentar.<\/p>","protected":false},"excerpt":{"rendered":"<p>Selbst wenn die Referenzadresse von Range w\u00e4hrend der VBA-Codierung ge\u00e4ndert wird, k\u00f6nnen Sie bei Verwendung von Named Range (benannter Bereich) verhindern, dass sich der Quellcode unabh\u00e4ngig von der \u00c4nderung der Referenzadresse \u00e4ndert. Schauen wir uns das Folgende an. 1. Bereichsreferenz mit absoluter Adresse Die am h\u00e4ufigsten verwendete Methode unter vielen Methoden, um auf einen Bereich in Excel VBA zu verweisen, ist wie folgt. In Reichweite (\u201eB2\u201c)...<\/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\/de\/excel-vba-coding-pattern-named-range\/\" \/>\n<meta property=\"og:locale\" content=\"de_DE\" \/>\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\/de\/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=\"Verfasst von\" \/>\n\t<meta name=\"twitter:data1\" content=\"Zerom\" \/>\n\t<meta name=\"twitter:label2\" content=\"Gesch\u00e4tzte Lesezeit\" \/>\n\t<meta name=\"twitter:data2\" content=\"4\u00a0Minuten\" \/>\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\":\"de\",\"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\":\"de\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/prodskill.com\\\/excel-vba-coding-pattern-named-range\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@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\":\"de\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#\\\/schema\\\/person\\\/bbad0870c78008c82edbe0960fe768bd\",\"name\":\"Zerom\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@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\\\/de\\\/author\\\/proda\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"VBA-Codierungsmuster: Benannter Bereich \u2013 Produktivit\u00e4tskompetenz","description":"Beim Programmieren in VBA stellt die Verwendung eines benannten Bereichs sicher, dass Ihr Quellcode unver\u00e4ndert bleibt, unabh\u00e4ngig von \u00c4nderungen an der Referenzadresse. Erstellen Sie einfach einen Namen und schreiben Sie Ihren Code unter Verwendung der benannten Referenz.","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\/de\/excel-vba-coding-pattern-named-range\/","og_locale":"de_DE","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\/de\/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":{"Verfasst von":"Zerom","Gesch\u00e4tzte Lesezeit":"4\u00a0Minuten"},"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":"de","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-Codierungsmuster: Benannter Bereich \u2013 Produktivit\u00e4tskompetenz","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":"Beim Programmieren in VBA stellt die Verwendung eines benannten Bereichs sicher, dass Ihr Quellcode unver\u00e4ndert bleibt, unabh\u00e4ngig von \u00c4nderungen an der Referenzadresse. Erstellen Sie einfach einen Namen und schreiben Sie Ihren Code unter Verwendung der benannten Referenz.","breadcrumb":{"@id":"https:\/\/prodskill.com\/excel-vba-coding-pattern-named-range\/#breadcrumb"},"inLanguage":"de","potentialAction":[{"@type":"ReadAction","target":["https:\/\/prodskill.com\/excel-vba-coding-pattern-named-range\/"]}]},{"@type":"ImageObject","inLanguage":"de","@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":"Produktivit\u00e4tsf\u00e4higkeiten","description":"Meta-Denken, Meta-Arbeiten","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":"de"},{"@type":["Person","Organization"],"@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd","name":"Nullm","image":{"@type":"ImageObject","inLanguage":"de","@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\/de\/author\/proda\/"}]}},"_links":{"self":[{"href":"https:\/\/prodskill.com\/de\/wp-json\/wp\/v2\/posts\/11620","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prodskill.com\/de\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prodskill.com\/de\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prodskill.com\/de\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prodskill.com\/de\/wp-json\/wp\/v2\/comments?post=11620"}],"version-history":[{"count":0,"href":"https:\/\/prodskill.com\/de\/wp-json\/wp\/v2\/posts\/11620\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prodskill.com\/de\/wp-json\/wp\/v2\/media\/11621"}],"wp:attachment":[{"href":"https:\/\/prodskill.com\/de\/wp-json\/wp\/v2\/media?parent=11620"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prodskill.com\/de\/wp-json\/wp\/v2\/categories?post=11620"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prodskill.com\/de\/wp-json\/wp\/v2\/tags?post=11620"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}