{"id":8719,"date":"2023-02-26T02:02:25","date_gmt":"2023-02-26T02:02:25","guid":{"rendered":"https:\/\/www.excel-learn.com\/?p=8719"},"modified":"2023-12-30T12:07:44","modified_gmt":"2023-12-30T12:07:44","slug":"array-length-vba","status":"publish","type":"post","link":"https:\/\/www.excel-learn.com\/array-length-vba\/","title":{"rendered":"5 Examples of How to get Array Length\/Size in VBA"},"content":{"rendered":"<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-10026\" src=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2023\/02\/VBA-Array-Length.jpg\" alt=\"A graphical representation of an array with numbered elements illustrates its structure and length.\" width=\"800\" height=\"600\" srcset=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2023\/02\/VBA-Array-Length.jpg 800w, https:\/\/www.excel-learn.com\/wp-content\/uploads\/2023\/02\/VBA-Array-Length-300x225.jpg 300w, https:\/\/www.excel-learn.com\/wp-content\/uploads\/2023\/02\/VBA-Array-Length-768x576.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<h3><strong>Get array length in VBA<\/strong><\/h3>\n<p>For a dimensional array, you may get the array length (size) by using the <strong><a href=\"https:\/\/www.excel-learn.com\/vba-ubound-and-lbound-functions\/\">UBound<\/a><\/strong> function.<\/p>\n<p>Following is the syntax of the UBound function:<\/p>\n<div class=\"codediv\">UBound(arrayname, [ dimension ])<\/div>\n<h3><strong>An example of getting array size<\/strong><\/h3>\n<p>In the following example,<\/p>\n<ul>\n<li>We declare an array and assign values to its elements by index numbers.<\/li>\n<li>Then UBound function is used to get the size that is displayed in the <a href=\"\/vba-msgbox-function\/\">message box<\/a>:<\/li>\n<\/ul>\n<p><strong>VBA Code:<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"visualbasic\">Sub Arrays_length()\r\n\r\nDim arr_days(7) As String\r\n\r\n'Creating array elements\r\narr_days(0) = \"Sat\"\r\narr_days(1) = \"Sun\"\r\narr_days(2) = \"Mon\"\r\narr_days(3) = \"Tue\"\r\n\r\n'Display Array Length\r\narr_len = UBound(arr_days) + 1\r\n\r\nMsgBox \"Array has \" &amp; arr_len &amp; \" elements.\"\r\n\r\n\r\nEnd Sub<\/pre>\n<p><strong>Output:<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-8726\" src=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2023\/02\/38_1-VBA-array-length.jpg\" alt=\"VBA-array-length\" width=\"191\" height=\"158\" \/><\/p>\n<p>We need to add 1 to the UBound result as the array index starts at 0. So, we have one more item than the returned value of UBound function.<\/p>\n<h3><strong>What if the array index starts at 2 or more?<\/strong><\/h3>\n<p>If we have an array like this:<\/p>\n<div class=\"codediv\">Dim arr_days(2 To 7) As String<\/div>\n<p>Then UBound still returns seven, as it\u2019s the upper number in our array. However, the actual number of elements is less.<\/p>\n<p>In that case, you may use <strong>UBound<\/strong> with the <strong><a href=\"https:\/\/www.excel-learn.com\/vba-ubound-and-lbound-functions\/\">LBound<\/a><\/strong> function \u2013 which returns a lower number in the array.<\/p>\n<p><strong>See the simple example below of getting array length:<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"visualbasic\">Sub arr_ex()\r\n\r\nDim arr_days(2 To 7) As String\r\n\r\nDim arrLen As <a href=\"https:\/\/www.excel-learn.com\/vba-integer-vs-long\/\">Integer<\/a>\r\n\r\n\r\n'Creating array elements\r\narr_days(2) = \"Sat\"\r\narr_days(3) = \"Sun\"\r\narr_days(4) = \"Mon\"\r\narr_days(5) = \"Tue\"\r\narr_days(6) = \"Tue\"\r\narr_days(7) = \"Wed\"\r\n\r\n\r\n'Display Array Length\r\narrLen = UBound(arr_days) - LBound(arr_days) + 1\r\n\r\nMsgBox \"Array has \" &amp; arrLen &amp; \" elements.\"\r\n\r\nEnd Sub<\/pre>\n<p><strong>Output:<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-8720\" src=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2023\/02\/38_7-array-length-single.jpg\" alt=\"array-length-single\" width=\"205\" height=\"164\" \/><\/p>\n<h3><strong>Getting the array size of a two-dimensional array<\/strong><\/h3>\n<p>There may be different scenarios to get the array size of 2-D array.<\/p>\n<div class=\"inner-info-div\">\n<p><strong>Scenario 1:<\/strong><br \/>\nIf your two-dimensional array elements start at 1, for example:<\/p>\n<div class=\"codediv\">Dim arr_products(1 To 5, 1 To 4) As String<\/div>\n<p>In that case, you may use this simple approach to get number of elements in the 2-D array:<\/p>\n<\/div>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"visualbasic\">Sub Arrays_ex()\r\n\r\n'Creating a 2D array\r\nDim arr_products(1 To 6, 1 To 3) As String\r\nDim i As Integer, j As Integer, k As Integer\r\n\r\n'Using UBound and multiply\r\ni = UBound(arr_products, 1)\r\nj = UBound(arr_products, 2)\r\n\r\nk = i * j\r\n\r\nMsgBox \"2-D Array has \" &amp; k &amp; \" elements.\"\r\n\r\nEnd Sub<\/pre>\n<p><strong>Result:<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-8725\" src=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2023\/02\/38_2-VBA-array-length-2D.jpg\" alt=\"VBA-array-length-2D\" width=\"225\" height=\"157\" \/><\/p>\n<h3><strong>What if array index starts beyond 1?<\/strong><\/h3>\n<p>Let us say, your 2-D array is declared like this:<\/p>\n<div class=\"codediv\">Dim arr_products(3 To 6, 2 To 3) As String<\/div>\n<p>Then our above approach fails, as UBound still returns 6 and 3 and the output remains the same.<\/p>\n<p>In that case, we can use LBound function as well to get the correct array length.<\/p>\n<div class=\"info-div\">LBound returns the smallest available subscript for the indicated dimension of an array.<\/div>\n<p>See the following solution for our 2D array:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"visualbasic\">Sub Arrays_ex()\r\n\r\n'Creating a 2D array\r\nDim arr_products(3 To 6, 2 To 3) As String\r\nDim i As Integer, j As Integer, k As Integer\r\n\r\n'Using UBound and LBound\r\n\r\ni = UBound(arr_products, 1) - LBound(arr_products, 1) + 1\r\nj = UBound(arr_products, 2) - LBound(arr_products, 2) + 1\r\n\r\nk = i * j\r\n\r\nMsgBox \"2-D Array has \" &amp; k &amp; \" elements.\"\r\n\r\nEnd Sub<\/pre>\n<p><strong>Output:<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-8724\" src=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2023\/02\/38_3-array-length-2D-sce-2.jpg\" alt=\"array-length-2D-sce-2\" width=\"233\" height=\"162\" \/><\/p>\n<h3><strong>Working with 2-D array length and Excel sheet <\/strong><\/h3>\n<p>Now let\u2019s look at an Excel sheet example to have a better idea of how the above approach worked.<\/p>\n<p>We have the following sample sheet:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-8723\" src=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2023\/02\/38_4-array-length-2D-sce-3.jpg\" alt=\"array-length-2D-sce-3\" width=\"620\" height=\"349\" srcset=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2023\/02\/38_4-array-length-2D-sce-3.jpg 620w, https:\/\/www.excel-learn.com\/wp-content\/uploads\/2023\/02\/38_4-array-length-2D-sce-3-300x169.jpg 300w\" sizes=\"(max-width: 620px) 100vw, 620px\" \/><\/p>\n<p>We will create a 2-D array from that sheet and get the array length (total cells utilized).<\/p>\n<p>So following is our two-dimensional array:<\/p>\n<div class=\"codediv\">Dim arr_products(3 To 6, 2 To 3) As String<\/div>\n<p><strong>Assign the cell values as array elements<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"visualbasic\">For x = 1 To 8\r\n\r\n\u00a0\u00a0\u00a0 For y = 1 To 4\r\n\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 arr_products(x, y) = Cells(x, y).Value\r\n\r\n\u00a0\u00a0\u00a0 Next y\r\n\r\nNext x<\/pre>\n<p><strong>Display all array elements in a message box to see what we get from the Excel sheet:<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"visualbasic\">For i = 3 To UBound(arr_products)\r\n\r\n\u00a0\u00a0\u00a0 Str_Prods = Str_Prods &amp; arr_products(i, 2) &amp; \"\u00a0\u00a0\u00a0 \" &amp; arr_products(i, 3) &amp; vbNewLine\r\n\r\nNext i\r\n\r\n'Display cells\/element\r\n\r\nMsgBox Str_Prods<\/pre>\n<p><strong>Get the 2-D array length:<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"visualbasic\">i = UBound(arr_products, 1) - LBound(arr_products, 1) + 1\r\n\r\nj = UBound(arr_products, 2) - LBound(arr_products, 2) + 1\r\n\r\nk = i * j\r\n\r\nMsgBox \"2-D Array has \" &amp; k &amp; \" elements.\"<\/pre>\n<p><strong>Let us combine all of the above code and see the outputs:<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"visualbasic\">Sub Arrays_ex()\r\n\r\n'Creating a 2D array\r\nDim arr_products(3 To 6, 2 To 3) As String\r\nDim x As Integer, y As Integer\r\nDim i As Integer, j As Integer, k As Integer\r\n\r\n'Assigning cell values as array element values\r\n\r\nFor x = 3 To 6\r\n\r\n\u00a0\u00a0\u00a0 For y = 2 To 3\r\n\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 arr_products(x, y) = Cells(x, y).Value\r\n\r\n\u00a0\u00a0\u00a0 Next y\r\n\r\nNext x\r\n\r\n'Displaying whole array in Message Box\r\n\r\nFor i = 3 To UBound(arr_products)\r\n\u00a0\u00a0\u00a0 Str_Prods = Str_Prods &amp; arr_products(i, 2) &amp; \"\u00a0\u00a0\u00a0 \" &amp; arr_products(i, 3) &amp; vbNewLine\r\nNext i\r\n\r\n'Display cells\/element\r\nMsgBox Str_Prods\r\n\r\n'Using UBound and LBound to get array length\r\n\r\ni = UBound(arr_products, 1) - LBound(arr_products, 1) + 1\r\n\r\nj = UBound(arr_products, 2) - LBound(arr_products, 2) + 1\r\n\r\nk = i * j\r\n\r\n'Display array length\r\n\r\nMsgBox \"2-D Array has \" &amp; k &amp; \" elements.\"\r\n\r\nEnd Sub<\/pre>\n<p>Output:<\/p>\n<p><strong>Message box 1:<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-8722\" src=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2023\/02\/38_5-array-length-msg1.jpg\" alt=\"array-length-msg1\" width=\"194\" height=\"206\" \/><\/p>\n<p><strong>Message box 2:<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-8721\" src=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2023\/02\/38_6-array-length-msg2.jpg\" alt=\"array-length-msg2\" width=\"234\" height=\"176\" \/><\/p>\n<p>You can compare the cell data and array length with the sample sheet\u2019s highlighted area above.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>For one dimensional array, you may get the array length (size) by using UBound function.<\/p>\n","protected":false},"author":1,"featured_media":10026,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[147],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.6 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>5 Examples of How to get Array Length\/Size in VBA<\/title>\n<meta name=\"description\" content=\"For one dimensional array, you may get the array length (size) by using UBound function.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.excel-learn.com\/array-length-vba\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"5 Examples of How to get Array Length\/Size in VBA\" \/>\n<meta property=\"og:description\" content=\"For one dimensional array, you may get the array length (size) by using UBound function.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.excel-learn.com\/array-length-vba\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-02-26T02:02:25+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-30T12:07:44+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2023\/02\/VBA-Array-Length.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"800\" \/>\n\t<meta property=\"og:image:height\" content=\"600\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"excelmaster\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"excelmaster\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.excel-learn.com\/array-length-vba\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.excel-learn.com\/array-length-vba\/\"},\"author\":{\"name\":\"excelmaster\",\"@id\":\"https:\/\/www.excel-learn.com\/#\/schema\/person\/c3f75f86b1c65bf0b93fc46f629fcad3\"},\"headline\":\"5 Examples of How to get Array Length\/Size in VBA\",\"datePublished\":\"2023-02-26T02:02:25+00:00\",\"dateModified\":\"2023-12-30T12:07:44+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.excel-learn.com\/array-length-vba\/\"},\"wordCount\":445,\"publisher\":{\"@id\":\"https:\/\/www.excel-learn.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.excel-learn.com\/array-length-vba\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2023\/02\/VBA-Array-Length.jpg\",\"articleSection\":[\"VBA Excel\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.excel-learn.com\/array-length-vba\/\",\"url\":\"https:\/\/www.excel-learn.com\/array-length-vba\/\",\"name\":\"5 Examples of How to get Array Length\/Size in VBA\",\"isPartOf\":{\"@id\":\"https:\/\/www.excel-learn.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.excel-learn.com\/array-length-vba\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.excel-learn.com\/array-length-vba\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2023\/02\/VBA-Array-Length.jpg\",\"datePublished\":\"2023-02-26T02:02:25+00:00\",\"dateModified\":\"2023-12-30T12:07:44+00:00\",\"description\":\"For one dimensional array, you may get the array length (size) by using UBound function.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.excel-learn.com\/array-length-vba\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.excel-learn.com\/array-length-vba\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.excel-learn.com\/array-length-vba\/#primaryimage\",\"url\":\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2023\/02\/VBA-Array-Length.jpg\",\"contentUrl\":\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2023\/02\/VBA-Array-Length.jpg\",\"width\":800,\"height\":600,\"caption\":\"A graphical representation of an array with numbered elements illustrates its structure and length.\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.excel-learn.com\/array-length-vba\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.excel-learn.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"5 Examples of How to get Array Length\/Size in VBA\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.excel-learn.com\/#website\",\"url\":\"https:\/\/www.excel-learn.com\/\",\"name\":\"Excel Tutorials\",\"description\":\"Tips, Solutions, Tricks\",\"publisher\":{\"@id\":\"https:\/\/www.excel-learn.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.excel-learn.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.excel-learn.com\/#organization\",\"name\":\"Excel Tutorials\",\"url\":\"https:\/\/www.excel-learn.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.excel-learn.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2022\/10\/Excel-logo_4_30.png\",\"contentUrl\":\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2022\/10\/Excel-logo_4_30.png\",\"width\":227,\"height\":48,\"caption\":\"Excel Tutorials\"},\"image\":{\"@id\":\"https:\/\/www.excel-learn.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.excel-learn.com\/#\/schema\/person\/c3f75f86b1c65bf0b93fc46f629fcad3\",\"name\":\"excelmaster\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.excel-learn.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/e2a3743b4da71bd52984e02bd5c3280c?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/e2a3743b4da71bd52984e02bd5c3280c?s=96&d=mm&r=g\",\"caption\":\"excelmaster\"},\"url\":\"https:\/\/www.excel-learn.com\/author\/jqueryaz\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"5 Examples of How to get Array Length\/Size in VBA","description":"For one dimensional array, you may get the array length (size) by using UBound function.","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:\/\/www.excel-learn.com\/array-length-vba\/","og_locale":"en_US","og_type":"article","og_title":"5 Examples of How to get Array Length\/Size in VBA","og_description":"For one dimensional array, you may get the array length (size) by using UBound function.","og_url":"https:\/\/www.excel-learn.com\/array-length-vba\/","og_site_name":"Excel Tutorials","article_published_time":"2023-02-26T02:02:25+00:00","article_modified_time":"2023-12-30T12:07:44+00:00","og_image":[{"width":800,"height":600,"url":"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2023\/02\/VBA-Array-Length.jpg","type":"image\/jpeg"}],"author":"excelmaster","twitter_misc":{"Written by":"excelmaster","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.excel-learn.com\/array-length-vba\/#article","isPartOf":{"@id":"https:\/\/www.excel-learn.com\/array-length-vba\/"},"author":{"name":"excelmaster","@id":"https:\/\/www.excel-learn.com\/#\/schema\/person\/c3f75f86b1c65bf0b93fc46f629fcad3"},"headline":"5 Examples of How to get Array Length\/Size in VBA","datePublished":"2023-02-26T02:02:25+00:00","dateModified":"2023-12-30T12:07:44+00:00","mainEntityOfPage":{"@id":"https:\/\/www.excel-learn.com\/array-length-vba\/"},"wordCount":445,"publisher":{"@id":"https:\/\/www.excel-learn.com\/#organization"},"image":{"@id":"https:\/\/www.excel-learn.com\/array-length-vba\/#primaryimage"},"thumbnailUrl":"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2023\/02\/VBA-Array-Length.jpg","articleSection":["VBA Excel"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.excel-learn.com\/array-length-vba\/","url":"https:\/\/www.excel-learn.com\/array-length-vba\/","name":"5 Examples of How to get Array Length\/Size in VBA","isPartOf":{"@id":"https:\/\/www.excel-learn.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.excel-learn.com\/array-length-vba\/#primaryimage"},"image":{"@id":"https:\/\/www.excel-learn.com\/array-length-vba\/#primaryimage"},"thumbnailUrl":"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2023\/02\/VBA-Array-Length.jpg","datePublished":"2023-02-26T02:02:25+00:00","dateModified":"2023-12-30T12:07:44+00:00","description":"For one dimensional array, you may get the array length (size) by using UBound function.","breadcrumb":{"@id":"https:\/\/www.excel-learn.com\/array-length-vba\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.excel-learn.com\/array-length-vba\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.excel-learn.com\/array-length-vba\/#primaryimage","url":"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2023\/02\/VBA-Array-Length.jpg","contentUrl":"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2023\/02\/VBA-Array-Length.jpg","width":800,"height":600,"caption":"A graphical representation of an array with numbered elements illustrates its structure and length."},{"@type":"BreadcrumbList","@id":"https:\/\/www.excel-learn.com\/array-length-vba\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.excel-learn.com\/"},{"@type":"ListItem","position":2,"name":"5 Examples of How to get Array Length\/Size in VBA"}]},{"@type":"WebSite","@id":"https:\/\/www.excel-learn.com\/#website","url":"https:\/\/www.excel-learn.com\/","name":"Excel Tutorials","description":"Tips, Solutions, Tricks","publisher":{"@id":"https:\/\/www.excel-learn.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.excel-learn.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.excel-learn.com\/#organization","name":"Excel Tutorials","url":"https:\/\/www.excel-learn.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.excel-learn.com\/#\/schema\/logo\/image\/","url":"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2022\/10\/Excel-logo_4_30.png","contentUrl":"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2022\/10\/Excel-logo_4_30.png","width":227,"height":48,"caption":"Excel Tutorials"},"image":{"@id":"https:\/\/www.excel-learn.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.excel-learn.com\/#\/schema\/person\/c3f75f86b1c65bf0b93fc46f629fcad3","name":"excelmaster","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.excel-learn.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/e2a3743b4da71bd52984e02bd5c3280c?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/e2a3743b4da71bd52984e02bd5c3280c?s=96&d=mm&r=g","caption":"excelmaster"},"url":"https:\/\/www.excel-learn.com\/author\/jqueryaz\/"}]}},"_links":{"self":[{"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/posts\/8719"}],"collection":[{"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/comments?post=8719"}],"version-history":[{"count":5,"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/posts\/8719\/revisions"}],"predecessor-version":[{"id":10028,"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/posts\/8719\/revisions\/10028"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/media\/10026"}],"wp:attachment":[{"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/media?parent=8719"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/categories?post=8719"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/tags?post=8719"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}