{"id":11386,"date":"2022-09-11T18:29:45","date_gmt":"2022-09-11T09:29:45","guid":{"rendered":"https:\/\/prodskill.com\/?p=11386"},"modified":"2022-10-11T11:42:21","modified_gmt":"2022-10-11T02:42:21","slug":"excel-vba-lecture-8-datatype","status":"publish","type":"post","link":"https:\/\/prodskill.com\/ko\/excel-vba-lecture-8-datatype\/","title":{"rendered":"\uc5d1\uc140 VBA \uac15\uc88c(8): \uc5d1\uc140 VBA \uc5b8\uc5b4 \uae30\ubcf8-\uc790\ub8cc\ud615(Data type), \uc790\ub8cc\uad6c\uc870(Data structure)"},"content":{"rendered":"\n<p>\uc774\ubc88 \uae00\uc740 \uc5d1\uc140 VBA \uc5b8\uc5b4 \uae30\ubcf8 \uc911 \uc790\ub8cc\ud615(Data type)\uacfc \uc81c\uacf5\ub418\ub294 \uc790\ub8cc\uad6c\uc870(Data structure)\uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf8\ub2e4.<\/p>\n\n\n\n<p>\uc774\uc804&nbsp;\uae00\uc5d0\uc11c&nbsp;\uc774\uc5b4\uc9c0\ub294&nbsp;\ub0b4\uc6a9\uc774\ub2e4.<\/p>\n\n\n\n<p><a href=\"https:\/\/prodskill.com\/excel-vba-lecture-7-syntax\/\">\uc5d1\uc140 VBA \uac15\uc88c(7): \uc5d1\uc140 VBA \uc5b8\uc5b4 \uae30\ubcf8-\ubb38\ubc95(Syntax)<\/a><\/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;\ubaa9\ucc28&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=\"\ubaa9\ucc28 \ud1a0\uae00\"><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-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/prodskill.com\/ko\/excel-vba-lecture-8-datatype\/#33_%EC%9E%90%EB%A3%8C%ED%98%95\" >3.3. \uc790\ub8cc\ud615<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/prodskill.com\/ko\/excel-vba-lecture-8-datatype\/#331_%EA%B8%B0%EB%B3%B8_%EC%9E%90%EB%A3%8C%ED%98%95\" >3.3.1. \uae30\ubcf8 \uc790\ub8cc\ud615<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/prodskill.com\/ko\/excel-vba-lecture-8-datatype\/#%EA%B8%B0%EB%B3%B8_%EC%9E%90%EB%A3%8C%ED%98%95_%EB%AA%A9%EB%A1%9D\" >\uae30\ubcf8 \uc790\ub8cc\ud615 \ubaa9\ub85d<\/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\/ko\/excel-vba-lecture-8-datatype\/#Variant_%EB%8D%B0%EC%9D%B4%ED%84%B0_%ED%98%95%EC%8B%9D\" >Variant \ub370\uc774\ud130 \ud615\uc2dd<\/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\/ko\/excel-vba-lecture-8-datatype\/#User-defined%EC%82%AC%EC%9A%A9%EC%9E%90_%EC%A0%95%EC%9D%98_%EB%8D%B0%EC%9D%B4%ED%84%B0_%ED%98%95%EC%8B%9D\" >User-defined(\uc0ac\uc6a9\uc790 \uc815\uc758) \ub370\uc774\ud130 \ud615\uc2dd<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/prodskill.com\/ko\/excel-vba-lecture-8-datatype\/#332_%EC%9E%90%EB%A3%8C%EA%B5%AC%EC%A1%B0\" >3.3.2. \uc790\ub8cc\uad6c\uc870<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/prodskill.com\/ko\/excel-vba-lecture-8-datatype\/#Array\" >Array<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/prodskill.com\/ko\/excel-vba-lecture-8-datatype\/#Collection\" >Collection<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/prodskill.com\/ko\/excel-vba-lecture-8-datatype\/#Dictionary\" >Dictionary<\/a><\/li><\/ul><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\" id=\"3.3._\uc790\ub8cc\ud615\"><span class=\"ez-toc-section\" id=\"33_%EC%9E%90%EB%A3%8C%ED%98%95\"><\/span>3.3. \uc790\ub8cc\ud615<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"3.3.1._\uae30\ubcf8_\uc790\ub8cc\ud615\"><span class=\"ez-toc-section\" id=\"331_%EA%B8%B0%EB%B3%B8_%EC%9E%90%EB%A3%8C%ED%98%95\"><\/span>3.3.1. \uae30\ubcf8 \uc790\ub8cc\ud615<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>VB(\ub610\ub294 VBA)\uc5d0\uc11c \uc9c0\uc6d0\ud558\ub294 \uc790\ub8cc\ud615\uc744 \uc694\uc57d\ud558\uba74 \ub2e4\uc74c \ud45c\uc640 \uac19\ub2e4. \uc544\ub798 \ucd9c\ucc98\uc758 \ud45c \ub0b4\uc6a9\uc911 Collection, Dictionary\ub294 &#8220;\uc790\ub8cc \uad6c\uc870&#8221;\uc5d0\uc11c \ubcc4\ub3c4\ub85c \uc124\uba85\ud55c\ub2e4.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"\uae30\ubcf8_\uc790\ub8cc\ud615_\ubaa9\ub85d\"><span class=\"ez-toc-section\" id=\"%EA%B8%B0%EB%B3%B8_%EC%9E%90%EB%A3%8C%ED%98%95_%EB%AA%A9%EB%A1%9D\"><\/span>\uae30\ubcf8 \uc790\ub8cc\ud615 \ubaa9\ub85d<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>\ucd9c\ucc98:&nbsp;<a href=\"https:\/\/docs.microsoft.com\/en-us\/office\/vba\/language\/reference\/user-interface-help\/data-type-summary\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/docs.microsoft.com\/en-us\/office\/vba\/language\/reference\/user-interface-help\/data-type-summary<\/a><\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td><strong>\ub370\uc774\ud130 \ud615\uc2dd<\/strong><\/td><td><strong>\uc800\uc7a5 \uc6a9\ub7c9<\/strong><\/td><td><strong>\ubc94\uc704<\/strong><\/td><\/tr><tr><td><strong><a href=\"https:\/\/docs.microsoft.com\/en-us\/office\/vba\/language\/reference\/user-interface-help\/boolean-data-type\" target=\"_blank\" rel=\"noreferrer noopener\">Boolean<\/a><\/strong><\/td><td>2 bytes<\/td><td><strong>True<\/strong>&nbsp;\ub610\ub294&nbsp;<strong>False<\/strong><\/td><\/tr><tr><td><strong><a href=\"https:\/\/docs.microsoft.com\/en-us\/office\/vba\/language\/reference\/user-interface-help\/byte-data-type\" target=\"_blank\" rel=\"noreferrer noopener\">Byte<\/a><\/strong><\/td><td>1 byte<\/td><td>0 ~ 255<\/td><\/tr><tr><td><strong>Collection<\/strong><\/td><td>Unknown<\/td><td>Unknown<\/td><\/tr><tr><td><strong><a href=\"https:\/\/docs.microsoft.com\/en-us\/office\/vba\/language\/reference\/user-interface-help\/currency-data-type\" target=\"_blank\" rel=\"noreferrer noopener\">Currency<\/a><\/strong>&nbsp;(scaled integer)<\/td><td>8 bytes<\/td><td>-922,337,203,685,477.5808 ~ 922,337,203,685,477.5807<\/td><\/tr><tr><td><strong><a href=\"https:\/\/docs.microsoft.com\/en-us\/office\/vba\/language\/reference\/user-interface-help\/date-data-type\" target=\"_blank\" rel=\"noreferrer noopener\">Date<\/a><\/strong><\/td><td>8 bytes<\/td><td>January 1, 100, to December 31, 9999<br>(100-01-01 ~ 9999-12-31)<\/td><\/tr><tr><td><strong><a href=\"https:\/\/docs.microsoft.com\/en-us\/office\/vba\/language\/reference\/user-interface-help\/decimal-data-type\" target=\"_blank\" rel=\"noreferrer noopener\">Decimal<\/a><\/strong><\/td><td>14 bytes<\/td><td>+\/-79,228,162,514,264,337,593,543,950,335 with no decimal point<br><br>+\/-7.9228162514264337593543950335 with 28 places to the right of the decimal<br><br>Smallest non-zero number is+\/-0.0000000000000000000000000001<\/td><\/tr><tr><td><strong>Dictionary<\/strong><\/td><td>Unknown<\/td><td>Unknown<\/td><\/tr><tr><td><strong><a href=\"https:\/\/docs.microsoft.com\/en-us\/office\/vba\/language\/reference\/user-interface-help\/double-data-type\" target=\"_blank\" rel=\"noreferrer noopener\">Double<\/a><\/strong>&nbsp;(double-precision floating-point)<\/td><td>8 bytes<\/td><td>-1.79769313486231E308 to -4.94065645841247E-324 for negative values<br><br>4.94065645841247E-324 to 1.79769313486232E308 for positive values<\/td><\/tr><tr><td><strong><a href=\"https:\/\/docs.microsoft.com\/en-us\/office\/vba\/language\/reference\/user-interface-help\/integer-data-type\" target=\"_blank\" rel=\"noreferrer noopener\">Integer<\/a><\/strong><\/td><td>2 bytes<\/td><td>-32,768 to 32,767<\/td><\/tr><tr><td><strong><a href=\"https:\/\/docs.microsoft.com\/en-us\/office\/vba\/language\/reference\/user-interface-help\/long-data-type\" target=\"_blank\" rel=\"noreferrer noopener\">Long<\/a><\/strong>&nbsp;(Long integer)<\/td><td>4 bytes<\/td><td>-2,147,483,648 to 2,147,483,647<\/td><\/tr><tr><td><strong><a href=\"https:\/\/docs.microsoft.com\/en-us\/office\/vba\/language\/reference\/user-interface-help\/longlong-data-type\" target=\"_blank\" rel=\"noreferrer noopener\">LongLong<\/a><\/strong>&nbsp;(LongLong integer)<\/td><td>8 bytes<\/td><td>-9,223,372,036,854,775,808 to 9,223,372,036,854,775,807<br><br>Valid on 64-bit platforms only.<\/td><\/tr><tr><td><strong><a href=\"https:\/\/docs.microsoft.com\/en-us\/office\/vba\/language\/reference\/user-interface-help\/longptr-data-type\" target=\"_blank\" rel=\"noreferrer noopener\">LongPtr<\/a><\/strong>&nbsp;(Long integer on 32-bit systems, LongLong integer on 64-bit systems)<\/td><td>4 bytes on 32-bit systems<br><br>8 bytes on 64-bit systems<\/td><td>-2,147,483,648 to 2,147,483,647 on 32-bit systems<br><br>-9,223,372,036,854,775,808 to 9,223,372,036,854,775,807 on 64-bit systems<\/td><\/tr><tr><td><strong><a href=\"https:\/\/docs.microsoft.com\/en-us\/office\/vba\/language\/reference\/user-interface-help\/object-data-type\" target=\"_blank\" rel=\"noreferrer noopener\">Object<\/a><\/strong><\/td><td>4 bytes<\/td><td>Any&nbsp;<strong>Object<\/strong>&nbsp;reference<\/td><\/tr><tr><td><strong><a href=\"https:\/\/docs.microsoft.com\/en-us\/office\/vba\/language\/reference\/user-interface-help\/single-data-type\" target=\"_blank\" rel=\"noreferrer noopener\">Single<\/a><\/strong>&nbsp;(single-precision floating-point)<\/td><td>4 bytes<\/td><td>-3.402823E38 to -1.401298E-45 for negative values<br><br>1.401298E-45 to 3.402823E38 for positive values<\/td><\/tr><tr><td><strong><a href=\"https:\/\/docs.microsoft.com\/en-us\/office\/vba\/language\/reference\/user-interface-help\/string-data-type\" target=\"_blank\" rel=\"noreferrer noopener\">String<\/a><\/strong>&nbsp;(variable-length)<\/td><td>10 bytes + string length<\/td><td>0 to approximately 2 billion<\/td><\/tr><tr><td><strong>String<\/strong>&nbsp;(fixed-length)<\/td><td>Length of string<\/td><td>1 to approximately 65,400<\/td><\/tr><tr><td><strong><a href=\"https:\/\/docs.microsoft.com\/en-us\/office\/vba\/language\/reference\/user-interface-help\/variant-data-type\" target=\"_blank\" rel=\"noreferrer noopener\">Variant<\/a><\/strong>&nbsp;(with numbers)<\/td><td>16 bytes<\/td><td>Any numeric value up to the range of a&nbsp;<strong>Double<\/strong><\/td><\/tr><tr><td><strong>Variant<\/strong>&nbsp;(with characters)<\/td><td>22 bytes + string length (24 bytes on 64-bit systems)<\/td><td>Same range as for variable-length&nbsp;<strong>String<\/strong><\/td><\/tr><tr><td><strong><a href=\"https:\/\/docs.microsoft.com\/en-us\/office\/vba\/language\/how-to\/user-defined-data-type\" target=\"_blank\" rel=\"noreferrer noopener\">User-defined<\/a><\/strong>&nbsp;(using&nbsp;<strong>Type<\/strong>)<\/td><td>Number required by elements<\/td><td>The range of each element is the same as the range of its data type.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>\uc774 \uc911\uc5d0\uc11c \uac00\uc7a5 \uc790\uc8fc \uc0ac\uc6a9\ud558\ub294 \ub370\uc774\ud130 \ud615\uc2dd\uc740 Int, Long, String, Boolean \uc815\ub3c4\uc774\ub2e4.<\/p>\n\n\n\n<p>Variant, User-defined \ub370\uc774\ud130 \ud615\uc2dd\uc5d0 \ub300\ud574 \uc544\ub798\uc5d0 \ucd94\uac00\ub85c \uc124\uba85\ud55c\ub2e4.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"Variant_\ub370\uc774\ud130_\ud615\uc2dd\"><span class=\"ez-toc-section\" id=\"Variant_%EB%8D%B0%EC%9D%B4%ED%84%B0_%ED%98%95%EC%8B%9D\"><\/span><strong>Variant \ub370\uc774\ud130 \ud615\uc2dd<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>Variant \ub370\uc774\ud130 \ud615\uc2dd\uc740 \uc5ec\ub7ec \ub370\uc774\ud130 \ud615\uc2dd\uc744 \uc800\uc7a5\ud558\uace0 \ucc98\ub9ac\ud560 \uc218 \uc788\ub294 \ud2b9\ubcc4\ud55c \ub370\uc774\ud130 \ud615\uc2dd\uc774\ub2e4. \ubcc0\uc218\ub97c \uc120\uc5b8\ud560 \ub54c \ub370\uc774\ud130 \ud615\uc2dd\uc744 \uc0dd\ub7b5\ud558\uba74 Variant \ub370\uc774\ud130 \ud615\uc2dd\uc73c\ub85c \uc9c0\uc815\ub41c\ub2e4. Variant \ub370\uc774\ud130 \ud615\uc2dd\uc5d0 \ub300\ud55c \uc790\uc138\ud55c \ub0b4\uc6a9\uc740 \uc544\ub798 URL\uc744 \ucc38\uace0\ud558\uae30 \ubc14\ub780\ub2e4.<\/p>\n\n\n\n<p><a href=\"https:\/\/docs.microsoft.com\/en-us\/office\/vba\/language\/reference\/user-interface-help\/variant-data-type\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/docs.microsoft.com\/en-us\/office\/vba\/language\/reference\/user-interface-help\/variant-data-type<\/a><\/p>\n\n\n\n<p>\uc2e4\ud589\uc911\uc5d0 Variant \ubcc0\uc218\uac00 \uc5b4\ub5a4 \ub370\uc774\ud130 \ud615\uc2dd\uc744 \uc800\uc7a5\ud558\uace0 \uc788\ub294\uc9c0 \ud655\uc778\ud558\ub824\uba74 VarType \ud568\uc218\ub97c \uc774\uc6a9\ud55c\ub2e4.<\/p>\n\n\n\n<p><a href=\"https:\/\/docs.microsoft.com\/en-us\/office\/vba\/language\/reference\/user-interface-help\/vartype-function\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/docs.microsoft.com\/en-us\/office\/vba\/language\/reference\/user-interface-help\/vartype-function<\/a><\/p>\n\n\n\n<p><strong>\uad6c\ubb38<\/strong><\/p>\n\n\n\n<p><strong>VarType(<\/strong><em>varname<\/em><strong>)<\/strong><\/p>\n\n\n\n<p>\ud544\uc218 \uc694\uc18c\uc778&nbsp;<em>varname<\/em>&nbsp;\uc778\uc218\ub294&nbsp;\uc0ac\uc6a9\uc790 \uc815\uc758 \ud615\uc2dd\uc758 \ubcc0\uc218\ub97c \uc81c\uc678\ud55c \ubcc0\uc218\uac00 \ub4e4\uc5b4 \uc788\ub294&nbsp;Variant\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n<p><strong>\ubc18\ud658<\/strong><strong>\ud615\uc2dd<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td><strong>\uc0c1\uc218<\/strong><\/td><td><strong>\uac12<\/strong><\/td><td><strong>\uc124\uba85<\/strong><\/td><\/tr><tr><td><strong>vbEmpty<\/strong><\/td><td>0<\/td><td><a href=\"https:\/\/docs.microsoft.com\/en-us\/office\/vba\/language\/glossary\/vbe-glossary#empty\" target=\"_blank\" rel=\"noreferrer noopener\">Empty<\/a>(\ucd08\uae30\ud654\ub418\uc9c0 \uc54a\uc74c)<\/td><\/tr><tr><td><strong>vbNull<\/strong><\/td><td>1<\/td><td><a href=\"https:\/\/docs.microsoft.com\/en-us\/office\/vba\/language\/glossary\/vbe-glossary#null\" target=\"_blank\" rel=\"noreferrer noopener\">Null<\/a>(\uc720\ud6a8\ud55c \ub370\uc774\ud130 \uc5c6\uc74c)<\/td><\/tr><tr><td><strong>vbInteger<\/strong><\/td><td>2<\/td><td>\uc815\uc218<\/td><\/tr><tr><td><strong>vbLong<\/strong><\/td><td>3<\/td><td>\uae34 \uc815\uc218<\/td><\/tr><tr><td><strong>vbSingle<\/strong><\/td><td>4<\/td><td>\ub2e8\uc815\ub3c4 \ubd80\ub3d9 \uc18c\uc218\uc810 \uc218<\/td><\/tr><tr><td><strong>vbDouble<\/strong><\/td><td>5<\/td><td>\ubc30\uc815\ub3c4 \ubd80\ub3d9 \uc18c\uc218\uc810 \uc218<\/td><\/tr><tr><td><strong>vbCurrency<\/strong><\/td><td>6<\/td><td>\ud1b5\ud654\uac12<\/td><\/tr><tr><td><strong>vbDate<\/strong><\/td><td>7<\/td><td>\ub0a0\uc9dc\uac12<\/td><\/tr><tr><td><strong>vbString<\/strong><\/td><td>8<\/td><td>\ubb38\uc790\uc5f4<\/td><\/tr><tr><td><strong>vbObject<\/strong><\/td><td>9<\/td><td>\uac1c\uccb4<\/td><\/tr><tr><td><strong>vbError<\/strong><\/td><td>10<\/td><td>\uc624\ub958\uac12<\/td><\/tr><tr><td><strong>vbBoolean<\/strong><\/td><td>11<\/td><td>Boolean \uac12<\/td><\/tr><tr><td><strong>vbVariant<\/strong><\/td><td>12<\/td><td><strong>Variant<\/strong>(variant&nbsp;<a href=\"https:\/\/docs.microsoft.com\/en-us\/office\/vba\/language\/glossary\/vbe-glossary#array\" target=\"_blank\" rel=\"noreferrer noopener\">\ubc30\uc5f4<\/a>\uc5d0\uc11c\ub9cc \uc0ac\uc6a9)<\/td><\/tr><tr><td><strong>vbDataObject<\/strong><\/td><td>13<\/td><td>\ub370\uc774\ud130 \uc561\uc138\uc2a4 \uac1c\uccb4<\/td><\/tr><tr><td><strong>vbDecimal<\/strong><\/td><td>14<\/td><td>\uc2ed\uc9c4\uac12<\/td><\/tr><tr><td><strong>vbByte<\/strong><\/td><td>17<\/td><td>\ubc14\uc774\ud2b8\uac12<\/td><\/tr><tr><td><strong>vbArray<\/strong><\/td><td>8192<\/td><td>\ubc30\uc5f4<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>\ub098\ub294 \uac1c\uc778\uc801\uc73c\ub85c Variant \ub370\uc774\ud130 \ud615\uc2dd\uc744 \uc798 \uc0ac\uc6a9\ud558\uc9c0 \uc54a\uace0 \uc2dc\ud2b8 \ub370\uc774\ud130\ub97c \ud55c\ubc88\uc5d0 \uc77d\uace0 \uc4f8 \ub54c\uc5d0\ub9cc \uc8fc\ub85c \uc0ac\uc6a9\ud55c\ub2e4. Variant arry\ub97c \uc774\uc6a9\ud558\uc5ec \ub9ce\uc740 \uc591\uc758 \uc2dc\ud2b8 \ub370\uc774\ud130\ub97c \uc77d\uace0 \uc4f0\ub294 \ubc29\ubc95\uc5d0 \ub300\ud574\uc11c\ub294 \uc544\ub798 \uae00\uc744 \ucc38\uace0\ud55c\ub2e4.<\/p>\n\n\n\n<p><a href=\"https:\/\/prodskill.com\/excel-vba-coding-pattern-range-loop-read\/\">VBA \ucf54\ub529 \ud328\ud134: Range Loop-\uc77d\uae30(Read)<\/a><\/p>\n\n\n\n<p><a href=\"https:\/\/prodskill.com\/excel-vba-coding-pattern-range-loop-write\/\">VBA \ucf54\ub529 \ud328\ud134: Range Loop-\uc4f0\uae30(Write)<\/a><\/p>\n\n\n\n<p>Variant \ub370\uc774\ud130 \ud615\uc2dd\uc744 \uc0ac\uc6a9\ud558\ub294 \uc608\uc81c \ucf54\ub4dc\uc774\ub2e4. \uc815\uc218, \ubb38\uc790\uc5f4, \uc2e4\uc218, \ub0a0\uc9dc \ub370\uc774\ud130 \ud615\uc2dd\uc744 \ubaa8\ub450 \ucc98\ub9ac\ud560 \uc218 \uc788\ub294 \uac83\uc744 \ubcf4\uc5ec\uc900\ub2e4.<\/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=\"\">Sub VariantTest()\n    Dim a As Variant '\ub370\uc774\ud130 \ud615\uc2dd\uc744 \uc0dd\ub7b5\ud558\uba74 Variant \ud615\uc2dd\uc784\n    a = 1: Debug.Print a\n    a = \"1\": Debug.Print a\n    a = 1.1: Debug.Print a\n    a = CDate(\"2021-07-31\"): Debug.Print a\nEnd Sub<\/pre>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"User-defined(\uc0ac\uc6a9\uc790_\uc815\uc758)_\ub370\uc774\ud130_\ud615\uc2dd\"><span class=\"ez-toc-section\" id=\"User-defined%EC%82%AC%EC%9A%A9%EC%9E%90_%EC%A0%95%EC%9D%98_%EB%8D%B0%EC%9D%B4%ED%84%B0_%ED%98%95%EC%8B%9D\"><\/span><strong>User-defined(\uc0ac\uc6a9\uc790 \uc815\uc758) \ub370\uc774\ud130 \ud615\uc2dd<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>\uc0ac\uc6a9\uc790 \uc815\uc758 \uc790\ub8cc\ud615\uc744 \uc120\uc5b8\ud558\uace0 \uc0ac\uc6a9\ud560 \uc218 \uc788\ub2e4. C\uc5b8\uc5b4\uc758 &#8216;struct&#8217;\uc640 \ube44\uc2b7\ud55c &#8216;Type&#8217; keyword\ub85c \uc0ac\uc6a9\uc790 \uc815\uc758 \uc790\ub8cc\ud615\uc744 \uc120\uc5b8\ud55c\ub2e4. User-defined \ub370\uc774\ud130 \ud615\uc2dd\uc740 \uac1c\uccb4\uac00 \uc544\ub2c8\ub77c\uc11c \uc120\uc5b8\ud558\uba74 \ubc14\ub85c instance\uac00 \uc0dd\uc131\ub418\uc5b4 \uba54\ubaa8\ub9ac\uac00 \ud560\ub2f9\ub418\uace0 \uac12\uc744 \uc785\ub825\ud560 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<p>User-defined \ub370\uc774\ud130 \ud615\uc2dd\uc5d0 \ub300\ud55c \uc790\uc138\ud55c \ub0b4\uc6a9\uc740 \uc544\ub798 URL\uc744 \ucc38\uace0\ud558\uae30 \ubc14\ub780\ub2e4.<\/p>\n\n\n\n<p><a href=\"https:\/\/docs.microsoft.com\/en-us\/office\/vba\/language\/how-to\/user-defined-data-type\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/docs.microsoft.com\/en-us\/office\/vba\/language\/how-to\/user-defined-data-type<\/a><\/p>\n\n\n\n<p>User-defined \ub370\uc774\ud130 \ud615\uc2dd\uc758 \uc608\uc2dc \ucf54\ub4dc\ub294 \ub2e4\uc74c\uacfc \uac19\ub2e4.<\/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=\"\">Type EmployeeRecord    ' \uc0ac\uc6a9\uc790 \uc815\uc758 \ud615\uc2dd\uc744 \ub9cc\ub4ed\ub2c8\ub2e4.\n    ID As Integer    ' \ub370\uc774\ud130 \ud615\uc2dd\uc758 \uc694\uc18c\ub97c \uc815\uc758\ud569\ub2c8\ub2e4.\n    Name As String\n    Address As String\n    Phone As Long\n    HireDate As Date\nEnd Type\n\nSub CreateRecord()\n    Dim MyRecord As EmployeeRecord    ' \ubcc0\uc218\ub97c \uc120\uc5b8\ud569\ub2c8\ub2e4.\n    MyRecord.ID = 12003    ' \uc694\uc18c\uc5d0 \uac12\uc744 \ud560\ub2f9\ud569\ub2c8\ub2e4.\n    MyRecord.Name = \"Andy\"\n    MyRecord.HireDate = CDate(\"2021-07-31\")\nEnd Sub<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"3.3.2._\uc790\ub8cc\uad6c\uc870\"><span class=\"ez-toc-section\" id=\"332_%EC%9E%90%EB%A3%8C%EA%B5%AC%EC%A1%B0\"><\/span>3.3.2. \uc790\ub8cc\uad6c\uc870<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>\uc790\uc8fc \uc0ac\uc6a9\ud558\ub294 \uc790\ub8cc\uad6c\uc870\ub294 Array, Collection, Dictionary\uac00 \uc788\ub2e4. \uac01\uac01\uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf4\uc790.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"Array\"><span class=\"ez-toc-section\" id=\"Array\"><\/span><strong>Array<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>\uace0\uc815 \uac1c\uc218\uc758 Item\uc744 \uac00\uc9c4\ub2e4. \uac1c\uccb4\uac00 \uc544\ub2c8\ub77c\uc11c \uc120\uc5b8\ud558\uba74 instance\uac00 \uc0dd\uc131\ub41c\ub2e4. \uc120\uc5b8\ud560 \ub54c \ucc28\uc6d0\uc758 \uc218\uc640 \uac01 \ucc28\uc6d0\uc758 \ud558\ud55c, \uc0c1\ud55c \ubc94\uc704\ub97c \uc9c0\uc815\ud560 \uc218\ub3c4 \uc788\uace0, \uc2e4\ud589\uc2dc\uc5d0 \ub3d9\uc801\uc73c\ub85c \ubc30\uc5f4\uc758 \ucc28\uc6d0, \ubc94\uc704\ub97c \ubcc0\uacbd\ud560 \uc218\ub3c4 \uc788\ub2e4. \uac01 \ucc28\uc6d0\uc758 \ud558\ud55c\uacfc \uc0c1\ud55c\uc744 \uc9c0\uc815\ud558\uc9c0 \uc54a\uace0 item\uc758 \uac1c\uc218\ub9cc \uc9c0\uc815\ud560 \uacbd\uc6b0 \uae30\ubcf8\uc801\uc73c\ub85c \ud558\ud55c\uc740 0\uc774\ub2e4. Option Base 1\uc744 \uc0ac\uc6a9\ud558\uba74 \uae30\ubcf8 \ud558\ud55c\uc740 1\uc774 \ub41c\ub2e4.<\/p>\n\n\n\n<p>\uc120\uc5b8 \uc608\uc2dc \ucf54\ub4dc<\/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=\"\">Dim DayArray(50)\nDim Matrix(3, 4) As Integer\nDim MyMatrix(1 To 5, 4 To 9, 3 To 5) As Double<\/pre>\n\n\n\n<p>\uac01 \ucc28\uc6d0 \ud558\ud55c\uac12\/\uc0c1\ud55c\uac12 \uc120\uc5b8, \ud655\uc778: LBound, UBound \uc0ac\uc6a9<\/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=\"\">Dim A(1 To 100, 0 To 3, -3 To 4) \nLBound(A, 1) ->  1,  UBound(A, 1) -> 100 ' 1\ucc28\uc6d0 \ud558\ud55c\/\uc0c1\ud55c\nLBound(A, 2) ->  0,  UBound(A, 2) -> 3   ' 2\ucc28\uc6d0 \ud558\ud55c\/\uc0c1\ud55c\nLBound(A, 3) -> -3,  UBound(A, 3) -> 4   ' 3\ucc28\uc6d0 \ud558\ud55c\/\uc0c1\ud55c<\/pre>\n\n\n\n<p><\/p>\n\n\n\n<p>\ucc28\uc6d0 \ud06c\uae30 \ubcc0\uacbd: Redim \ubb38\uc73c\ub85c \ub3d9\uc801 \ubc30\uc5f4\uc758 \ucc28\uc6d0 \ud06c\uae30\ub97c \ubcc0\uacbd\ud55c\ub2e4.<\/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=\"\">Dim MyArray() As Integer ' \ub3d9\uc801 \ubc30\uc5f4\uc744 \uc120\uc5b8\ud569\ub2c8\ub2e4. \nRedim MyArray(5) ' 5\uac1c\uc758 \uc694\uc18c\ub97c \ud560\ub2f9\ud569\ub2c8\ub2e4. \nRedim Preserve MyArray(15) ' 15\uac1c\uc758 \uc694\uc18c\ub85c \ud06c\uae30\ub97c \ubcc0\uacbd\ud569\ub2c8\ub2e4.<\/pre>\n\n\n\n<p>Item Loop(For Next)<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"visualbasic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"5-7\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">'Split &amp; Trim \ucc98\ub9ac\nPublic Function SplitTrim(aExpression As String, aDelimeter As String) As String()\n    Dim saOut() As String, i As Integer\n    saOut = Split(aExpression, aDelimeter)\n    For i = LBound(saOut) To UBound(saOut)\n        saOut(i) = Trim(saOut(i))\n    Next i\n\n    SplitTrim = saOut\nEnd Function<\/pre>\n\n\n\n<p>\ucd08\uae30\ud654:&nbsp;Erase \ubb38\uc73c\ub85c \ubc30\uc5f4 \ubcc0\uc218\ub97c \ucd08\uae30\ud654\ud55c\ub2e4.<\/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=\"\">' \ubc30\uc5f4 \ubcc0\uc218\ub97c \uc120\uc5b8\ud569\ub2c8\ub2e4.\nDim NumArray(10) As Integer    ' \uc815\uc218 \ubc30\uc5f4\uc785\ub2c8\ub2e4.\nDim StrVarArray(10) As String    ' \ubcc0\uc218 \ubb38\uc790\uc5f4 \ubc30\uc5f4\uc785\ub2c8\ub2e4.\nDim StrFixArray(10) As String * 10    ' \uace0\uc815 \ubb38\uc790\uc5f4 \ubc30\uc5f4\uc785\ub2c8\ub2e4.\nDim VarArray(10) As Variant    ' Variant \ubc30\uc5f4\uc785\ub2c8\ub2e4.\nDim DynamicArray() As Integer    ' \ub3d9\uc801 \ubc30\uc5f4\uc785\ub2c8\ub2e4.\nReDim DynamicArray(10)    ' \uc800\uc7a5 \uacf5\uac04\uc744 \ud560\ub2f9\ud569\ub2c8\ub2e4.\nErase NumArray    ' 0\uc73c\ub85c \uc9c0\uc815\ub41c \uac01 \uc694\uc18c\uc785\ub2c8\ub2e4.\nErase StrVarArray    ' \uae38\uc774\uac00 0\uc778 \ubb38\uc790\uc5f4 (\"\")\ub85c \uc9c0\uc815\ub41c \uac01 \uc694\uc18c\uc785\ub2c8\ub2e4.    \nErase StrFixArray    ' 0\uc73c\ub85c \uc9c0\uc815\ub41c \uac01 \uc694\uc18c\uc785\ub2c8\ub2e4.\nErase VarArray    ' Empty\ub85c \uc9c0\uc815\ub41c \uac01 \uc694\uc18c\uc785\ub2c8\ub2e4.\nErase DynamicArray    ' \ubc30\uc5f4\uc5d0 \uc758\ud574 \uc0ac\uc6a9\ub418\ub294 \ube48 \uba54\ubaa8\ub9ac\uc785\ub2c8\ub2e4.<\/pre>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"Collection\"><span class=\"ez-toc-section\" id=\"Collection\"><\/span><strong>Collection<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>Collection class\ub294 \ub3d9\uc801 \ubc30\uc5f4(Array)\uacfc \uc720\uc0ac\ud558\ub2e4. \uac00\ubcc0 \uac2f\uc218\uc758 unique item\uc744 Add, Remove\ud560 \uc218 \uc788\ub2e4. \uac1c\uccb4\uc774\uae30 \ub54c\ubb38\uc5d0 &#8220;<a href=\"https:\/\/docs.microsoft.com\/en-us\/office\/vba\/language\/reference\/user-interface-help\/set-statement\" target=\"_blank\" rel=\"noreferrer noopener\">Set<\/a>&#8221; \uacfc &#8220;New&#8221;\ud0a4\uc6cc\ub4dc\ub97c \uc774\uc6a9\ud558\uc5ec instance\ub97c \uc0dd\uc131\ud55c\ub2e4. Visual Basic \uc5b8\uc5b4\uc5d0\uc11c \uac1c\uccb4\uc5d0 reference\ub97c \uc0dd\uc131\ud558\uac70\ub098 \uc0c8\ub85c\uc6b4 reference\ub97c \ud560\ub2f9\ud560 \ub54c\ub294 \uaf2d &#8220;<a href=\"https:\/\/docs.microsoft.com\/en-us\/office\/vba\/language\/reference\/user-interface-help\/set-statement\" target=\"_blank\" rel=\"noreferrer noopener\">Set<\/a>&#8221; keyword\ub97c \uc0ac\uc6a9\ud574\uc57c \ud558\uace0, \ubcc0\uc218\uc5d0 \uac12\uc744 \ud560\ub2f9\ud560 \ub54c\ub294 &#8220;Set&#8221; keyword\uac00 \ud544\uc694\uc5c6\ub2e4. \uac1c\uccb4\ub97c \ub2e4\ub8f0 \ub54c\uc640 \ubcc0\uc218\ub97c \ub2e4\ub8f0 \ub54c\ub97c \uc798 \uad6c\ubd84\ud574\uc57c \ubb38\ubc95 \uc624\ub958\uac00 \ubc1c\uc0dd\ud558\uc9c0 \uc54a\ub294\ub2e4. \uc790\uc8fc \uc2e4\uc218\ud560 \uc218 \uc788\uc73c\ub2c8 \uc8fc\uc758\uac00 \ud544\uc694\ud558\ub2e4.<\/p>\n\n\n\n<p>Collection \uac1c\uccb4 \uc120\uc5b8, instance \uc0dd\uc131, Item \ucd94\uac00 \ub4f1\uc758 \uc791\uc5c5\ubcc4 \ucf54\ub4dc\ub294 \uc544\ub798 \ud45c\ub97c \ucc38\uace0\ud55c\ub2e4.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td><strong>Task<\/strong><\/td><td><strong>Sample Code<\/strong><\/td><\/tr><tr><td>\uc120\uc5b8<\/td><td>Dim&nbsp;oCol&nbsp;As&nbsp;Collection<\/td><\/tr><tr><td>Instance&nbsp;\uc0dd\uc131<\/td><td>Set&nbsp;oCol&nbsp;=&nbsp;New&nbsp;Collection<\/td><\/tr><tr><td>\uc120\uc5b8\uacfc \ub3d9\uc2dc\uc5d0&nbsp;Instance&nbsp;\uc0dd\uc131<\/td><td>Dim&nbsp;oCol&nbsp;As New&nbsp;Collection<\/td><\/tr><tr><td>Item&nbsp;\ucd94\uac00<\/td><td>oCol.Add&nbsp;&#8220;Apple&#8221;<\/td><\/tr><tr><td>Index\ub85c&nbsp;Item&nbsp;\uc811\uadfc<\/td><td>oCol(1)<\/td><\/tr><tr><td>Item&nbsp;\uac1c\uc218<\/td><td>oCol.Count<\/td><\/tr><tr><td>Item&nbsp;Loop (For)<\/td><td>Dim&nbsp;l&nbsp;As&nbsp;Long<br>For&nbsp;l = 1&nbsp;to&nbsp;oCol.Count<br>&nbsp;&nbsp;&nbsp;&nbsp;Debug.Print&nbsp;oCol(l)<br>Next<\/td><\/tr><tr><td>Item Loop (For Each)<\/td><td>Dim&nbsp;fruit&nbsp;As&nbsp;Variant<br>For Each&nbsp;fruit in&nbsp;oCol<br>&nbsp;&nbsp;&nbsp;&nbsp;Debug.Print&nbsp;fruit<br>Next<\/td><\/tr><tr><td>Item&nbsp;\uc81c\uac70&nbsp;(Index&nbsp;\uc9c0\uc815)<\/td><td>oCol.Remove(1)<\/td><\/tr><tr><td>Instance&nbsp;\uc81c\uac70<\/td><td>Set&nbsp;oCol&nbsp;=&nbsp;Nothing<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>Collection \uc744 \uc0ac\uc6a9\ud558\ub294 \uc608\uc2dc \ucf54\ub4dc\ub294 \ub2e4\uc74c\uacfc \uac19\ub2e4. \ucc38\uace0\ub85c Collection\uc758 Item\uc740 1\ubd80\ud130 \uc2dc\uc791\ud55c\ub2e4.<\/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=\"\">Sub CollectionTest()\n    Dim oCol As Collection\n    Set oCol = New Collection\n    \n    oCol.Add \"Apple\"\n    oCol.Add \"Strawberry\"\n    oCol.Add \"Lemon\"\n    oCol.Add \"Banana\"\n    \n    Debug.Print oCol(1)\n    Debug.Print oCol.Item(1)\n    Debug.Print \"----------\"\n\n    Dim l As Long\n    For l = 1 To oCol.Count\n        Debug.Print oCol(l)\n    Next\n\n    Debug.Print \"----------\"\n\n    oCol.Remove (1)\n\n    Dim fruit As Variant\n    For Each fruit In oCol\n        Debug.Print fruit\n    Next\n\n    Set oCol = Nothing\nEnd Sub\n\n'\ucd9c\ub825\nApple\nApple\n----------\nApple\nStrawberry\nLemon\nBanana\n----------\nStrawberry\nLemon\nBanana<\/pre>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"Dictionary\"><span class=\"ez-toc-section\" id=\"Dictionary\"><\/span><strong>Dictionary<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>Key-Value \uad6c\uc870\uc758 \uac00\ubcc0 unique Item\uc744 \uad00\ub9ac\ud560 \uc218 \uc788\uace0, item\uc744 \ub3d9\uc801\uc73c\ub85c Add\/Remove \ud560 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<p>Python \uc5b8\uc5b4\uc758 Dictionary, C++\uc758 HashMap, Java\uc758 HashMap\uacfc \uc720\uc0ac\ud55c \uc790\ub8cc\uad6c\uc870\uc774\ub2e4. Key\uac12\uc73c\ub85c \uc811\uadfc\ud560 \ub54c \uc131\ub2a5\uc740 O(1) \uc218\uc900\uc774\ub2e4.<\/p>\n\n\n\n<p>Dictionary class\ub294 \uae30\ubcf8\uc73c\ub85c \uc81c\uacf5\ub418\uc9c0 \uc54a\ub294\ub2e4. Early binding \ubc29\uc2dd\uc73c\ub85c \uc0ac\uc6a9\ud558\ub824\uba74 \uba3c\uc800 \u201cMicrosoft Scripting Runtime\u201d\uc744 \ucc38\uc870\ud574\uc57c \ud55c\ub2e4. Late binding \ubc29\uc2dd\uc73c\ub85c \uc0ac\uc6a9\ud558\ub824\uba74 CreateObject\ub97c \ud1b5\ud574 instance\ub97c \uc0dd\uc131\ud558\uace0 \uc0ac\uc6a9\ud55c\ub2e4.<\/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-95.png\"><img loading=\"lazy\" decoding=\"async\" width=\"524\" height=\"338\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-95.png\" alt=\"Dictionary class \uc0ac\uc6a9\uc744 \uc704\ud55c &quot;Microsoft Scripting Runtime&quot; \ucc38\uc870 \ucd94\uac00\" class=\"wp-image-11388\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-95.png 524w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-95-300x194.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-95-18x12.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-95-24x15.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-95-36x23.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-95-48x31.png 48w\" sizes=\"auto, (max-width: 524px) 100vw, 524px\" \/><\/a><figcaption>Dictionary class \uc0ac\uc6a9\uc744 \uc704\ud55c &#8220;Microsoft Scripting Runtime&#8221; \ucc38\uc870 \ucd94\uac00<\/figcaption><\/figure>\n<\/div>\n\n\n<p>Dictionary \uac1c\uccb4 \uc120\uc5b8, instance \uc0dd\uc131, Item \ucd94\uac00 \ub4f1\uc758 \uc791\uc5c5\ubcc4 \ucf54\ub4dc\ub294 \uc544\ub798 \ud45c\ub97c \ucc38\uace0\ud55c\ub2e4.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td><strong>Task<\/strong><\/td><td><strong>Sample Code<\/strong><\/td><\/tr><tr><td>\uc120\uc5b8&nbsp;(early&nbsp;binding)<\/td><td>Dim&nbsp;oDic&nbsp;As&nbsp;Dictionary<\/td><\/tr><tr><td>Instance&nbsp;\uc0dd\uc131&nbsp;(early&nbsp;binding)<\/td><td>Set&nbsp;oDic&nbsp;=&nbsp;New&nbsp;Dictionary<\/td><\/tr><tr><td>\uc120\uc5b8&nbsp;(late&nbsp;binding)<\/td><td>Dim&nbsp;oDic&nbsp;As Object<\/td><\/tr><tr><td>Instance&nbsp;\uc0dd\uc131&nbsp;(late&nbsp;binding)<\/td><td>Set&nbsp;oDic&nbsp;=&nbsp;CreateObject(&#8220;Scripting.Dictionary&#8221;)<\/td><\/tr><tr><td>Item&nbsp;\ucd94\uac00<\/td><td>oDic.Add&nbsp;&#8220;Apples&#8221;, 50<\/td><\/tr><tr><td>Value&nbsp;\ubcc0\uacbd<\/td><td>oDic(&#8220;Apples&#8221;) = 60<\/td><\/tr><tr><td>Value&nbsp;\uc5bb\uae30<\/td><td>appleCount&nbsp;=&nbsp;oDic(&#8220;Apples&#8221;)<\/td><\/tr><tr><td>Key\uac00 \uc874\uc7ac\ud558\ub294\uc9c0 \ud655\uc778<\/td><td>oDic.Exists(&#8220;Apples&#8221;)<\/td><\/tr><tr><td>Item&nbsp;\uc0ad\uc81c<\/td><td>oDic.Remove(&#8220;Apples&#8221;)<\/td><\/tr><tr><td>\ubaa8\ub4e0&nbsp;Item&nbsp;\uc0ad\uc81c<\/td><td>oDic.RemoveAll<\/td><\/tr><tr><td>Item&nbsp;\uac1c\uc218<\/td><td>oDic.Count<\/td><\/tr><tr><td>Item Loop (For Each)<\/td><td>Dim&nbsp;key&nbsp;As&nbsp;Variant<br>For Each&nbsp;key in&nbsp;oDic.Keys<br>&nbsp;&nbsp;&nbsp;&nbsp;Debug.Print&nbsp;key,&nbsp;oDic(key)<br>Next&nbsp;key<\/td><\/tr><tr><td>Item Loop (For,&nbsp;Early binding only)<\/td><td>Dim&nbsp;l&nbsp;As&nbsp;Long<br>For&nbsp;l = 0&nbsp;To&nbsp;oDic.Count&nbsp;-1<br>&nbsp;&nbsp;&nbsp;&nbsp;Debug.Print&nbsp;oDic.Keys(l),&nbsp;oDic.Items(l)<br>Next&nbsp;l<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>Dictionary\ub97c \uc0ac\uc6a9\ud558\ub294 \uc608\uc2dc \ucf54\ub4dc\ub294 \ub2e4\uc74c\uacfc \uac19\ub2e4. \ucc38\uace0\ub85c Dictionary\uc758 Items\ub294 0\ubd80\ud130 \uc2dc\uc791\ud55c\ub2e4.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"visualbasic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"23-24\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">Sub DictionaryTest()\n    Dim oDic As Dictionary\n    Set oDic = New Dictionary\n\n    oDic.Add \"A\", \"Apple\"\n    oDic.Add \"S\", \"Strawberry\"\n    oDic.Add \"L\", \"Lemon\"\n    oDic.Add \"B\", \"Banana\"\n\n    Debug.Print oDic(\"A\")\n    Debug.Print oDic.Items(0)\n    Debug.Print \"----------\"\n\n    Dim l As Long\n    For l = 0 To oDic.Count - 1\n        Debug.Print oDic.Items(l)\n    Next\n    \n    Debug.Print \"----------\"\n    \n    oDic.Remove (\"A\")\n\n    Dim key As Variant, fruit As String\n    For Each key In oDic.Keys\n        fruit = oDic(key)\n        Debug.Print fruit\n    Next\n\n    Set oDic = Nothing\nEnd Sub\n\n'\ucd9c\ub825\nApple\nApple\n----------\nApple\nStrawberry\nLemon\nBanana\n----------\nStrawberry\nLemon\nBanana<\/pre>\n\n\n\n<p>Dictionary \uac1c\uccb4\ub97c For Loop \uad6c\ubb38\uc73c\ub85c \ud0d0\uc0c9\ud560 \ub54c key\uac12\uc744 \ub2f4\uc744 \ubcc0\uc218\ub294 Variant \ub610\ub294 Object \ud615\uc2dd\ub9cc \uac00\ub2a5\ud558\ub2e4. \uc704 \uc608\uc2dc\uc5d0\uc11c&nbsp;23, 24 \ud589\uc758 \ucf54\ub4dc\uc5d0\uc11c\ub294 Variant \ud615\uc2dd\uc744 \uc0ac\uc6a9\ud588\ub2e4.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p>\uc774\ubc88 \uae00\uc5d0\uc11c\ub294 VBA \ub370\uc774\ud130 \ud615\uc2dd\uacfc \uc790\ub8cc\uad6c\uc870\uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf4\uc558\ub2e4. \ud2b9\ud788 Collection\uacfc Dictionary\ub294 \uc790\uc8fc \uc0ac\uc6a9\ud560 \uac00\ub2a5\uc131\uc774 \ub9e4\uc6b0 \ub192\uae30 \ub54c\ubb38\uc5d0, \uc798 \uc775\ud600 \ub450\uae30 \ubc14\ub780\ub2e4. \ub2e4\uc74c\uc5d0\ub294 VBA \ucf54\ub529\uc2dc \uc54c\uc544\ub450\uba74 \uc88b\uc740 How-To\uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf4\uaca0\ub2e4.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p><strong>&lt;&lt;&nbsp;\uad00\ub828 \uae00 \ubaa9\ub85d&nbsp;&gt;&gt;<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/prodskill.com\/excel-vba-lecture-preface\/\">\uc5d1\uc140 VBA \uac15\uc88c\ub97c \uc2dc\uc791\ud569\ub2c8\ub2e4. (\uac15\uc88c\uc608\uace0, feat.\uc5d1\uc140 VBA\ub97c \uad8c\uc7a5\ud558\ub294 \uc774\uc720)<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/excel-vba-lecture-1-overview\/\">\uc5d1\uc140 VBA \uac15\uc88c(1): \uc5d1\uc140 VBA \uac1c\uc694<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/excel-vba-lecture-2-basic\/\">\uc5d1\uc140 VBA \uac15\uc88c(2): \uc5d1\uc140 VBA \uae30\ucd08<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/excel-vba-lecture-3-object-model\/\">\uc5d1\uc140 VBA \uac15\uc88c(3): \uc5d1\uc140 Object Model<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/excel-vba-lecture-4-handling-object-model\/\">\uc5d1\uc140 VBA \uac15\uc88c(4): \uc5d1\uc140 Object Model \ub2e4\ub8e8\uae30<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/excel-vba-lecture-5-excel-file-extension-vbe-font\/\">\uc5d1\uc140 VBA \uac15\uc88c(5): \uc5d1\uc140 \ud30c\uc77c \ud655\uc7a5\uc790, VBE, \uae00\uaf34 \uc124\uc815<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/excel-vba-lecture-6-variable\/\">\uc5d1\uc140 VBA \uac15\uc88c(6): \uc5d1\uc140 VBA \uc5b8\uc5b4 \uae30\ubcf8-\ubcc0\uc218<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/excel-vba-lecture-7-syntax\/\">\uc5d1\uc140 VBA \uac15\uc88c(7): \uc5d1\uc140 VBA \uc5b8\uc5b4 \uae30\ubcf8-\ubb38\ubc95(Syntax)<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/excel-vba-lecture-8-datatype\/\">\uc5d1\uc140 VBA \uac15\uc88c(8): \uc5d1\uc140 VBA \uc5b8\uc5b4 \uae30\ubcf8-\uc790\ub8cc\ud615(Data type), \uc790\ub8cc\uad6c\uc870(Data structure)<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/excel-vba-lecture-9-how-to\/\">\uc5d1\uc140 VBA \uac15\uc88c(9): \uc5d1\uc140 VBA How-To<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/excel-vba-lecture-10-self-developed-tools\/\">\uc5d1\uc140 VBA \uac15\uc88c(10): \uc5d1\uc140 VBA\ub85c \uac1c\ubc1c\ud558\uc5ec \uc0ac\uc6a9\uc911\uc778 \ub3c4\uad6c<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/excel-vba-lecture-toc\/\">\uc5d1\uc140 VBA \uac15\uc88c \uc804\uccb4 \ubaa9\ucc28<\/a><\/li><\/ul>\n","protected":false},"excerpt":{"rendered":"<p>\uc774\ubc88 \uae00\uc740 \uc5d1\uc140 VBA \uc5b8\uc5b4 \uae30\ubcf8 \uc911 \uc790\ub8cc\ud615(Data type)\uacfc \uc81c\uacf5\ub418\ub294 \uc790\ub8cc\uad6c\uc870(Data structure)\uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf8\ub2e4. \uc774\uc804&nbsp;\uae00\uc5d0\uc11c&nbsp;\uc774\uc5b4\uc9c0\ub294&nbsp;\ub0b4\uc6a9\uc774\ub2e4. \uc5d1\uc140 VBA \uac15\uc88c(7): \uc5d1\uc140 VBA \uc5b8\uc5b4 \uae30\ubcf8-\ubb38\ubc95(Syntax) 3.3. \uc790\ub8cc\ud615 3.3.1. \uae30\ubcf8 \uc790\ub8cc\ud615 VB(\ub610\ub294 VBA)\uc5d0\uc11c \uc9c0\uc6d0\ud558\ub294 \uc790\ub8cc\ud615\uc744 \uc694\uc57d\ud558\uba74 \ub2e4\uc74c \ud45c\uc640 \uac19\ub2e4. \uc544\ub798 \ucd9c\ucc98\uc758 \ud45c \ub0b4\uc6a9\uc911 Collection,&#46;&#46;&#46;<\/p>\n","protected":false},"author":1,"featured_media":11388,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28],"tags":[17],"class_list":["post-11386","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(8): \uc5d1\uc140 VBA \uc5b8\uc5b4 \uae30\ubcf8-\uc790\ub8cc\ud615(Data type), \uc790\ub8cc\uad6c\uc870(Data structure) - \uc0dd\uc0b0\uc131 Skill<\/title>\n<meta name=\"description\" content=\"\uc5d1\uc140 VBA \uc5b8\uc5b4 \uae30\ubcf8 \uc911 \uc790\ub8cc\ud615(Data type)\uacfc \uc81c\uacf5\ub418\ub294 \uc790\ub8cc\uad6c\uc870(Data structure)\uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf8\ub2e4. Variant, User-defined \ub370\uc774\ud130 \ud615\uc2dd\uacfc Array, Collection, Dictionary\uc5d0 \ub300\ud574 \ud655\uc778\ud560 \uc218 \uc788\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\/ko\/excel-vba-lecture-8-datatype\/\" \/>\n<meta property=\"og:locale\" content=\"ko_KR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\uc5d1\uc140 VBA \uac15\uc88c(8): \uc5d1\uc140 VBA \uc5b8\uc5b4 \uae30\ubcf8-\uc790\ub8cc\ud615(Data type), \uc790\ub8cc\uad6c\uc870(Data structure) - \uc0dd\uc0b0\uc131 Skill\" \/>\n<meta property=\"og:description\" content=\"\uc5d1\uc140 VBA \uc5b8\uc5b4 \uae30\ubcf8 \uc911 \uc790\ub8cc\ud615(Data type)\uacfc \uc81c\uacf5\ub418\ub294 \uc790\ub8cc\uad6c\uc870(Data structure)\uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf8\ub2e4. Variant, User-defined \ub370\uc774\ud130 \ud615\uc2dd\uacfc Array, Collection, Dictionary\uc5d0 \ub300\ud574 \ud655\uc778\ud560 \uc218 \uc788\ub2e4.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/prodskill.com\/ko\/excel-vba-lecture-8-datatype\/\" \/>\n<meta property=\"og:site_name\" content=\"\uc0dd\uc0b0\uc131 Skill\" \/>\n<meta property=\"article:published_time\" content=\"2022-09-11T09:29:45+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-10-11T02:42:21+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-95.png\" \/>\n\t<meta property=\"og:image:width\" content=\"524\" \/>\n\t<meta property=\"og:image:height\" content=\"338\" \/>\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=\"\uae00\uc4f4\uc774\" \/>\n\t<meta name=\"twitter:data1\" content=\"Zerom\" \/>\n\t<meta name=\"twitter:label2\" content=\"\uc608\uc0c1 \ub418\ub294 \ud310\ub3c5 \uc2dc\uac04\" \/>\n\t<meta name=\"twitter:data2\" content=\"9\ubd84\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-lecture-8-datatype\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-lecture-8-datatype\\\/\"},\"author\":{\"name\":\"Zerom\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#\\\/schema\\\/person\\\/bbad0870c78008c82edbe0960fe768bd\"},\"headline\":\"\uc5d1\uc140 VBA \uac15\uc88c(8): \uc5d1\uc140 VBA \uc5b8\uc5b4 \uae30\ubcf8-\uc790\ub8cc\ud615(Data type), \uc790\ub8cc\uad6c\uc870(Data structure)\",\"datePublished\":\"2022-09-11T09:29:45+00:00\",\"dateModified\":\"2022-10-11T02:42:21+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-lecture-8-datatype\\\/\"},\"wordCount\":763,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#\\\/schema\\\/person\\\/bbad0870c78008c82edbe0960fe768bd\"},\"image\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-lecture-8-datatype\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/image-95.png\",\"keywords\":[\"\uc5d1\uc140VBA\"],\"articleSection\":[\"\uc5d1\uc140 VBA \uac15\uc88c\"],\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/prodskill.com\\\/excel-vba-lecture-8-datatype\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-lecture-8-datatype\\\/\",\"url\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-lecture-8-datatype\\\/\",\"name\":\"\uc5d1\uc140 VBA \uac15\uc88c(8): \uc5d1\uc140 VBA \uc5b8\uc5b4 \uae30\ubcf8-\uc790\ub8cc\ud615(Data type), \uc790\ub8cc\uad6c\uc870(Data structure) - \uc0dd\uc0b0\uc131 Skill\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-lecture-8-datatype\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-lecture-8-datatype\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/image-95.png\",\"datePublished\":\"2022-09-11T09:29:45+00:00\",\"dateModified\":\"2022-10-11T02:42:21+00:00\",\"description\":\"\uc5d1\uc140 VBA \uc5b8\uc5b4 \uae30\ubcf8 \uc911 \uc790\ub8cc\ud615(Data type)\uacfc \uc81c\uacf5\ub418\ub294 \uc790\ub8cc\uad6c\uc870(Data structure)\uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf8\ub2e4. Variant, User-defined \ub370\uc774\ud130 \ud615\uc2dd\uacfc Array, Collection, Dictionary\uc5d0 \ub300\ud574 \ud655\uc778\ud560 \uc218 \uc788\ub2e4.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-lecture-8-datatype\\\/#breadcrumb\"},\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/prodskill.com\\\/excel-vba-lecture-8-datatype\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-lecture-8-datatype\\\/#primaryimage\",\"url\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/image-95.png\",\"contentUrl\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/image-95.png\",\"width\":524,\"height\":338},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-lecture-8-datatype\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\uc5d1\uc140 VBA \uac15\uc88c(8): \uc5d1\uc140 VBA \uc5b8\uc5b4 \uae30\ubcf8-\uc790\ub8cc\ud615(Data type), \uc790\ub8cc\uad6c\uc870(Data structure)\"}]},{\"@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\":\"ko-KR\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#\\\/schema\\\/person\\\/bbad0870c78008c82edbe0960fe768bd\",\"name\":\"Zerom\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@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\\\/ko\\\/author\\\/proda\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\uc5d1\uc140 VBA \uac15\uc88c(8): \uc5d1\uc140 VBA \uc5b8\uc5b4 \uae30\ubcf8-\uc790\ub8cc\ud615(Data type), \uc790\ub8cc\uad6c\uc870(Data structure) - \uc0dd\uc0b0\uc131 Skill","description":"\uc5d1\uc140 VBA \uc5b8\uc5b4 \uae30\ubcf8 \uc911 \uc790\ub8cc\ud615(Data type)\uacfc \uc81c\uacf5\ub418\ub294 \uc790\ub8cc\uad6c\uc870(Data structure)\uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf8\ub2e4. Variant, User-defined \ub370\uc774\ud130 \ud615\uc2dd\uacfc Array, Collection, Dictionary\uc5d0 \ub300\ud574 \ud655\uc778\ud560 \uc218 \uc788\ub2e4.","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\/ko\/excel-vba-lecture-8-datatype\/","og_locale":"ko_KR","og_type":"article","og_title":"\uc5d1\uc140 VBA \uac15\uc88c(8): \uc5d1\uc140 VBA \uc5b8\uc5b4 \uae30\ubcf8-\uc790\ub8cc\ud615(Data type), \uc790\ub8cc\uad6c\uc870(Data structure) - \uc0dd\uc0b0\uc131 Skill","og_description":"\uc5d1\uc140 VBA \uc5b8\uc5b4 \uae30\ubcf8 \uc911 \uc790\ub8cc\ud615(Data type)\uacfc \uc81c\uacf5\ub418\ub294 \uc790\ub8cc\uad6c\uc870(Data structure)\uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf8\ub2e4. Variant, User-defined \ub370\uc774\ud130 \ud615\uc2dd\uacfc Array, Collection, Dictionary\uc5d0 \ub300\ud574 \ud655\uc778\ud560 \uc218 \uc788\ub2e4.","og_url":"https:\/\/prodskill.com\/ko\/excel-vba-lecture-8-datatype\/","og_site_name":"\uc0dd\uc0b0\uc131 Skill","article_published_time":"2022-09-11T09:29:45+00:00","article_modified_time":"2022-10-11T02:42:21+00:00","og_image":[{"width":524,"height":338,"url":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-95.png","type":"image\/png"}],"author":"Zerom","twitter_card":"summary_large_image","twitter_misc":{"\uae00\uc4f4\uc774":"Zerom","\uc608\uc0c1 \ub418\ub294 \ud310\ub3c5 \uc2dc\uac04":"9\ubd84"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/prodskill.com\/excel-vba-lecture-8-datatype\/#article","isPartOf":{"@id":"https:\/\/prodskill.com\/excel-vba-lecture-8-datatype\/"},"author":{"name":"Zerom","@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd"},"headline":"\uc5d1\uc140 VBA \uac15\uc88c(8): \uc5d1\uc140 VBA \uc5b8\uc5b4 \uae30\ubcf8-\uc790\ub8cc\ud615(Data type), \uc790\ub8cc\uad6c\uc870(Data structure)","datePublished":"2022-09-11T09:29:45+00:00","dateModified":"2022-10-11T02:42:21+00:00","mainEntityOfPage":{"@id":"https:\/\/prodskill.com\/excel-vba-lecture-8-datatype\/"},"wordCount":763,"commentCount":0,"publisher":{"@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd"},"image":{"@id":"https:\/\/prodskill.com\/excel-vba-lecture-8-datatype\/#primaryimage"},"thumbnailUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-95.png","keywords":["\uc5d1\uc140VBA"],"articleSection":["\uc5d1\uc140 VBA \uac15\uc88c"],"inLanguage":"ko-KR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/prodskill.com\/excel-vba-lecture-8-datatype\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/prodskill.com\/excel-vba-lecture-8-datatype\/","url":"https:\/\/prodskill.com\/excel-vba-lecture-8-datatype\/","name":"\uc5d1\uc140 VBA \uac15\uc88c(8): \uc5d1\uc140 VBA \uc5b8\uc5b4 \uae30\ubcf8-\uc790\ub8cc\ud615(Data type), \uc790\ub8cc\uad6c\uc870(Data structure) - \uc0dd\uc0b0\uc131 Skill","isPartOf":{"@id":"https:\/\/prodskill.com\/ko\/#website"},"primaryImageOfPage":{"@id":"https:\/\/prodskill.com\/excel-vba-lecture-8-datatype\/#primaryimage"},"image":{"@id":"https:\/\/prodskill.com\/excel-vba-lecture-8-datatype\/#primaryimage"},"thumbnailUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-95.png","datePublished":"2022-09-11T09:29:45+00:00","dateModified":"2022-10-11T02:42:21+00:00","description":"\uc5d1\uc140 VBA \uc5b8\uc5b4 \uae30\ubcf8 \uc911 \uc790\ub8cc\ud615(Data type)\uacfc \uc81c\uacf5\ub418\ub294 \uc790\ub8cc\uad6c\uc870(Data structure)\uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf8\ub2e4. Variant, User-defined \ub370\uc774\ud130 \ud615\uc2dd\uacfc Array, Collection, Dictionary\uc5d0 \ub300\ud574 \ud655\uc778\ud560 \uc218 \uc788\ub2e4.","breadcrumb":{"@id":"https:\/\/prodskill.com\/excel-vba-lecture-8-datatype\/#breadcrumb"},"inLanguage":"ko-KR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/prodskill.com\/excel-vba-lecture-8-datatype\/"]}]},{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/prodskill.com\/excel-vba-lecture-8-datatype\/#primaryimage","url":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-95.png","contentUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-95.png","width":524,"height":338},{"@type":"BreadcrumbList","@id":"https:\/\/prodskill.com\/excel-vba-lecture-8-datatype\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/prodskill.com\/ko\/"},{"@type":"ListItem","position":2,"name":"\uc5d1\uc140 VBA \uac15\uc88c(8): \uc5d1\uc140 VBA \uc5b8\uc5b4 \uae30\ubcf8-\uc790\ub8cc\ud615(Data type), \uc790\ub8cc\uad6c\uc870(Data structure)"}]},{"@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":"ko-KR"},{"@type":["Person","Organization"],"@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd","name":"Zerom","image":{"@type":"ImageObject","inLanguage":"ko-KR","@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\/ko\/author\/proda\/"}]}},"_links":{"self":[{"href":"https:\/\/prodskill.com\/ko\/wp-json\/wp\/v2\/posts\/11386","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prodskill.com\/ko\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prodskill.com\/ko\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prodskill.com\/ko\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prodskill.com\/ko\/wp-json\/wp\/v2\/comments?post=11386"}],"version-history":[{"count":0,"href":"https:\/\/prodskill.com\/ko\/wp-json\/wp\/v2\/posts\/11386\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prodskill.com\/ko\/wp-json\/wp\/v2\/media\/11388"}],"wp:attachment":[{"href":"https:\/\/prodskill.com\/ko\/wp-json\/wp\/v2\/media?parent=11386"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prodskill.com\/ko\/wp-json\/wp\/v2\/categories?post=11386"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prodskill.com\/ko\/wp-json\/wp\/v2\/tags?post=11386"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}