{"id":11344,"date":"2022-09-11T12:40:12","date_gmt":"2022-09-11T03:40:12","guid":{"rendered":"https:\/\/prodskill.com\/?p=11344"},"modified":"2022-10-11T11:40:26","modified_gmt":"2022-10-11T02:40:26","slug":"excel-vba-lecture-4-handling-object-model","status":"publish","type":"post","link":"https:\/\/prodskill.com\/en\/excel-vba-lecture-4-handling-object-model\/","title":{"rendered":"Excel VBA Course (4): Working with Excel Object Model"},"content":{"rendered":"<p>In this article, we will look at how to handle the Excel Object Model.<\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">&lt;&lt;Table of Contents&gt;&gt;<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewbox=\"0 0 24 24\" version=\"1.2\" baseprofile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1' ><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/prodskill.com\/en\/excel-vba-lecture-4-handling-object-model\/#24_%EA%B0%84%EB%8B%A8%ED%95%9C_%EC%BD%94%EB%93%9C%EB%A1%9C_%EC%97%91%EC%85%80_Object_Model_%EC%9D%B4%ED%95%B4%ED%95%98%EA%B8%B0\" >2.4. Understanding the Excel Object Model with simple code<\/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-4-handling-object-model\/#241_%EA%B0%9D%EC%B2%B4_%EC%A0%91%EA%B7%BC_%EA%B8%B0%EB%B3%B8%ED%98%95\" >2.4.1. object access primitives<\/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-4-handling-object-model\/#242_%EA%B0%9D%EC%B2%B4_%EC%A0%91%EA%B7%BC_%EB%8B%A8%EC%88%9C%ED%98%95\" >2.4.2. simple object access<\/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-4-handling-object-model\/#243_%EA%B0%9D%EC%B2%B4_%EC%A0%91%EA%B7%BC_%ED%99%9C%EC%9A%A9_%EC%98%88%EC%A0%9C\" >2.4.3. Object Access &amp; Utilization Examples<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/prodskill.com\/en\/excel-vba-lecture-4-handling-object-model\/#25_%EC%97%91%EC%85%80_Object_Model_%EC%83%81%EC%84%B8\" >2.5. Excel Object Model Details<\/a><\/li><\/ul><\/nav><\/div>\n<h3 class=\"wp-block-heading\" id=\"2.4._\uac04\ub2e8\ud55c_\ucf54\ub4dc\ub85c_\uc5d1\uc140_Object_Model_\uc774\ud574\ud558\uae30\"><span class=\"ez-toc-section\" id=\"24_%EA%B0%84%EB%8B%A8%ED%95%9C_%EC%BD%94%EB%93%9C%EB%A1%9C_%EC%97%91%EC%85%80_Object_Model_%EC%9D%B4%ED%95%B4%ED%95%98%EA%B8%B0\"><\/span>2.4. Understanding the Excel Object Model with simple code<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"2.4.1._\uac1d\uccb4_\uc811\uadfc_\uae30\ubcf8\ud615\"><span class=\"ez-toc-section\" id=\"241_%EA%B0%9D%EC%B2%B4_%EC%A0%91%EA%B7%BC_%EA%B8%B0%EB%B3%B8%ED%98%95\"><\/span>2.4.1. object access primitives<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>Let&#039;s look at the most basic code that accesses files, sheets, ranges, and cells. For reference, the global object Application can be omitted when accessing the object. In the second line of each example from 1 to 6 below, the code omitting Application is expressed.<\/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=\"\">'1. \uc774\ub984\uc774 t1.xlsx \uc778 \ud30c\uc77c\nApplication.Workbooks(\"t1.xlsx\")\nWorkbooks(\"t1.xlsx\") \n\n'2. \uc774 \ud30c\uc77c\uc758 Sheet1 \uc2dc\ud2b8\nApplication.Workbooks(\"t1.xlsx\").Worksheets(\"Sheet1\")\nWorkbooks(\"t1.xlsx\").Worksheets(\"Sheet1\")\n\n'3. \uc774 \uc2dc\ud2b8\uc758 A1 cell\nApplication.Workbooks(\"t1.xlsx\").Worksheets(\"Sheet1\").Range(\"A1\")\nWorkbooks(\"t1.xlsx\").Worksheets(\"Sheet1\").Range(\"A1\") \n\n'4. \uc774 \uc2dc\ud2b8\uc758 A1 cell \uc5d0 \"TEST\" \ubb38\uc790\uc5f4 \uc785\ub825\nApplication.Workbooks(\"t1.xlsx\").Worksheets(\"Sheet1\").Range(\"A1\") = \"TEST\"\nWorkbooks(\"t1.xlsx\").Worksheets(\"Sheet1\").Range(\"A1\") = \"TEST\"\n\n'5. \uc774 \uc2dc\ud2b8\uc758 A1 cell \uae00\uaf34\uc744 \uad75\uac8c(Bold) \uc124\uc815\nApplication.Workbooks(\"t1.xlsx\").Worksheets(\"Sheet1\").Range(\"A1\").Font.Bold = True\nWorkbooks(\"t1.xlsx\").Worksheets(\"Sheet1\").Range(\"A1\").Font.Bold = True\n\n'6. \uc774 \uc2dc\ud2b8\uc758 A2:D4 \ubc94\uc704\nApplication.Workbooks(\"t1.xlsx\").Worksheets(\"Sheet1\").Range(\"A2:D4\")\nWorkbooks(\"t1.xlsx\").Worksheets(\"Sheet1\").Range(\"A2:D4\")<\/pre>\n\n\n\n<p>Let&#039;s take a closer look at each one.<\/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=\"\">'1. \uc774\ub984\uc774 t1.xlsx \uc778 \ud30c\uc77c\nApplication.Workbooks(\"t1.xlsx\")\nWorkbooks(\"t1.xlsx\")<\/pre>\n\n\n\n<p>\u25b2 This is a syntax that indicates the file whose name is \u201ct1.xlsx\u201d among the files currently open in Excel. Workbooks maintains a collection of open files. When selecting one of several files, access the &#039;file name&#039; to the Workbooks collection as a parameter. (For reference, in addition to the file name, the order in which the file was opened, such as \u201cWorkbooks(1)\u201d, can also be used as a parameter.)<\/p>\n\n\n\n<p><\/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=\"\">'2. \uc774 \ud30c\uc77c\uc758 Sheet1 \uc2dc\ud2b8\nApplication. Workbooks(\"t1.xlsx\").Worksheets(\"Sheet1\")\nWorkbooks(\"t1.xlsx\").Worksheets(\"Sheet1\")<\/pre>\n\n\n\n<p>\u25b2 This is a syntax that indicates the \u201cSheet1\u201d sheet of the \u201ct1.xlsx\u201d file specified above. Worksheets manage a collection of sheets in a file. When selecting one of several sheets, access the &#039;sheet name&#039; to the Worksheets collection as a parameter. (Like Workbooks, you can also use the order of sheets as a parameter, such as \u201cWorksheets(1)\u201d.)<\/p>\n\n\n\n<p><\/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=\"\">'3. \uc774 \uc2dc\ud2b8\uc758 A1 cell\nApplication.Workbooks(\"t1.xlsx\").Worksheets(\"Sheet1\").Range(\"A1\")\nWorkbooks(\"t1.xlsx\").Worksheets(\"Sheet1\").Range(\"A1\")<\/pre>\n\n\n\n<p>\u25b2 This is a phrase that indicates the \u201cA1\u201d cell of the \u201cSheet1\u201d sheet specified above.<\/p>\n\n\n\n<p><\/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=\"\">'4. \uc774 \uc2dc\ud2b8\uc758 A1 cell \uc5d0 \"TEST\" \ubb38\uc790\uc5f4 \uc785\ub825\nApplication.Workbooks(\"t1.xlsx\").Worksheets(\"Sheet1\").Range(\"A1\") = \"TEST\"\nWorkbooks(\"t1.xlsx\").Worksheets(\"Sheet1\").Range(\"A1\") = \"TEST\"<\/pre>\n\n\n\n<p>\u25b2 This code inputs a string value to the cell accessed above. You can enter any type of value, including strings and numbers.<\/p>\n\n\n\n<p><\/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=\"\">'5. \uc774 \uc2dc\ud2b8\uc758 A1 cell \uae00\uaf34\uc744 \uad75\uac8c(Bold) \uc124\uc815\nApplication.Workbooks(\"t1.xlsx\").Worksheets(\"Sheet1\").Range(\"A1\").Font.Bold = True\nWorkbooks(\"t1.xlsx\").Worksheets(\"Sheet1\").Range(\"A1\").Font.Bold = True<\/pre>\n\n\n\n<p>\u25b2 This code sets the cell format using the Range object. All cell formats such as font name, color, size, background color, cell border type, and border color can be set with VBA code.<\/p>\n\n\n\n<p><\/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=\"\">'6. \uc774 \uc2dc\ud2b8\uc758 A2:D4 \ubc94\uc704\nApplication.Workbooks(\"t1.xlsx\").Worksheets(\"Sheet1\").Range(\"A2:D4\")\nWorkbooks(\"t1.xlsx\").Worksheets(\"Sheet1\").Range(\"A2:D4\")<\/pre>\n\n\n\n<p>\u25b2 A Range object can point to several contiguous cells. Range (\u201cA2:D4\u201d) represents &#039;2 rows, 1 column&#039; to &#039;4 rows, 4 columns&#039;.<\/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-75.png\"><img loading=\"lazy\" decoding=\"async\" width=\"356\" height=\"323\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-75.png\" alt=\"Range(&quot;A2:D4&quot;)\" class=\"wp-image-11345\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-75.png 356w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-75-300x272.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-75-13x12.png 13w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-75-24x22.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-75-36x33.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-75-48x44.png 48w\" sizes=\"auto, (max-width: 356px) 100vw, 356px\" \/><\/a><figcaption>Range(\u201cA2:D4\u201d)<\/figcaption><\/figure>\n<\/div>\n\n\n<h4 class=\"wp-block-heading\" id=\"2.4.2._\uac1d\uccb4_\uc811\uadfc_\ub2e8\uc21c\ud615\"><span class=\"ez-toc-section\" id=\"242_%EA%B0%9D%EC%B2%B4_%EC%A0%91%EA%B7%BC_%EB%8B%A8%EC%88%9C%ED%98%95\"><\/span>2.4.2. simple object access<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>When accessing the current file or sheet, you can simply use it as follows. This code is simple and highly readable, but care must be taken when the current file or sheet is changed during execution.<\/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=\"\">'1. \ud604\uc7ac \uc5f4\ub824\uc788\ub294 \ud30c\uc77c\nActiveWorkbook\n\n'2. \ud604\uc7ac \uc5f4\ub824\uc788\ub294 \uc2dc\ud2b8\nActiveWorksheet\n\n'3. \ud604\uc7ac \uc5f4\ub824\uc788\ub294 \uc2dc\ud2b8\uc758 A1 cell\nRange(\"A1\")\nActiveWorksheet.Range(\"A1\")\n\n'4. \ud604\uc7ac \uc5f4\ub824\uc788\ub294 \uc2dc\ud2b8\uc758 A1 cell \uc5d0 \"TEST\" \ub77c\ub294 \uac12 \ud560\ub2f9\nRange(\"A1\") = \"TEST\"\n\n'5. \ud604\uc7ac \uc5f4\ub824\uc788\ub294 \uc2dc\ud2b8\uc758 \uc2dc\ud2b8\uc758 A1 cell \uae00\uaf34\uc744 \uad75\uac8c(Bold) \uc124\uc815\nRange(\"A1\").Font.Bold = True\n\n'6. \ud604\uc7ac \uc5f4\ub824\uc788\ub294 \uc2dc\ud2b8\uc758 A2:D4 \ubc94\uc704\nRange(\"A2:D4\")<\/pre>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"2.4.3._\uac1d\uccb4_\uc811\uadfc_&amp;_\ud65c\uc6a9_\uc608\uc81c\"><span class=\"ez-toc-section\" id=\"243_%EA%B0%9D%EC%B2%B4_%EC%A0%91%EA%B7%BC_%ED%99%9C%EC%9A%A9_%EC%98%88%EC%A0%9C\"><\/span>2.4.3. Object Access &amp; Utilization Examples<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>Let&#039;s look at some more examples of accessing objects.<\/p>\n\n\n\n<p><\/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=\"\">'1. \ud604\uc7ac \uc5f4\ub824\uc788\ub294 \ud30c\uc77c\ub4e4\nWorkbooks\n\n'2. \ud604\uc7ac \uc5f4\ub824\uc788\ub294 \ud30c\uc77c\ub4e4\uc758 \uc218\nWorkbooks.Count\n\n'3. \uc0c8\ub85c\uc6b4 \ud30c\uc77c \ub9cc\ub4e4\uae30\nWorkbooks.Add\n\n'4. \ud604\uc7ac \ud30c\uc77c\uc744 C:\\test.xlsx\ub85c \uc800\uc7a5\ud558\uae30\nActiveWorkbook.SaveAs \"C:\\test.xlsx\"\n\n'5. \ud604\uc7ac \ud30c\uc77c\uc758 \uc774\ub984\uc744 \ubcf4\uc5ec\uc8fc\uae30\nMsgBox ActiveWorkbook.Name\n\n'6. \ud604\uc7ac \uc5f4\ub824\uc788\ub294 \ud30c\uc77c\uc758 \uc2dc\ud2b8\ub4e4\nWorksheets\n\n'7. \ud604\uc7ac \uc5f4\ub824\uc788\ub294 \ud30c\uc77c\uc758 \uc2dc\ud2b8\ub4e4\uc758 \uc218\nWorksheets.Count\n\n'8. \uc0c8\ub85c\uc6b4 \uc2dc\ud2b8 \ub9cc\ub4e4\uae30\nWorksheets.Add\n\n'9. Sheet1\uc744 \uc0ad\uc81c\ud558\uae30\nWorksheets(\"Sheet1\").Delete\n\n'10. \ud604\uc7ac \uc2dc\ud2b8\uc758 \uc774\ub984\uc744 \ubcf4\uc5ec\uc8fc\uae30\nMsgBox ActiveSheet.Name\n\n'11. \ud604\uc7ac \uc5f4\ub824\uc788\ub294 \uc2dc\ud2b8\uc758 A1 cell \uc120\ud0dd\nRange(\"A1\").Select\n\n'12. \ud604\uc7ac \uc5f4\ub824\uc788\ub294 \uc2dc\ud2b8\uc5d0\uc11c \uc0ac\uc6a9\ub41c \uc601\uc5ed\uc744 \uc120\ud0dd\nActiveSheet.UsedRange.Select<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"2.5._\uc5d1\uc140_Object_Model_\uc0c1\uc138\"><span class=\"ez-toc-section\" id=\"25_%EC%97%91%EC%85%80_Object_Model_%EC%83%81%EC%84%B8\"><\/span>2.5. Excel Object Model Details<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>The hierarchical structure of the frequently used Excel Object Model is as follows. The objects shown in this figure are a part, not the whole, provided to Excel VBA. Of these, the object with the background color has been dealt with once in the contents so far.&nbsp;<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-76.png\"><img loading=\"lazy\" decoding=\"async\" width=\"985\" height=\"441\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-76.png\" alt=\"\uc5d1\uc140 Object Model(\uc77c\ubd80)\" class=\"wp-image-11346\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-76.png 985w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-76-300x134.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-76-768x344.png 768w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-76-18x8.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-76-24x11.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-76-36x16.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-76-48x21.png 48w\" sizes=\"auto, (max-width: 985px) 100vw, 985px\" \/><\/a><figcaption>Excel Object Model (Part)<\/figcaption><\/figure>\n\n\n\n<p>You don&#039;t need to know all of the white background objects now. You can learn and use it later when you need it. For now, just looking at it to see if there is such a thing is enough.<\/p>\n\n\n\n<p>The entire object is divided into page1, page2, and page3 on the Microsoft Docs site.<\/p>\n\n\n\n<figure class=\"wp-block-gallery has-nested-images columns-3 wp-block-gallery-1 is-layout-flex wp-block-gallery-is-layout-flex\">\n<figure class=\"wp-block-image size-medium\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-77.png\"><img loading=\"lazy\" decoding=\"async\" width=\"156\" height=\"300\" data-id=\"11347\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-77-156x300.png\" alt=\"\uc5d1\uc140 Object Model(\uc804\uccb4) Page 1\" class=\"wp-image-11347\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-77-156x300.png 156w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-77-6x12.png 6w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-77-12x24.png 12w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-77-19x36.png 19w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-77-25x48.png 25w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-77.png 402w\" sizes=\"auto, (max-width: 156px) 100vw, 156px\" \/><\/a><figcaption>Excel Object Model (All) Page 1<\/figcaption><\/figure>\n\n\n\n<figure class=\"wp-block-image size-medium\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-78.png\"><img loading=\"lazy\" decoding=\"async\" width=\"217\" height=\"300\" data-id=\"11348\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-78-217x300.png\" alt=\"\uc5d1\uc140 Object Model(\uc804\uccb4) Page 2\" class=\"wp-image-11348\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-78-217x300.png 217w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-78-9x12.png 9w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-78-17x24.png 17w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-78-26x36.png 26w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-78-35x48.png 35w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-78.png 573w\" sizes=\"auto, (max-width: 217px) 100vw, 217px\" \/><\/a><figcaption>Excel Object Model (All) Page 2<\/figcaption><\/figure>\n\n\n\n<figure class=\"wp-block-image size-medium\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-79.png\"><img loading=\"lazy\" decoding=\"async\" width=\"260\" height=\"300\" data-id=\"11349\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-79-260x300.png\" alt=\"\uc5d1\uc140 Object Model(\uc804\uccb4) Page 3\" class=\"wp-image-11349\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-79-260x300.png 260w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-79-10x12.png 10w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-79-21x24.png 21w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-79-31x36.png 31w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-79-42x48.png 42w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-79.png 618w\" sizes=\"auto, (max-width: 260px) 100vw, 260px\" \/><\/a><figcaption>Excel Object Model (All) Page 3<\/figcaption><\/figure>\n<figcaption class=\"blocks-gallery-caption\">Excel Object Model (All)<\/figcaption><\/figure>\n\n\n\n<p>The source of each image above is the following URL.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Page1:&nbsp;<a href=\"https:\/\/docs.microsoft.com\/en-us\/previous-versions\/office\/developer\/office-xp\/aa141044(v=office.10)?redirectedfrom=MSDN\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/docs.microsoft.com\/en-us\/previous-versions\/office\/developer\/office-xp\/aa141044(v=office.10)?redirectedfrom=MSDN<\/a><\/li><li>Page2:&nbsp;<a href=\"https:\/\/docs.microsoft.com\/en-us\/previous-versions\/office\/office-10\/aa189565(v=office.10)?redirectedfrom=MSDN\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/docs.microsoft.com\/en-us\/previous-versions\/office\/office-10\/aa189565(v=office.10)?redirectedfrom=MSDN<\/a><\/li><li>Page 3:&nbsp;<a href=\"https:\/\/docs.microsoft.com\/en-us\/previous-versions\/office\/office-10\/aa189566(v=office.10)?redirectedfrom=MSDN\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/docs.microsoft.com\/en-us\/previous-versions\/office\/office-10\/aa189566(v=office.10)?redirectedfrom=MSDN<\/a><\/li><\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p>Above, we looked at the Excel Object Model in detail. Next, I will explain the references related to Excel VBA.<\/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>In this article, we will look at how to handle the Excel Object Model. 2.4. Understanding the Excel Object Model with Simple Code 2.4.1. Basic Object Access Let&#039;s look at the most basic code that accesses files, sheets, ranges, and cells. For reference, the global object Application can be omitted when accessing the object. 1 below...<\/p>","protected":false},"author":1,"featured_media":11349,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28],"tags":[17],"class_list":["post-11344","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(4): \uc5d1\uc140 Object Model \ub2e4\ub8e8\uae30 - \uc0dd\uc0b0\uc131 Skill<\/title>\n<meta name=\"description\" content=\"\uc5d1\uc140 Object Model\uc744 \ub2e4\ub8e8\ub294 \ubc29\ubc95\uc744 1)\uac1d\uccb4 \uc811\uadfc \uae30\ubcf8\ud615, 2)\uac1d\uccb4 \uc811\uadfc \ub2e8\uc21c\ud615, 3)\uac1d\uccb4 \uc811\uadfc &amp; \ud65c\uc6a9 \uc608\uc81c\ub85c \ub098\ub204\uc5b4 \uc608\uc2dc\ucf54\ub4dc\ub97c \uc0b4\ud3b4\ubcf4\uace0 \uc5d1\uc140 Object Model\uc758 \uc0c1\uc138 \ub0b4\uc6a9\uc744 \uc54c\uc544\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-4-handling-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(4): \uc5d1\uc140 Object Model \ub2e4\ub8e8\uae30 - \uc0dd\uc0b0\uc131 Skill\" \/>\n<meta property=\"og:description\" content=\"\uc5d1\uc140 Object Model\uc744 \ub2e4\ub8e8\ub294 \ubc29\ubc95\uc744 1)\uac1d\uccb4 \uc811\uadfc \uae30\ubcf8\ud615, 2)\uac1d\uccb4 \uc811\uadfc \ub2e8\uc21c\ud615, 3)\uac1d\uccb4 \uc811\uadfc &amp; \ud65c\uc6a9 \uc608\uc81c\ub85c \ub098\ub204\uc5b4 \uc608\uc2dc\ucf54\ub4dc\ub97c \uc0b4\ud3b4\ubcf4\uace0 \uc5d1\uc140 Object Model\uc758 \uc0c1\uc138 \ub0b4\uc6a9\uc744 \uc54c\uc544\ubcf8\ub2e4.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/prodskill.com\/en\/excel-vba-lecture-4-handling-object-model\/\" \/>\n<meta property=\"og:site_name\" content=\"\uc0dd\uc0b0\uc131 Skill\" \/>\n<meta property=\"article:published_time\" content=\"2022-09-11T03:40:12+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-10-11T02:40:26+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-79.png\" \/>\n\t<meta property=\"og:image:width\" content=\"618\" \/>\n\t<meta property=\"og:image:height\" content=\"714\" \/>\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=\"5 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-4-handling-object-model\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/prodskill.com\/excel-vba-lecture-4-handling-object-model\/\"},\"author\":{\"name\":\"Zerom\",\"@id\":\"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd\"},\"headline\":\"\uc5d1\uc140 VBA \uac15\uc88c(4): \uc5d1\uc140 Object Model \ub2e4\ub8e8\uae30\",\"datePublished\":\"2022-09-11T03:40:12+00:00\",\"dateModified\":\"2022-10-11T02:40:26+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/prodskill.com\/excel-vba-lecture-4-handling-object-model\/\"},\"wordCount\":175,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd\"},\"image\":{\"@id\":\"https:\/\/prodskill.com\/excel-vba-lecture-4-handling-object-model\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-79.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-4-handling-object-model\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/prodskill.com\/excel-vba-lecture-4-handling-object-model\/\",\"url\":\"https:\/\/prodskill.com\/excel-vba-lecture-4-handling-object-model\/\",\"name\":\"\uc5d1\uc140 VBA \uac15\uc88c(4): \uc5d1\uc140 Object Model \ub2e4\ub8e8\uae30 - \uc0dd\uc0b0\uc131 Skill\",\"isPartOf\":{\"@id\":\"https:\/\/prodskill.com\/ko\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/prodskill.com\/excel-vba-lecture-4-handling-object-model\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/prodskill.com\/excel-vba-lecture-4-handling-object-model\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-79.png\",\"datePublished\":\"2022-09-11T03:40:12+00:00\",\"dateModified\":\"2022-10-11T02:40:26+00:00\",\"description\":\"\uc5d1\uc140 Object Model\uc744 \ub2e4\ub8e8\ub294 \ubc29\ubc95\uc744 1)\uac1d\uccb4 \uc811\uadfc \uae30\ubcf8\ud615, 2)\uac1d\uccb4 \uc811\uadfc \ub2e8\uc21c\ud615, 3)\uac1d\uccb4 \uc811\uadfc & \ud65c\uc6a9 \uc608\uc81c\ub85c \ub098\ub204\uc5b4 \uc608\uc2dc\ucf54\ub4dc\ub97c \uc0b4\ud3b4\ubcf4\uace0 \uc5d1\uc140 Object Model\uc758 \uc0c1\uc138 \ub0b4\uc6a9\uc744 \uc54c\uc544\ubcf8\ub2e4.\",\"breadcrumb\":{\"@id\":\"https:\/\/prodskill.com\/excel-vba-lecture-4-handling-object-model\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/prodskill.com\/excel-vba-lecture-4-handling-object-model\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/prodskill.com\/excel-vba-lecture-4-handling-object-model\/#primaryimage\",\"url\":\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-79.png\",\"contentUrl\":\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-79.png\",\"width\":618,\"height\":714,\"caption\":\"\uc5d1\uc140 Object Model(\uc804\uccb4) Page 3\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/prodskill.com\/excel-vba-lecture-4-handling-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(4): \uc5d1\uc140 Object Model \ub2e4\ub8e8\uae30\"}]},{\"@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 (4): Handling the Excel Object Model - Productivity Skill","description":"We will look at example codes to learn about the details of the Excel Object Model by dividing the method of handling the Excel Object Model into 1) basic object access, 2) simple object access, and 3) object access &amp; utilization examples.","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-4-handling-object-model\/","og_locale":"en_US","og_type":"article","og_title":"\uc5d1\uc140 VBA \uac15\uc88c(4): \uc5d1\uc140 Object Model \ub2e4\ub8e8\uae30 - \uc0dd\uc0b0\uc131 Skill","og_description":"\uc5d1\uc140 Object Model\uc744 \ub2e4\ub8e8\ub294 \ubc29\ubc95\uc744 1)\uac1d\uccb4 \uc811\uadfc \uae30\ubcf8\ud615, 2)\uac1d\uccb4 \uc811\uadfc \ub2e8\uc21c\ud615, 3)\uac1d\uccb4 \uc811\uadfc & \ud65c\uc6a9 \uc608\uc81c\ub85c \ub098\ub204\uc5b4 \uc608\uc2dc\ucf54\ub4dc\ub97c \uc0b4\ud3b4\ubcf4\uace0 \uc5d1\uc140 Object Model\uc758 \uc0c1\uc138 \ub0b4\uc6a9\uc744 \uc54c\uc544\ubcf8\ub2e4.","og_url":"https:\/\/prodskill.com\/en\/excel-vba-lecture-4-handling-object-model\/","og_site_name":"\uc0dd\uc0b0\uc131 Skill","article_published_time":"2022-09-11T03:40:12+00:00","article_modified_time":"2022-10-11T02:40:26+00:00","og_image":[{"width":618,"height":714,"url":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-79.png","type":"image\/png"}],"author":"Zerom","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Zerom","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/prodskill.com\/excel-vba-lecture-4-handling-object-model\/#article","isPartOf":{"@id":"https:\/\/prodskill.com\/excel-vba-lecture-4-handling-object-model\/"},"author":{"name":"Zerom","@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd"},"headline":"\uc5d1\uc140 VBA \uac15\uc88c(4): \uc5d1\uc140 Object Model \ub2e4\ub8e8\uae30","datePublished":"2022-09-11T03:40:12+00:00","dateModified":"2022-10-11T02:40:26+00:00","mainEntityOfPage":{"@id":"https:\/\/prodskill.com\/excel-vba-lecture-4-handling-object-model\/"},"wordCount":175,"commentCount":0,"publisher":{"@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd"},"image":{"@id":"https:\/\/prodskill.com\/excel-vba-lecture-4-handling-object-model\/#primaryimage"},"thumbnailUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-79.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-4-handling-object-model\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/prodskill.com\/excel-vba-lecture-4-handling-object-model\/","url":"https:\/\/prodskill.com\/excel-vba-lecture-4-handling-object-model\/","name":"Excel VBA Tutorial (4): Handling the Excel Object Model - Productivity Skill","isPartOf":{"@id":"https:\/\/prodskill.com\/ko\/#website"},"primaryImageOfPage":{"@id":"https:\/\/prodskill.com\/excel-vba-lecture-4-handling-object-model\/#primaryimage"},"image":{"@id":"https:\/\/prodskill.com\/excel-vba-lecture-4-handling-object-model\/#primaryimage"},"thumbnailUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-79.png","datePublished":"2022-09-11T03:40:12+00:00","dateModified":"2022-10-11T02:40:26+00:00","description":"We will look at example codes to learn about the details of the Excel Object Model by dividing the method of handling the Excel Object Model into 1) basic object access, 2) simple object access, and 3) object access &amp; utilization examples.","breadcrumb":{"@id":"https:\/\/prodskill.com\/excel-vba-lecture-4-handling-object-model\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/prodskill.com\/excel-vba-lecture-4-handling-object-model\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/prodskill.com\/excel-vba-lecture-4-handling-object-model\/#primaryimage","url":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-79.png","contentUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-79.png","width":618,"height":714,"caption":"\uc5d1\uc140 Object Model(\uc804\uccb4) Page 3"},{"@type":"BreadcrumbList","@id":"https:\/\/prodskill.com\/excel-vba-lecture-4-handling-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(4): \uc5d1\uc140 Object Model \ub2e4\ub8e8\uae30"}]},{"@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\/11344","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=11344"}],"version-history":[{"count":0,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/posts\/11344\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/media\/11349"}],"wp:attachment":[{"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/media?parent=11344"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/categories?post=11344"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/tags?post=11344"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}