{"id":11331,"date":"2022-09-11T12:13:21","date_gmt":"2022-09-11T03:13:21","guid":{"rendered":"https:\/\/prodskill.com\/?p=11331"},"modified":"2022-10-11T11:40:02","modified_gmt":"2022-10-11T02:40:02","slug":"excel-vba-lecture-3-object-model","status":"publish","type":"post","link":"https:\/\/prodskill.com\/de\/excel-vba-lecture-3-object-model\/","title":{"rendered":"Excel VBA-Kurs (3): Excel-Objektmodell"},"content":{"rendered":"<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-3'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/prodskill.com\/de\/excel-vba-lecture-3-object-model\/#23_%EC%97%91%EC%85%80_Object_Model\" >2.3. Excel-Objektmodell<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/prodskill.com\/de\/excel-vba-lecture-3-object-model\/#231_Application\" >2.3.1. Anwendung<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/prodskill.com\/de\/excel-vba-lecture-3-object-model\/#232_Workbooks\" >2.3.2. Arbeitsb\u00fccher<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/prodskill.com\/de\/excel-vba-lecture-3-object-model\/#233_Workbook\" >2.3.3. Arbeitsmappe<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/prodskill.com\/de\/excel-vba-lecture-3-object-model\/#234_Worksheets\" >2.3.4. Arbeitsbl\u00e4tter<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/prodskill.com\/de\/excel-vba-lecture-3-object-model\/#235_Worksheet\" >2.3.5. Arbeitsblatt<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/prodskill.com\/de\/excel-vba-lecture-3-object-model\/#236_Range\" >2.3.6. Reichweite<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h3 class=\"wp-block-heading\" id=\"2.3._\uc5d1\uc140_Object_Model\"><span class=\"ez-toc-section\" id=\"23_%EC%97%91%EC%85%80_Object_Model\"><\/span>2.3. Excel-Objektmodell<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Excel VBA ist eine Programmiersprache, die sich mit Excel befasst. Genauer gesagt handelt es sich um eine Sprache, die das Objektmodell von Excel verarbeitet. Sie m\u00fcssen wissen, wie Excel aufgebaut ist, um damit gut umgehen zu k\u00f6nnen.<\/p>\n\n\n\n<p>Wenn Sie nur ein Bild unten verstehen, k\u00f6nnen Sie alle wichtigsten und am h\u00e4ufigsten verwendeten Konzepte im Excel-Objektmodell verstehen.<\/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-66.png\"><img loading=\"lazy\" decoding=\"async\" width=\"976\" height=\"567\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-66.png\" alt=\"\uc5d1\uc140 Object Model \ud544\uc218 \uac1c\ub150\" class=\"wp-image-11334\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-66.png 976w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-66-300x174.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-66-768x446.png 768w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-66-18x10.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-66-24x14.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-66-36x21.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-66-48x28.png 48w\" sizes=\"auto, (max-width: 976px) 100vw, 976px\" \/><\/a><figcaption>Grundlegende Konzepte des Excel-Objektmodells<\/figcaption><\/figure>\n<\/div>\n\n\n<p>Das Excel in der obigen Abbildung ist die Version 2010. Ich denke, es ist besser geeignet, um das Konzept des Excel-Objektmodells zu verstehen, also erkl\u00e4re ich es mit der Excel 2010-Version. Unabh\u00e4ngig von der Version von Excel ist das Konzept des Objektmodells dasselbe.<\/p>\n\n\n\n<p>Diese einzelne Abbildung enth\u00e4lt alle wesentlichen Konzepte des Excel-Objektmodells. Schauen wir uns das Konzept und die Details der einzelnen Objekte an.<\/p>\n\n\n\n<p>Als Referenz: Wenn Sie im VBA-Editor \u201eAnsicht &gt; Objekte durchsuchen\u201c ausf\u00fchren, k\u00f6nnen Sie die detaillierten Eigenschaften, Funktionen, Prozeduren (Subs) und Ereignisse jedes Objekts \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-67.png\"><img loading=\"lazy\" decoding=\"async\" width=\"695\" height=\"431\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-67.png\" alt=\"\uac1c\uccb4 \ucc3e\uc544\ubcf4\uae30 \uba54\ub274\" class=\"wp-image-11335\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-67.png 695w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-67-300x186.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-67-18x12.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-67-24x15.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-67-36x22.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-67-48x30.png 48w\" sizes=\"auto, (max-width: 695px) 100vw, 695px\" \/><\/a><figcaption>Men\u00fc zum Durchsuchen von Objekten<\/figcaption><\/figure>\n<\/div>\n\n\n<p>(Auf den VBA-Editor kann zugegriffen werden, indem Sie auf die Schaltfl\u00e4che \u201eVisual Basic\u201c im Ribbon-Men\u00fc des Entwicklertools klicken oder eine Tastenkombination verwenden.)&nbsp;<strong>Alt<\/strong>&nbsp;+&nbsp;<strong>F11<\/strong>&nbsp;erscheint, wenn Sie dr\u00fccken.)<\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"2.3.1._Application\"><span class=\"ez-toc-section\" id=\"231_Application\"><\/span>2.3.1. Anwendung<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>Anwendung bezieht sich auf das Excel-Verfahren. Verwenden Sie das Anwendungsobjekt, um das laufende Excel zu steuern oder zu beenden.<\/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-68.png\"><img loading=\"lazy\" decoding=\"async\" width=\"609\" height=\"429\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-68.png\" alt=\"\uac1c\uccb4 \ucc3e\uc544\ubcf4\uae30: Application\" class=\"wp-image-11336\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-68.png 609w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-68-300x211.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-68-18x12.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-68-24x17.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-68-36x25.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-68-48x34.png 48w\" sizes=\"auto, (max-width: 609px) 100vw, 609px\" \/><\/a><figcaption>Objekte durchsuchen: Anwendung<\/figcaption><\/figure>\n<\/div>\n\n\n<p>Weitere Informationen zum Anwendungsobjekt finden Sie im folgenden Microsoft-Artikel.<\/p>\n\n\n\n<p><a href=\"https:\/\/docs.microsoft.com\/en-us\/office\/vba\/api\/excel.application(object)\" target=\"_blank\" rel=\"noreferrer noopener\">Anwendungsobjekt (Excel) | Microsoft-Docs<\/a><\/p>\n\n\n\n<p>Beispielcode, der das Application-Objekt verwendet, lautet 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=\"\">'Application \uc0ac\uc6a9 \ucf54\ub4dc #1: \ud30c\uc77c \ud65c\uc131\ud654 \ud558\uae30\nApplication.Windows(\"book1.xls\").Activate\n\n'Application \uc0ac\uc6a9 \ucf54\ub4dc #2: \uc5d1\uc140 \uc885\ub8cc\ud558\uae30\nApplication.Quit()<\/pre>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"2.3.2._Workbooks\"><span class=\"ez-toc-section\" id=\"232_Workbooks\"><\/span>2.3.2. Arbeitsb\u00fccher<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>Verwaltet eine Sammlung von Dateien, die in einem einzigen Excel-Prozess ge\u00f6ffnet sind. Es wird f\u00fcr Zwecke wie das Erstellen einer neuen Datei, das \u00d6ffnen oder Schlie\u00dfen einer Datei verwendet. Beim Zugriff auf eine bestimmte Datei aus der Dateiliste, Workbooks(1), Workbooks(2), \u2026 , kann mit Workbooks(n) aufgerufen werden.<\/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-69.png\"><img loading=\"lazy\" decoding=\"async\" width=\"609\" height=\"429\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-69.png\" alt=\"\uac1c\uccb4 \ucc3e\uc544\ubcf4\uae30: Workbooks\" class=\"wp-image-11337\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-69.png 609w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-69-300x211.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-69-18x12.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-69-24x17.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-69-36x25.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-69-48x34.png 48w\" sizes=\"auto, (max-width: 609px) 100vw, 609px\" \/><\/a><figcaption>Objekte durchsuchen: Arbeitsmappen<\/figcaption><\/figure>\n<\/div>\n\n\n<p>Weitere Informationen zum Workbooks-Objekt finden Sie im folgenden Microsoft-Artikel.<\/p>\n\n\n\n<p><a href=\"https:\/\/docs.microsoft.com\/en-us\/office\/vba\/api\/excel.workbooks\" target=\"_blank\" rel=\"noreferrer noopener\">Arbeitsmappenobjekt (Excel) | Microsoft-Docs<\/a><\/p>\n\n\n\n<p>Beispielcode, der das Workbooks-Objekt verwendet, lautet 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=\"\">'Workbooks \uc0ac\uc6a9 \ucf54\ub4dc #1: \ubaa8\ub4e0 \ud30c\uc77c \ub2eb\uae30\nWorkbooks.Close\n\n'Workbooks \uc0ac\uc6a9 \ucf54\ub4dc #2: \uc0c8\ub85c\uc6b4 \ud30c\uc77c \uc0dd\uc131\ud558\uae30\nWorkbooks.Add\n\n'Workbooks \uc0ac\uc6a9 \ucf54\ub4dc #3: \ud30c\uc77c \uc5f4\uae30\nWorkbooks.Open FileName:=\"File.xlsx\", ReadOnly:=True<\/pre>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"2.3.3._Workbook\"><span class=\"ez-toc-section\" id=\"233_Workbook\"><\/span>2.3.3. Arbeitsmappe<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>Zeigt eine bestimmte Datei in der Liste der Dateien an, die in einem Excel-Prozess ge\u00f6ffnet sind. Wird zum Schlie\u00dfen oder Speichern von Dateien verwendet.<\/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-70.png\"><img loading=\"lazy\" decoding=\"async\" width=\"609\" height=\"429\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-70.png\" alt=\"\uac1c\uccb4 \ucc3e\uc544\ubcf4\uae30: Workbook\" class=\"wp-image-11338\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-70.png 609w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-70-300x211.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-70-18x12.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-70-24x17.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-70-36x25.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-70-48x34.png 48w\" sizes=\"auto, (max-width: 609px) 100vw, 609px\" \/><\/a><figcaption>Objekte durchsuchen: Arbeitsmappe<\/figcaption><\/figure>\n<\/div>\n\n\n<p>Weitere Informationen zum Workbook-Objekt finden Sie im folgenden Microsoft-Artikel.<\/p>\n\n\n\n<p><a href=\"https:\/\/docs.microsoft.com\/en-us\/office\/vba\/api\/excel.workbook\" target=\"_blank\" rel=\"noreferrer noopener\">Arbeitsmappenobjekt (Excel) | Microsoft-Docs<\/a><\/p>\n\n\n\n<p>Beispielcode, der das Workbook-Objekt verwendet, lautet 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=\"\">'Workbook \uc0ac\uc6a9 \ucf54\ub4dc #1: \ud30c\uc77c \ub2eb\uae30\nWorkbook.Close\n\n'Workbooks \uc0ac\uc6a9 \ucf54\ub4dc #2: \uc800\uc7a5\ud558\uae30\nWorkbook.Save\n\n'Workbooks \uc0ac\uc6a9 \ucf54\ub4dc #3: \ub2e4\ub978 \uc774\ub984\uc73c\ub85c \uc800\uc7a5\ud558\uae30\nWorkbook.SaveAs Filename:=\"NewFile.xlsx\"<\/pre>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"2.3.4._Worksheets\"><span class=\"ez-toc-section\" id=\"234_Worksheets\"><\/span>2.3.4. Arbeitsbl\u00e4tter<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>Verwaltet eine Sammlung von Bl\u00e4ttern in einer Datei. Es wird f\u00fcr Zwecke wie das Erstellen oder L\u00f6schen eines neuen Blatts verwendet.<\/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-71.png\"><img loading=\"lazy\" decoding=\"async\" width=\"609\" height=\"429\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-71.png\" alt=\"\uac1c\uccb4 \ucc3e\uc544\ubcf4\uae30: Worksheets\" class=\"wp-image-11339\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-71.png 609w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-71-300x211.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-71-18x12.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-71-24x17.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-71-36x25.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-71-48x34.png 48w\" sizes=\"auto, (max-width: 609px) 100vw, 609px\" \/><\/a><figcaption>Objekte durchsuchen: Arbeitsbl\u00e4tter<\/figcaption><\/figure>\n<\/div>\n\n\n<p>Weitere Informationen zum Worksheets-Objekt finden Sie im folgenden Microsoft-Artikel.<\/p>\n\n\n\n<p><a href=\"https:\/\/docs.microsoft.com\/en-us\/office\/vba\/api\/excel.worksheets\" target=\"_blank\" rel=\"noreferrer noopener\">Worksheets-Objekt (Excel) | Microsoft-Docs<\/a><\/p>\n\n\n\n<p>Beispielcode, der das Worksheets-Objekt verwendet, lautet 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=\"\">'Worksheets \uc0ac\uc6a9 \ucf54\ub4dc #1: \uccab\ubc88\uc9f8 \uc2dc\ud2b8 \uc55e\uc5d0 2\uac1c \uc2dc\ud2b8 \ucd94\uac00\nWorksheets.Add Count:=2, Before:=Sheets(1)\n\n'Worksheets \uc0ac\uc6a9 \ucf54\ub4dc #2: \uc2dc\ud2b8 \uac1c\uc218 \ucd9c\ub825\nDebug.Print Worksheets.Count\n\n'Worksheets \uc0ac\uc6a9 \ucf54\ub4dc #3: Sheet3 \ub4a4\uc5d0 Sheet1 \ubcf5\uc0ac\nWorksheets(\"Sheet1\").Copy After:=Worksheets(\"Sheet3\")<\/pre>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"2.3.5._Worksheet\"><span class=\"ez-toc-section\" id=\"235_Worksheet\"><\/span>2.3.5. Arbeitsblatt<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>Zeigt auf ein einzelnes Blatt innerhalb einer Datei. Wird zum Aktivieren, L\u00f6schen, Ausblenden oder Anzeigen von Bl\u00e4ttern verwendet.<\/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-72.png\"><img loading=\"lazy\" decoding=\"async\" width=\"609\" height=\"429\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-72.png\" alt=\"\uac1c\uccb4 \ucc3e\uc544\ubcf4\uae30: Worksheet\" class=\"wp-image-11340\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-72.png 609w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-72-300x211.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-72-18x12.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-72-24x17.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-72-36x25.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-72-48x34.png 48w\" sizes=\"auto, (max-width: 609px) 100vw, 609px\" \/><\/a><figcaption>Objekte durchsuchen: Arbeitsblatt<\/figcaption><\/figure>\n<\/div>\n\n\n<p>Weitere Informationen zum Worksheet-Objekt finden Sie im folgenden Microsoft-Artikel.<\/p>\n\n\n\n<p><a href=\"https:\/\/docs.microsoft.com\/en-us\/office\/vba\/api\/excel.worksheet\" target=\"_blank\" rel=\"noreferrer noopener\">Arbeitsblattobjekt (Excel) | Microsoft-Docs<\/a><\/p>\n\n\n\n<p>Beispielcode, der das Worksheet-Objekt verwendet, lautet 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=\"\">'Worksheet \uc0ac\uc6a9 \ucf54\ub4dc #1: \uc2dc\ud2b8 \ud65c\uc131\ud654\nWorksheets(\"Sheet1\").Activate\n\n'Worksheet \uc0ac\uc6a9 \ucf54\ub4dc #2: \uc2dc\ud2b8 \uc0ad\uc81c\nWorksheets(\"Sheet1\").Delete\n\n'Worksheet \uc0ac\uc6a9 \ucf54\ub4dc #3: \uc2dc\ud2b8 \uc228\uae30\uae30\nWorksheets(1).Visible = False\n\n'Worksheet \uc0ac\uc6a9 \ucf54\ub4dc #4: \uc2dc\ud2b8 \ubcf4\uc774\uae30\nWorksheets(1).Visible = True<\/pre>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"2.3.6._Range\"><span class=\"ez-toc-section\" id=\"236_Range\"><\/span>2.3.6. Reichweite<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>Es bezieht sich auf eine Zelle oder mehrere Zellen in einem Blatt. Es wird verwendet, um einen Wert in eine Zelle einzugeben, ihn zu l\u00f6schen oder Zellen zu verbinden. Es ist das am h\u00e4ufigsten verwendete Objekt beim Codieren mit Excel VBA.<\/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-73.png\"><img loading=\"lazy\" decoding=\"async\" width=\"609\" height=\"429\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-73.png\" alt=\"\uac1c\uccb4 \ucc3e\uc544\ubcf4\uae30: Range\" class=\"wp-image-11341\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-73.png 609w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-73-300x211.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-73-18x12.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-73-24x17.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-73-36x25.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-73-48x34.png 48w\" sizes=\"auto, (max-width: 609px) 100vw, 609px\" \/><\/a><figcaption>Objekte durchsuchen: Bereich<\/figcaption><\/figure>\n<\/div>\n\n\n<p>Weitere Informationen zum Range-Objekt finden Sie im folgenden Microsoft-Artikel.<\/p>\n\n\n\n<p><a href=\"https:\/\/docs.microsoft.com\/en-us\/office\/vba\/api\/excel.range(object)\" target=\"_blank\" rel=\"noreferrer noopener\">Bereichsobjekt (Excel) | Microsoft-Docs<\/a><\/p>\n\n\n\n<p>Beispielcode, der das Range-Objekt verwendet, lautet 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=\"\">'Range \uc0ac\uc6a9 \ucf54\ub4dc #1: A1 cell\uc758 \uac12\uc744 A5\uc5d0 \uc785\ub825\nWorksheets(\"Sheet1\").Range(\"A5\").Value = _ \n\u200b\u200b\u200b\u200bWorksheets(\"Sheet1\").Range(\"A1\").Value\n\n'Range \uc0ac\uc6a9 \ucf54\ub4dc #2: A1:E10 \uc601\uc5ed\uc758 \ub0b4\uc6a9 \uc0ad\uc81c\nWorksheets(1).Range(\"A1:E10\").ClearContents\n\n'Range \uc0ac\uc6a9 \ucf54\ub4dc #3: A2(2\ud589, 1\uc5f4)\uc5d0 B1:B5 \ud569\uacc4 \uc218\uc2dd \uc785\ub825\nWorksheets(1).Range(\"A2\").Formula = \"=Sum(B1:B5)\"\nWorksheets(1).Cells(2, 1).Formula = \"=Sum(B1:B5)\"\n\n'Range \uc0ac\uc6a9 \ucf54\ub4dc #4: 5\ud589 \uc0ad\uc81c\ud558\uae30\nWorksheets(1).Rows(5).Delete\n\n'Range \uc0ac\uc6a9 \ucf54\ub4dc #5: 3\uc5f4(C) \uc0ad\uc81c\ud558\uae30\nWorksheets(1).Columns(\"C\").Delete\nWorksheets(1).Columns(3).Delete\n\n'Range \uc0ac\uc6a9 \ucf54\ub4dc #6: A1:A2 cell \ubcd1\ud569\nWorksheets(1).Range(\"A1:A2\").Merge<\/pre>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>Eine kurze Zusammenfassung der hierarchischen Struktur, des Konzepts und des Zwecks des bisher untersuchten Excel-Objektmodells lautet wie folgt.<\/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-74.png\"><img loading=\"lazy\" decoding=\"async\" width=\"958\" height=\"557\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-74.png\" alt=\"\uc5d1\uc140 Object Model \uacc4\uce35 \uad6c\uc870\" class=\"wp-image-11342\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-74.png 958w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-74-300x174.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-74-768x447.png 768w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-74-18x10.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-74-24x14.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-74-36x21.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-74-48x28.png 48w\" sizes=\"auto, (max-width: 958px) 100vw, 958px\" \/><\/a><figcaption>Hierarchie des Excel-Objektmodells<\/figcaption><\/figure>\n<\/div>\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity is-style-dots\"\/>\n\n\n\n<p>Oben haben wir uns kurz das Excel-Objektmodell angesehen. Schaut man sich die Objektsuche genauer an, erkennt man, dass alle per Maus und Tastatur ausf\u00fchrbaren Funktionen, Eigenschaften und Ereignisse von Excel als Objektmodell bereitgestellt werden. Daher m\u00fcssen Sie die Excel-Funktionen gut verstehen und sie gut einsetzen, um das Excel-Objektmodell sinnvoll nutzen zu k\u00f6nnen. Das bedeutet, dass Sie Excel VBA genauso verwenden k\u00f6nnen wie Excel.<\/p>\n\n\n\n<p>Als N\u00e4chstes sehen wir uns Beispielcodes an, die Objekte des Excel-Objektmodells verwenden, und erl\u00e4utern das Excel-Objektmodell ausf\u00fchrlicher.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p><strong>&lt;&lt;Verwandte Artikelliste &gt;&gt;<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/prodskill.com\/de\/excel-vba-lecture-preface\/\">Starten Sie den Excel-VBA-Kurs. (Vorlesungsank\u00fcndigung, feat. Warum wir Excel VBA empfehlen)<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/de\/excel-vba-lecture-1-overview\/\">Excel VBA-Kurs(1): \u00dcberblick \u00fcber Excel VBA<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/de\/excel-vba-lecture-2-basic\/\">Excel VBA-Kurs (2): Excel VBA-Grundlagen<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/de\/excel-vba-lecture-3-object-model\/\">Excel VBA-Kurs (3): Excel-Objektmodell<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/de\/excel-vba-lecture-4-handling-object-model\/\">Excel VBA-Kurs (4): Arbeiten mit dem Excel-Objektmodell<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/de\/excel-vba-lecture-5-excel-file-extension-vbe-font\/\">Excel VBA-Kurs (5): Excel-Dateierweiterung, VBE, Schrifteinstellungen<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/de\/excel-vba-lecture-6-variable\/\">Excel VBA-Kurs (6): Grundlagen der Excel VBA-Sprache \u2013 Variablen<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/de\/excel-vba-lecture-7-syntax\/\">Excel VBA-Kurs (7): Grundlagen der Excel VBA-Sprache \u2013 Syntax<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/de\/excel-vba-lecture-8-datatype\/\">Excel VBA-Kurs (8): Grundlagen der Excel VBA-Sprache \u2013 Datentypen, Datenstrukturen<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/de\/excel-vba-lecture-9-how-to\/\">Excel VBA-Kurse (9): Excel VBA How-To<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/de\/excel-vba-lecture-10-self-developed-tools\/\">Excel VBA-Kurs (10): Tools, die mit Excel VBA entwickelt und verwendet werden<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/de\/excel-vba-lecture-toc\/\">Vollst\u00e4ndiges Inhaltsverzeichnis f\u00fcr Excel VBA-Kurse<\/a><\/li><\/ul>","protected":false},"excerpt":{"rendered":"<p>2.3. Excel-Objektmodell Excel VBA ist eine Programmiersprache, die Excel manipuliert. Genauer gesagt handelt es sich um eine Sprache, die das Objektmodell von Excel verarbeitet. Sie m\u00fcssen wissen, wie Excel aufgebaut ist, um es gut nutzen zu k\u00f6nnen. Wenn Sie nur ein Bild unten verstehen, k\u00f6nnen Sie die wichtigsten und am h\u00e4ufigsten verwendeten Teile des Excel-Objektmodells sehen ...<\/p>","protected":false},"author":1,"featured_media":11334,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28],"tags":[17],"class_list":["post-11331","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-vba-tutorial","tag-vba"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>\uc5d1\uc140 VBA \uac15\uc88c(3): \uc5d1\uc140 Object Model - \uc0dd\uc0b0\uc131 Skill<\/title>\n<meta name=\"description\" content=\"\uc5d1\uc140 Object Model \uc911 \ud575\uc2ec \uac1c\uccb4\uc778 Application, Workbooks, Workbook, Worksheets, Worksheet, Range\uc5d0 \ub300\ud574 \uc804\uccb4 \uacc4\uce35\uad6c\uc870\uc640 \uac1c\ub150, \uc608\uc81c \ucf54\ub4dc\ub97c \uc0b4\ud3b4\ubcf8\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-lecture-3-object-model\/\" \/>\n<meta property=\"og:locale\" content=\"de_DE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\uc5d1\uc140 VBA \uac15\uc88c(3): \uc5d1\uc140 Object Model - \uc0dd\uc0b0\uc131 Skill\" \/>\n<meta property=\"og:description\" content=\"\uc5d1\uc140 Object Model \uc911 \ud575\uc2ec \uac1c\uccb4\uc778 Application, Workbooks, Workbook, Worksheets, Worksheet, Range\uc5d0 \ub300\ud574 \uc804\uccb4 \uacc4\uce35\uad6c\uc870\uc640 \uac1c\ub150, \uc608\uc81c \ucf54\ub4dc\ub97c \uc0b4\ud3b4\ubcf8\ub2e4.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/prodskill.com\/de\/excel-vba-lecture-3-object-model\/\" \/>\n<meta property=\"og:site_name\" content=\"\uc0dd\uc0b0\uc131 Skill\" \/>\n<meta property=\"article:published_time\" content=\"2022-09-11T03:13:21+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-10-11T02:40:02+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-66.png\" \/>\n\t<meta property=\"og:image:width\" content=\"976\" \/>\n\t<meta property=\"og:image:height\" content=\"567\" \/>\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=\"7\u00a0Minuten\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-lecture-3-object-model\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-lecture-3-object-model\\\/\"},\"author\":{\"name\":\"Zerom\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#\\\/schema\\\/person\\\/bbad0870c78008c82edbe0960fe768bd\"},\"headline\":\"\uc5d1\uc140 VBA \uac15\uc88c(3): \uc5d1\uc140 Object Model\",\"datePublished\":\"2022-09-11T03:13:21+00:00\",\"dateModified\":\"2022-10-11T02:40:02+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-lecture-3-object-model\\\/\"},\"wordCount\":169,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#\\\/schema\\\/person\\\/bbad0870c78008c82edbe0960fe768bd\"},\"image\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-lecture-3-object-model\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/image-66.png\",\"keywords\":[\"\uc5d1\uc140VBA\"],\"articleSection\":[\"\uc5d1\uc140 VBA \uac15\uc88c\"],\"inLanguage\":\"de\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/prodskill.com\\\/excel-vba-lecture-3-object-model\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-lecture-3-object-model\\\/\",\"url\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-lecture-3-object-model\\\/\",\"name\":\"\uc5d1\uc140 VBA \uac15\uc88c(3): \uc5d1\uc140 Object Model - \uc0dd\uc0b0\uc131 Skill\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-lecture-3-object-model\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-lecture-3-object-model\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/image-66.png\",\"datePublished\":\"2022-09-11T03:13:21+00:00\",\"dateModified\":\"2022-10-11T02:40:02+00:00\",\"description\":\"\uc5d1\uc140 Object Model \uc911 \ud575\uc2ec \uac1c\uccb4\uc778 Application, Workbooks, Workbook, Worksheets, Worksheet, Range\uc5d0 \ub300\ud574 \uc804\uccb4 \uacc4\uce35\uad6c\uc870\uc640 \uac1c\ub150, \uc608\uc81c \ucf54\ub4dc\ub97c \uc0b4\ud3b4\ubcf8\ub2e4.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-lecture-3-object-model\\\/#breadcrumb\"},\"inLanguage\":\"de\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/prodskill.com\\\/excel-vba-lecture-3-object-model\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-lecture-3-object-model\\\/#primaryimage\",\"url\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/image-66.png\",\"contentUrl\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/image-66.png\",\"width\":976,\"height\":567},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-lecture-3-object-model\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\uc5d1\uc140 VBA \uac15\uc88c(3): \uc5d1\uc140 Object Model\"}]},{\"@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":"Excel VBA-Tutorial (3): Excel-Objektmodell \u2013 Produktivit\u00e4tskompetenz","description":"Wir werden uns die gesamte Hierarchie, Konzepte und Beispielcodes f\u00fcr die Kernobjekte des Excel-Objektmodells ansehen: Anwendung, Arbeitsmappen, Arbeitsmappe, Arbeitsbl\u00e4tter, Arbeitsblatt und Bereich.","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-lecture-3-object-model\/","og_locale":"de_DE","og_type":"article","og_title":"\uc5d1\uc140 VBA \uac15\uc88c(3): \uc5d1\uc140 Object Model - \uc0dd\uc0b0\uc131 Skill","og_description":"\uc5d1\uc140 Object Model \uc911 \ud575\uc2ec \uac1c\uccb4\uc778 Application, Workbooks, Workbook, Worksheets, Worksheet, Range\uc5d0 \ub300\ud574 \uc804\uccb4 \uacc4\uce35\uad6c\uc870\uc640 \uac1c\ub150, \uc608\uc81c \ucf54\ub4dc\ub97c \uc0b4\ud3b4\ubcf8\ub2e4.","og_url":"https:\/\/prodskill.com\/de\/excel-vba-lecture-3-object-model\/","og_site_name":"\uc0dd\uc0b0\uc131 Skill","article_published_time":"2022-09-11T03:13:21+00:00","article_modified_time":"2022-10-11T02:40:02+00:00","og_image":[{"width":976,"height":567,"url":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-66.png","type":"image\/png"}],"author":"Zerom","twitter_card":"summary_large_image","twitter_misc":{"Verfasst von":"Zerom","Gesch\u00e4tzte Lesezeit":"7\u00a0Minuten"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/prodskill.com\/excel-vba-lecture-3-object-model\/#article","isPartOf":{"@id":"https:\/\/prodskill.com\/excel-vba-lecture-3-object-model\/"},"author":{"name":"Zerom","@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd"},"headline":"\uc5d1\uc140 VBA \uac15\uc88c(3): \uc5d1\uc140 Object Model","datePublished":"2022-09-11T03:13:21+00:00","dateModified":"2022-10-11T02:40:02+00:00","mainEntityOfPage":{"@id":"https:\/\/prodskill.com\/excel-vba-lecture-3-object-model\/"},"wordCount":169,"commentCount":0,"publisher":{"@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd"},"image":{"@id":"https:\/\/prodskill.com\/excel-vba-lecture-3-object-model\/#primaryimage"},"thumbnailUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-66.png","keywords":["\uc5d1\uc140VBA"],"articleSection":["\uc5d1\uc140 VBA \uac15\uc88c"],"inLanguage":"de","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/prodskill.com\/excel-vba-lecture-3-object-model\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/prodskill.com\/excel-vba-lecture-3-object-model\/","url":"https:\/\/prodskill.com\/excel-vba-lecture-3-object-model\/","name":"Excel VBA-Tutorial (3): Excel-Objektmodell \u2013 Produktivit\u00e4tskompetenz","isPartOf":{"@id":"https:\/\/prodskill.com\/ko\/#website"},"primaryImageOfPage":{"@id":"https:\/\/prodskill.com\/excel-vba-lecture-3-object-model\/#primaryimage"},"image":{"@id":"https:\/\/prodskill.com\/excel-vba-lecture-3-object-model\/#primaryimage"},"thumbnailUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-66.png","datePublished":"2022-09-11T03:13:21+00:00","dateModified":"2022-10-11T02:40:02+00:00","description":"Wir werden uns die gesamte Hierarchie, Konzepte und Beispielcodes f\u00fcr die Kernobjekte des Excel-Objektmodells ansehen: Anwendung, Arbeitsmappen, Arbeitsmappe, Arbeitsbl\u00e4tter, Arbeitsblatt und Bereich.","breadcrumb":{"@id":"https:\/\/prodskill.com\/excel-vba-lecture-3-object-model\/#breadcrumb"},"inLanguage":"de","potentialAction":[{"@type":"ReadAction","target":["https:\/\/prodskill.com\/excel-vba-lecture-3-object-model\/"]}]},{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/prodskill.com\/excel-vba-lecture-3-object-model\/#primaryimage","url":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-66.png","contentUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-66.png","width":976,"height":567},{"@type":"BreadcrumbList","@id":"https:\/\/prodskill.com\/excel-vba-lecture-3-object-model\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/prodskill.com\/ko\/"},{"@type":"ListItem","position":2,"name":"\uc5d1\uc140 VBA \uac15\uc88c(3): \uc5d1\uc140 Object Model"}]},{"@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\/11331","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=11331"}],"version-history":[{"count":0,"href":"https:\/\/prodskill.com\/de\/wp-json\/wp\/v2\/posts\/11331\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prodskill.com\/de\/wp-json\/wp\/v2\/media\/11334"}],"wp:attachment":[{"href":"https:\/\/prodskill.com\/de\/wp-json\/wp\/v2\/media?parent=11331"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prodskill.com\/de\/wp-json\/wp\/v2\/categories?post=11331"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prodskill.com\/de\/wp-json\/wp\/v2\/tags?post=11331"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}