{"id":991,"date":"2013-12-06T08:12:18","date_gmt":"2013-12-06T08:12:18","guid":{"rendered":"http:\/\/excelvbatutor.com\/?page_id=991"},"modified":"2019-04-19T07:32:58","modified_gmt":"2019-04-19T07:32:58","slug":"excel-vba-2010-lesson-3-array","status":"publish","type":"page","link":"https:\/\/excelvbatutor.com\/index.php\/excel-vba-2010-lesson-3-array\/","title":{"rendered":"Excel 2010 VBA Lesson 3: Array"},"content":{"rendered":"\n<h4 class=\"wp-block-heading\"><strong><a href=\"http:\/\/excelvbatutor.com\/index.php\/excel-vba-2010-lesson-2-data-types-constants-and-variables\/\">[Lesson 2]<\/a>&lt;&lt;<a title=\"excel vba 2010 tutorial\" href=\"http:\/\/excelvbatutor.com\/index.php\/excel-vba-2010-tutorial\/\">[Table of Contents]<\/a>&gt;&gt;<a href=\"http:\/\/excelvbatutor.com\/index.php\/excel-vba-2010-lesson-4\/\">[Lesson 4]<\/a><\/strong><\/h4>\n\n\n\n<h4 class=\"wp-block-heading\">3.1 Array in Excel 2010 VBA<\/h4>\n\n\n\n<p>When we work with a single item in Excel\u00a0\u00a0VBA\u00a0<g class=\"gr_ gr_9 gr-alert gr_gramm gr_inline_cards gr_run_anim Style multiReplace gr-progress\" id=\"9\" data-gr-id=\"9\">2010,<\/g> we only need to use one variable. However, if we need to deal with a list of items, we need to declare an array of variables instead of using a variable for each item. For example, if we need to enter 100 names, instead of declaring 100 different variables, we need to declare only one array.<\/p>\n\n\n\n<script async=\"\" src=\"\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js\"><\/script>\n<ins class=\"adsbygoogle\" style=\"display:block; text-align:center;\" data-ad-layout=\"in-article\" data-ad-format=\"fluid\" data-ad-client=\"ca-pub-3033628290023372\" data-ad-slot=\"9639157585\"><\/ins>\n<script>\n     (adsbygoogle = window.adsbygoogle || []).push({});\n<\/script>\n\n\n\n<p>By definition, an array is a group of variables with the same data type and name. We differentiate each item in the array by using subscript, the index value of each item. For example Studentname (1), Studentname (2), Studentname (3) &#8230;&#8230;..Studentname(n)\n\n\n\n<h3 class=\"wp-block-heading\">3.2 Declaring Arrays in Excel&nbsp; 2010 VBA<\/h3>\n\n\n\n<p>We use the Dim statement to declare an array just as the way we declare a single variable. In Excel&nbsp;2010 VBA&nbsp; we can have a one-dimensional array, two-dimensional array or even a multidimensional array (up to 60)<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">3.2(a) One Dimensional Array<\/h4>\n\n\n\n<p>The statement to declare a one-dimensional array in Excel 2010 VBA is as follows:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">Dim arrayName(index) as dataType or Dim arrayName(first index to last index) as dataType<\/pre>\n\n\n\n<p>For example,&nbsp; we can use the following statement to declare an array that comprises 10 elements.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">Dim StudentName(10) as String Dim StudentName(1 to 10) as String Dim StudentMark(10) as Single Dim StudentMark( 1 to 10) as Single<\/pre>\n\n\n\n<h4 class=\"wp-block-heading\">Example 3.1<\/h4>\n\n\n\n<p>In this example, we define an array StudentName of five strings using the Dim keyword. We include an InputBox to accept input from the user. We also use the For \u2026Next loop to accept the input five times and display the five names from cell A1 to cell E1. The code is as follows:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">Private Sub Button1_Click( )\nDim StudentName(1 to 5) As String\n For i = 1 To 5\n  StudentName(i) = InputBox(\u201cEnter student Name\u201d)\n  Cells(i, 1) = StudentName(i)\n Next\nEnd Sub\n<\/pre>\n\n\n\n<p><script async=\"\" src=\"\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js\"><\/script><br><ins class=\"adsbygoogle\" style=\"display: block; text-align: center;\" data-ad-layout=\"in-article\" data-ad-format=\"fluid\" data-ad-client=\"ca-pub-3033628290023372\" data-ad-slot=\"9639157585\"><\/ins><br><script><br \/>\n     (adsbygoogle = window.adsbygoogle || []).push({});<br \/>\n<\/script><\/p>\n\n\n\n<p>* You can also declare the array using Dim StudentName(5) As String When we run the program, an input box will appear, as shown below. This input box will repeat five times and let the user enter five names.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><a href=\"https:\/\/excelvbatutor.com\/wp-content\/uploads\/2013\/12\/vba2010_fig3.1.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"373\" height=\"159\" src=\"https:\/\/excelvbatutor.com\/wp-content\/uploads\/2013\/12\/vba2010_fig3.1.jpg\" alt=\"vba2010_fig3.1\" class=\"wp-image-1004\"\/><\/a><\/figure><\/div>\n\n\n\n<p> The five names will be displayed in the spreadsheet as shown below:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/excelvbatutor.com\/vba_img\/example21.1.2.jpg\" alt=\"\"\/><\/figure>\n\n\n\n<p><strong>Example 3.2<\/strong><\/p>\n\n\n\n<p>You can also declare more than one array on a single line. In this example, we declare three arrays in a single line, separated by commas.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">Private Sub CommandButton1_Click( )\nDim StudentName(3) As String, StudentID(3) As String, StudentMark(3) As Single\n For i = 1 To 3 StudentName(i) = InputBox(\u201cEnter student Name\u201d)\n  StudentID(i) = InputBox(\u201cEnter student ID\u201d)\n  StudentMark(i) = InputBox(\u201cEnter student Mark\u201d)\n  Cells(i, 1) = StudentName(i)\n  Cels(i, 2) = StudentID(i)\n  Cells(i, 3) = StudentMark(i)\n Next\nEnd Sub\n<\/pre>\n\n\n\n<p>When we run the program, three input boxes will appear consecutively to let the user enter the student name, the student ID and then the student mark. The process will repeat three times until the particulars of all three students have been entered. The three input boxes and the output images are shown below<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><a href=\"https:\/\/excelvbatutor.com\/wp-content\/uploads\/2013\/12\/vba2010_fig3.11.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"373\" height=\"159\" src=\"https:\/\/excelvbatutor.com\/wp-content\/uploads\/2013\/12\/vba2010_fig3.11.jpg\" alt=\"vba2010_fig3.1\" class=\"wp-image-1010\"\/><\/a><\/figure><\/div>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><a href=\"https:\/\/excelvbatutor.com\/wp-content\/uploads\/2013\/12\/vba2010_fig3.2.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"373\" height=\"159\" src=\"https:\/\/excelvbatutor.com\/wp-content\/uploads\/2013\/12\/vba2010_fig3.2.jpg\" alt=\"vba2010_fig3.2\" class=\"wp-image-1011\"\/><\/a><\/figure><\/div>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><a href=\"https:\/\/excelvbatutor.com\/wp-content\/uploads\/2013\/12\/vba2010_fig3.31.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"373\" height=\"159\" src=\"https:\/\/excelvbatutor.com\/wp-content\/uploads\/2013\/12\/vba2010_fig3.31.jpg\" alt=\"vba2010_fig3.3\" class=\"wp-image-1015\"\/><\/a><\/figure><\/div>\n\n\n\n<p>The Output display is shown in the following figure:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/excelvbatutor.com\/vba_img\/example21.1.5.jpg\" alt=\"\"\/><\/figure>\n\n\n\n<p><br><script async=\"\" src=\"\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js\"><\/script><br><!-- Excel VBA Responsive --><br><ins class=\"adsbygoogle\" style=\"display: block;\" data-ad-client=\"ca-pub-3033628290023372\" data-ad-slot=\"2763751108\" data-ad-format=\"auto\"><\/ins><br><script><br \/>\n(adsbygoogle = window.adsbygoogle || []).push({});<br \/>\n<\/script><\/p>\n\n\n\n<h4 class=\"wp-block-heading\">&nbsp;3.2(b) Two-Dimensional Array<\/h4>\n\n\n\n<p>Multidimensional arrays are often needed when we are dealing with a more complex database, especially those that handle a large amount of data. Data are usually organized and arranged in table form, this is where the multidimensional arrays come into play. However, in this tutorial, we are dealing only with the two-dimensional array. A two-dimensional array can be represented by a table that contains rows and columns, where one index represents the rows and the other index represent the columns.<\/p>\n\n\n\n<p>The statement to declare a two-dimensional array is<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">Dim arrayName (num1, num2) as datatype\n<\/pre>\n\n\n\n<p>Where num1 is the suffix of the first dimension of the last element and num2 is the suffix of the second dimension of the last element in the array. The suffixes of the element in the array will start with (0, 0) unless you set the Option Base to 1. In the case when the Option Base is set to 1, then the suffixes of the element in the array will start with (1, 1). For example,<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">Dim Score (3, 3) as Integer\n<\/pre>\n\n\n\n<p>will create a two-dimensional array consists of 16 elements. These elements can be organized in a table form as shown in the table below:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/excelvbatutor.com\/wp-content\/uploads\/2013\/03\/vba_table21.1.jpg\" alt=\"\"\/><\/figure>\n\n\n\n<p>If you set the option base to 1, then there will be only 9 elements, i.e from Score(1,1) to Score(3,3). However, if you want the first element to start with suffixes (1,1) you can also use the following format of declaration:<br>Dim Score(1 to 3, 1 to 3) as Integer<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Example 3.3<\/h4>\n\n\n\n<p>If a company wants to track the performance of 5 salespersons over a period of 2 days, you can create a 5\u00d72 array in Excel&nbsp;2010 VBA, denoted by a 5X 2 table in a spreadsheet. Therefore, you can write the following VBA code:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">Private Sub Button1_Click()\nDim SalesVolume(2to 6, 2 to 3) as Single\nDim SalesPerson as Integer, Day as Integer\n For SalesPerson=2 to 6\n For Day=2 to3\n  SalesVolume(SalesPerson, Day)=inputbox(\u201cEnter Sales Volume\u201d)\n  Cells(SalesPerson, Day)=SalesVolume(SalesPerson,Day)\n Next Day\n Next SalesPerson\nEnd Sub\n<\/pre>\n\n\n\n<p>When the user runs the program, the input box that will prompt the user to enter sales volume will appear 10 times, as shown in the Figure below:<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><a href=\"https:\/\/excelvbatutor.com\/wp-content\/uploads\/2013\/12\/vba2010_fig3.4.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"373\" height=\"159\" src=\"https:\/\/excelvbatutor.com\/wp-content\/uploads\/2013\/12\/vba2010_fig3.4.jpg\" alt=\"vba2010_fig3.4\" class=\"wp-image-1026\"\/><\/a><\/figure><\/div>\n\n\n\n<p>After all the sales Volumes are entered, the values in the spreadsheet are shown below:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/excelvbatutor.com\/vba_img\/example21.3.2.jpg\" alt=\"\"\/><\/figure>\n\n\n\n<p>If you need to make sure the user enters the correct sales volume, you can change line 5 statement to<br>SalesVolume(SalesPerson, Day) = InputBox(\u201cEnter Sales Volume of \u201d &amp; \u201d SalesPerson \u201d &amp; (SalesPerson \u2013 1) &amp; \u201d Day \u201d &amp; (Day \u2013 1))<br>A clearer instruction will be shown as follows:<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><a href=\"https:\/\/excelvbatutor.com\/wp-content\/uploads\/2013\/12\/vba2010_fig3.5.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"373\" height=\"159\" src=\"https:\/\/excelvbatutor.com\/wp-content\/uploads\/2013\/12\/vba2010_fig3.5.jpg\" alt=\"vba2010_fig3.5\" class=\"wp-image-1039\"\/><\/a><\/figure><\/div>\n\n\n\n<p><br><script async=\"\" src=\"\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js\"><\/script><br><ins class=\"adsbygoogle\" style=\"display: block; text-align: center;\" data-ad-layout=\"in-article\" data-ad-format=\"fluid\" data-ad-client=\"ca-pub-3033628290023372\" data-ad-slot=\"9639157585\"><\/ins><br><script><br \/>\n     (adsbygoogle = window.adsbygoogle || []).push({});<br \/>\n<\/script><\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong><a href=\"http:\/\/excelvbatutor.com\/index.php\/excel-vba-2010-lesson-2-data-types-constants-and-variables\/\">[Lesson 2]<\/a>&lt;&lt;<a href=\"http:\/\/excelvbatutor.com\/index.php\/excel-vba-2010-tutorial\/\">[Table of Contents]<\/a>&gt;&gt;<a href=\"http:\/\/excelvbatutor.com\/index.php\/excel-vba-2010-lesson-4\/\">[Lesson 4]<\/a><\/strong><\/h4>\n","protected":false},"excerpt":{"rendered":"<p>[Lesson 2]&lt;&lt;[Table of Contents]&gt;&gt;[Lesson 4] 3.1 Array in Excel 2010 VBA When we work with a single item in Excel\u00a0\u00a0VBA\u00a02010, we only need to use one variable. However, if we need to deal with a list of items, we need to declare an array of variables instead of using a variable for each item. For &hellip; <a href=\"https:\/\/excelvbatutor.com\/index.php\/excel-vba-2010-lesson-3-array\/\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;Excel 2010 VBA Lesson 3: Array&#8221;<\/span><\/a><\/p>\n","protected":false},"author":5012,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"categories":[25],"tags":[],"class_list":["post-991","page","type-page","status-publish","hentry","category-array"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.1.1 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Excel 2010 VBA Lesson 3: Array - Learn Excel VBA Online \u2013 Step-by-Step Tutorials &amp; Courses | ExcelVBATutor<\/title>\n<meta name=\"description\" content=\"This lesson explain the concept of array in Excel 2010 VBA macro programming\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/excelvbatutor.com\/index.php\/excel-vba-2010-lesson-3-array\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel 2010 VBA Lesson 3: Array - Learn Excel VBA Online \u2013 Step-by-Step Tutorials &amp; Courses | ExcelVBATutor\" \/>\n<meta property=\"og:description\" content=\"This lesson explain the concept of array in Excel 2010 VBA macro programming\" \/>\n<meta property=\"og:url\" content=\"https:\/\/excelvbatutor.com\/index.php\/excel-vba-2010-lesson-3-array\/\" \/>\n<meta property=\"og:site_name\" content=\"Learn Excel VBA Online \u2013 Step-by-Step Tutorials &amp; Courses | ExcelVBATutor\" \/>\n<meta property=\"article:modified_time\" content=\"2019-04-19T07:32:58+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/excelvbatutor.com\/wp-content\/uploads\/2013\/12\/vba2010_fig3.1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"373\" \/>\n\t<meta property=\"og:image:height\" content=\"159\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/excelvbatutor.com\/index.php\/excel-vba-2010-lesson-3-array\/\",\"url\":\"https:\/\/excelvbatutor.com\/index.php\/excel-vba-2010-lesson-3-array\/\",\"name\":\"Excel 2010 VBA Lesson 3: Array - Learn Excel VBA Online \u2013 Step-by-Step Tutorials &amp; Courses | ExcelVBATutor\",\"isPartOf\":{\"@id\":\"https:\/\/excelvbatutor.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/excelvbatutor.com\/index.php\/excel-vba-2010-lesson-3-array\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/excelvbatutor.com\/index.php\/excel-vba-2010-lesson-3-array\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/excelvbatutor.com\/wp-content\/uploads\/2013\/12\/vba2010_fig3.1.jpg\",\"datePublished\":\"2013-12-06T08:12:18+00:00\",\"dateModified\":\"2019-04-19T07:32:58+00:00\",\"description\":\"This lesson explain the concept of array in Excel 2010 VBA macro programming\",\"breadcrumb\":{\"@id\":\"https:\/\/excelvbatutor.com\/index.php\/excel-vba-2010-lesson-3-array\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/excelvbatutor.com\/index.php\/excel-vba-2010-lesson-3-array\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/excelvbatutor.com\/index.php\/excel-vba-2010-lesson-3-array\/#primaryimage\",\"url\":\"https:\/\/excelvbatutor.com\/wp-content\/uploads\/2013\/12\/vba2010_fig3.1.jpg\",\"contentUrl\":\"https:\/\/excelvbatutor.com\/wp-content\/uploads\/2013\/12\/vba2010_fig3.1.jpg\",\"width\":373,\"height\":159},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/excelvbatutor.com\/index.php\/excel-vba-2010-lesson-3-array\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/excelvbatutor.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel 2010 VBA Lesson 3: Array\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/excelvbatutor.com\/#website\",\"url\":\"https:\/\/excelvbatutor.com\/\",\"name\":\"Learn Excel VBA Online \u2013 Step-by-Step Tutorials &amp; Courses | ExcelVBATutor\",\"description\":\"Master Excel VBA with free tutorials, examples, and personalized guidance. Perfect for beginners and advanced users looking to automate Excel.\",\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel 2010 VBA Lesson 3: Array - Learn Excel VBA Online \u2013 Step-by-Step Tutorials &amp; Courses | ExcelVBATutor","description":"This lesson explain the concept of array in Excel 2010 VBA macro programming","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:\/\/excelvbatutor.com\/index.php\/excel-vba-2010-lesson-3-array\/","og_locale":"en_US","og_type":"article","og_title":"Excel 2010 VBA Lesson 3: Array - Learn Excel VBA Online \u2013 Step-by-Step Tutorials &amp; Courses | ExcelVBATutor","og_description":"This lesson explain the concept of array in Excel 2010 VBA macro programming","og_url":"https:\/\/excelvbatutor.com\/index.php\/excel-vba-2010-lesson-3-array\/","og_site_name":"Learn Excel VBA Online \u2013 Step-by-Step Tutorials &amp; Courses | ExcelVBATutor","article_modified_time":"2019-04-19T07:32:58+00:00","og_image":[{"width":373,"height":159,"url":"https:\/\/excelvbatutor.com\/wp-content\/uploads\/2013\/12\/vba2010_fig3.1.jpg","type":"image\/jpeg"}],"twitter_misc":{"Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/excelvbatutor.com\/index.php\/excel-vba-2010-lesson-3-array\/","url":"https:\/\/excelvbatutor.com\/index.php\/excel-vba-2010-lesson-3-array\/","name":"Excel 2010 VBA Lesson 3: Array - Learn Excel VBA Online \u2013 Step-by-Step Tutorials &amp; Courses | ExcelVBATutor","isPartOf":{"@id":"https:\/\/excelvbatutor.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/excelvbatutor.com\/index.php\/excel-vba-2010-lesson-3-array\/#primaryimage"},"image":{"@id":"https:\/\/excelvbatutor.com\/index.php\/excel-vba-2010-lesson-3-array\/#primaryimage"},"thumbnailUrl":"https:\/\/excelvbatutor.com\/wp-content\/uploads\/2013\/12\/vba2010_fig3.1.jpg","datePublished":"2013-12-06T08:12:18+00:00","dateModified":"2019-04-19T07:32:58+00:00","description":"This lesson explain the concept of array in Excel 2010 VBA macro programming","breadcrumb":{"@id":"https:\/\/excelvbatutor.com\/index.php\/excel-vba-2010-lesson-3-array\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/excelvbatutor.com\/index.php\/excel-vba-2010-lesson-3-array\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/excelvbatutor.com\/index.php\/excel-vba-2010-lesson-3-array\/#primaryimage","url":"https:\/\/excelvbatutor.com\/wp-content\/uploads\/2013\/12\/vba2010_fig3.1.jpg","contentUrl":"https:\/\/excelvbatutor.com\/wp-content\/uploads\/2013\/12\/vba2010_fig3.1.jpg","width":373,"height":159},{"@type":"BreadcrumbList","@id":"https:\/\/excelvbatutor.com\/index.php\/excel-vba-2010-lesson-3-array\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/excelvbatutor.com\/"},{"@type":"ListItem","position":2,"name":"Excel 2010 VBA Lesson 3: Array"}]},{"@type":"WebSite","@id":"https:\/\/excelvbatutor.com\/#website","url":"https:\/\/excelvbatutor.com\/","name":"Learn Excel VBA Online \u2013 Step-by-Step Tutorials &amp; Courses | ExcelVBATutor","description":"Master Excel VBA with free tutorials, examples, and personalized guidance. Perfect for beginners and advanced users looking to automate Excel.","inLanguage":"en-US"}]}},"_links":{"self":[{"href":"https:\/\/excelvbatutor.com\/index.php\/wp-json\/wp\/v2\/pages\/991","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/excelvbatutor.com\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/excelvbatutor.com\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/excelvbatutor.com\/index.php\/wp-json\/wp\/v2\/users\/5012"}],"replies":[{"embeddable":true,"href":"https:\/\/excelvbatutor.com\/index.php\/wp-json\/wp\/v2\/comments?post=991"}],"version-history":[{"count":88,"href":"https:\/\/excelvbatutor.com\/index.php\/wp-json\/wp\/v2\/pages\/991\/revisions"}],"predecessor-version":[{"id":3316,"href":"https:\/\/excelvbatutor.com\/index.php\/wp-json\/wp\/v2\/pages\/991\/revisions\/3316"}],"wp:attachment":[{"href":"https:\/\/excelvbatutor.com\/index.php\/wp-json\/wp\/v2\/media?parent=991"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/excelvbatutor.com\/index.php\/wp-json\/wp\/v2\/categories?post=991"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/excelvbatutor.com\/index.php\/wp-json\/wp\/v2\/tags?post=991"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}