{"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\/en\/excel-vba-lecture-3-object-model\/","title":{"rendered":"Excel VBA Course (3): Excel Object Model"},"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;Table of Contents&gt;&gt;<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewbox=\"0 0 24 24\" version=\"1.2\" baseprofile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1' ><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/prodskill.com\/en\/excel-vba-lecture-3-object-model\/#23_%EC%97%91%EC%85%80_Object_Model\" >2.3. Excel Object Model<\/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\/en\/excel-vba-lecture-3-object-model\/#231_Application\" >2.3.1. Application<\/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\/en\/excel-vba-lecture-3-object-model\/#232_Workbooks\" >2.3.2. Workbooks<\/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\/en\/excel-vba-lecture-3-object-model\/#233_Workbook\" >2.3.3. Workbook<\/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\/en\/excel-vba-lecture-3-object-model\/#234_Worksheets\" >2.3.4. Worksheets<\/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\/en\/excel-vba-lecture-3-object-model\/#235_Worksheet\" >2.3.5. Worksheet<\/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\/en\/excel-vba-lecture-3-object-model\/#236_Range\" >2.3.6. Range<\/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 Object Model<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Excel VBA is a programming language that deals with Excel. More precisely, it is a language that handles Excel&#039;s Object Model. You need to know how Excel is structured to be able to handle it well.<\/p>\n\n\n\n<p>If you understand just one picture below, you can understand all the most important and frequently used concepts in the Excel Object Model.<\/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>Excel Object Model essential concepts<\/figcaption><\/figure>\n<\/div>\n\n\n<p>The Excel in the figure above is the 2010 version. I think it is more suitable for understanding the Excel Object Model concept, so I explain it with the Excel 2010 version. Regardless of the version of Excel, the Object Model concept is the same.<\/p>\n\n\n\n<p>This single figure contains all the essential concepts of the Excel Object Model. Let&#039;s look at the concept and details of each object.<\/p>\n\n\n\n<p>For reference, if you execute \u201cView &gt; Browse Objects\u201d in the VBA editor, you can check the detailed properties, functions, procedures (subs), and events of each object.<\/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>object browse menu<\/figcaption><\/figure>\n<\/div>\n\n\n<p>(The VBA editor can be accessed by clicking the \u201cVisual Basic\u201d button on the developer tool ribbon menu, or by using a shortcut key.)&nbsp;<strong>Alt<\/strong>&nbsp;+&nbsp;<strong>F11<\/strong>&nbsp;appears when you press .)<\/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. Application<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>Application refers to the Excel process. Use the Application object to control or terminate the running Excel.<\/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>Browse Objects: Application<\/figcaption><\/figure>\n<\/div>\n\n\n<p>More information on the Application object can be found in the Microsoft article below.<\/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\">Application object (Excel) | Microsoft Docs<\/a><\/p>\n\n\n\n<p>Example code using the Application object is as follows.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"visualbasic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-auto-translation=\"\">'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. Workbooks<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>Manages a collection of files open in a single Excel process. It is used for purposes such as creating a new file, opening or closing a file. When accessing a specific file from the file list, Workbooks(1), Workbooks(2), \u2026 , can be accessed with Workbooks(n).<\/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>Browse Objects: Workbooks<\/figcaption><\/figure>\n<\/div>\n\n\n<p>More information on the Workbooks object can be found in the Microsoft article below.<\/p>\n\n\n\n<p><a href=\"https:\/\/docs.microsoft.com\/en-us\/office\/vba\/api\/excel.workbooks\" target=\"_blank\" rel=\"noreferrer noopener\">Workbooks object (Excel) | Microsoft Docs<\/a><\/p>\n\n\n\n<p>Example code using the Workbooks object is as follows.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"visualbasic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-auto-translation=\"\">'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. Workbook<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>Indicates one specific file among the list of files open in one Excel process. Used for closing or saving files.<\/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>Browse Objects: Workbook<\/figcaption><\/figure>\n<\/div>\n\n\n<p>More information on the Workbook object can be found in the Microsoft article below.<\/p>\n\n\n\n<p><a href=\"https:\/\/docs.microsoft.com\/en-us\/office\/vba\/api\/excel.workbook\" target=\"_blank\" rel=\"noreferrer noopener\">Workbook object (Excel) | Microsoft Docs<\/a><\/p>\n\n\n\n<p>Example code using the Workbook object is as follows.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"visualbasic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-auto-translation=\"\">'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. Worksheets<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>Manages a collection of sheets in a file. It is used for purposes such as creating or deleting a new sheet.<\/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>Browse Objects: Worksheets<\/figcaption><\/figure>\n<\/div>\n\n\n<p>More information on the Worksheets object can be found in the Microsoft article below.<\/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 object (Excel) | Microsoft Docs<\/a><\/p>\n\n\n\n<p>Example code using the Worksheets object is as follows.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"visualbasic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-auto-translation=\"\">'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. Worksheet<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>Points to a single sheet within a file. Used for activating, deleting, hiding, or showing sheets.<\/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>Browse Objects: Worksheet<\/figcaption><\/figure>\n<\/div>\n\n\n<p>More information on the Worksheet object can be found in the Microsoft article below.<\/p>\n\n\n\n<p><a href=\"https:\/\/docs.microsoft.com\/en-us\/office\/vba\/api\/excel.worksheet\" target=\"_blank\" rel=\"noreferrer noopener\">Worksheet object (Excel) | Microsoft Docs<\/a><\/p>\n\n\n\n<p>Example code using the Worksheet object is as follows.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"visualbasic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-auto-translation=\"\">'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. Range<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>It refers to one cell or several cells in one sheet. It is used to enter a value in a cell, delete it, or merge cells. It is the most used object when coding with 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>Browse Objects: Range<\/figcaption><\/figure>\n<\/div>\n\n\n<p>More information about the Range object can be found in the Microsoft article below.<\/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\">Range object (Excel) | Microsoft Docs<\/a><\/p>\n\n\n\n<p>Example code using the Range object is as follows:<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"visualbasic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-auto-translation=\"\">'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>A brief summary of the hierarchical structure, concept, and purpose of the Excel Object Model examined so far is as follows.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-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>Excel Object Model Hierarchy<\/figcaption><\/figure>\n<\/div>\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity is-style-dots\"\/>\n\n\n\n<p>Above, we briefly looked at the Excel Object Model. If you take a closer look with the object search function, you can see that all functions, properties, and events of Excel that can be executed with the mouse and keyboard are provided as an object model. Therefore, you must have a good understanding of Excel functions and use them well to make good use of the Excel Object Model. This means that you can use Excel VBA as much as you use Excel.<\/p>\n\n\n\n<p>Next, we will look at example codes that use objects of the Excel Object Model, and explain the Excel Object Model in more detail.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p><strong>&lt;&lt; Related article list &gt;&gt;<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/prodskill.com\/en\/excel-vba-lecture-preface\/\">Start the Excel VBA course. (Lecture notice, feat. Why we recommend Excel VBA)<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/en\/excel-vba-lecture-1-overview\/\">Excel VBA Course(1): Overview of Excel VBA<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/en\/excel-vba-lecture-2-basic\/\">Excel VBA Course (2): Excel VBA Basics<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/en\/excel-vba-lecture-3-object-model\/\">Excel VBA Course (3): Excel Object Model<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/en\/excel-vba-lecture-4-handling-object-model\/\">Excel VBA Course (4): Working with Excel Object Model<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/en\/excel-vba-lecture-5-excel-file-extension-vbe-font\/\">Excel VBA Course (5): Excel File Extension, VBE, Font Settings<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/en\/excel-vba-lecture-6-variable\/\">Excel VBA Course (6): Excel VBA Language Basics - Variables<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/en\/excel-vba-lecture-7-syntax\/\">Excel VBA Course (7): Excel VBA Language Basics - Syntax<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/en\/excel-vba-lecture-8-datatype\/\">Excel VBA Course (8): Excel VBA Language Basics - Data Types, Data Structures<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/en\/excel-vba-lecture-9-how-to\/\">Excel VBA Courses (9): Excel VBA How-To<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/en\/excel-vba-lecture-10-self-developed-tools\/\">Excel VBA Course (10): Tools developed and used with Excel VBA<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/en\/excel-vba-lecture-toc\/\">Full Table of Contents for Excel VBA Courses<\/a><\/li><\/ul>","protected":false},"excerpt":{"rendered":"<p>2.3. Excel Object Model Excel VBA is a programming language that handles Excel. More precisely, it is a language that handles Excel&#039;s Object Model. You need to know how Excel is structured to be able to handle it well. If you understand just one picture below, the most important and frequently used in Excel Object Model...<\/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.2 - 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\/en\/excel-vba-lecture-3-object-model\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\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\/en\/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=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Zerom\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\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\":\"en-US\",\"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\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/prodskill.com\/excel-vba-lecture-3-object-model\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@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\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd\",\"name\":\"Zerom\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/productivity_clockgear.png\",\"url\":\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/productivity_clockgear.png\",\"contentUrl\":\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/productivity_clockgear.png\",\"width\":512,\"height\":512,\"caption\":\"Zerom\"},\"logo\":{\"@id\":\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/productivity_clockgear.png\"},\"url\":\"https:\/\/prodskill.com\/en\/author\/proda\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel VBA Tutorial (3): Excel Object Model - Productivity Skill","description":"We will look at the entire hierarchy, concepts, and example code for the core objects of the Excel Object Model: Application, Workbooks, Workbook, Worksheets, Worksheet, and Range.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/prodskill.com\/en\/excel-vba-lecture-3-object-model\/","og_locale":"en_US","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\/en\/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":{"Written by":"Zerom","Est. reading time":"7 minutes"},"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":"en-US","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 Object Model - Productivity 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":"We will look at the entire hierarchy, concepts, and example code for the core objects of the Excel Object Model: Application, Workbooks, Workbook, Worksheets, Worksheet, and Range.","breadcrumb":{"@id":"https:\/\/prodskill.com\/excel-vba-lecture-3-object-model\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/prodskill.com\/excel-vba-lecture-3-object-model\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@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":"Productivity Skills","description":"Meta Thinking, Meta Working","publisher":{"@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/prodskill.com\/ko\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd","name":"Zerom","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/productivity_clockgear.png","url":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/productivity_clockgear.png","contentUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/productivity_clockgear.png","width":512,"height":512,"caption":"Zerom"},"logo":{"@id":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/productivity_clockgear.png"},"url":"https:\/\/prodskill.com\/en\/author\/proda\/"}]}},"_links":{"self":[{"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/posts\/11331","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/comments?post=11331"}],"version-history":[{"count":0,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/posts\/11331\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/media\/11334"}],"wp:attachment":[{"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/media?parent=11331"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/categories?post=11331"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/tags?post=11331"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}