{"id":2049,"date":"2023-10-22T20:20:14","date_gmt":"2023-10-22T20:20:14","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/ukuran-susunan\/"},"modified":"2023-12-06T06:16:16","modified_gmt":"2023-12-06T06:16:16","slug":"ukuran-susunan","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/ukuran-susunan\/","title":{"rendered":"Bagaimana cara mendapatkan panjang array menggunakan vba?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-3542975897\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p>Di VBA, mendapatkan panjang array berarti menghitung jumlah elemen yang Anda miliki dalam array tersebut. Untuk itu perlu diketahui unsur terendah dan unsur tertinggi. Jadi untuk mendapatkan ini Anda bisa menggunakan fungsi UBOUND dan <a href=\"https:\/\/exceladvisor.org\/id\/terikat\/\">LBOUND<\/a> yang masing-masing mengembalikan batas atas dan batas bawah.<\/p><p> Selain itu Anda juga dapat menggunakan COUNTA yang merupakan fungsi spreadsheet. Dan dalam tutorial ini kita akan melihat kedua metode tersebut sehingga Anda dapat menggunakan salah satunya sesuai kenyamanan Anda.<\/p><h2 class=\"wp-block-heading\"> Langkah-langkah untuk mendapatkan ukuran array<\/h2><p> Di sini kita memiliki tabel yang berisi daftar bulan dan jumlah penjualan setiap bulannya. <\/p><div class=\"wp-block-image is-style-default\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-57222\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-longueur-de-tableau-vba-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"panjang array vba\" width=\"451\" height=\"527\"><\/figure><\/div><ol><li> Pastikan Anda memiliki tabel yang dideklarasikan dengan benar dengan baris dan kolom. <br><img loading=\"lazy\" decoding=\"async\" title=\"2-array-dideklarasikan-dengan benar-2\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-tableau-declare-correctement-2.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"484\" height=\"291\"><\/li><li> Setelah itu, dua variabel lagi (karena kita memiliki array dua dimensi) untuk menyimpan batas-batas array. <br><img loading=\"lazy\" decoding=\"async\" title=\"3-menyimpan-batas-dari-array-3\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-stocker-les-bornes-dun-tableau-3.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"596\" height=\"298\"><\/li><li> Maka Anda perlu menggunakan rumus di mana Anda perlu menggunakan fungsi Ubound untuk mendapatkan batas atas dan kemudian Lbound untuk mendapatkan batas bawah array.<\/li><li> Karena Anda memiliki array dua dimensi, Anda berdua harus terikat pada dimensi dan menetapkan nilai ini pada variabel. <br><img loading=\"lazy\" decoding=\"async\" title=\"4-gunakan-fungsi-ubound-4\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-utiliser-la-fonction-ubound-4.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"682\" height=\"349\"><\/li><li> Terakhir, kalikan panjang yang didapat dari Ubound dan Lbound sebagai batas atas dan bawah. <br><img loading=\"lazy\" decoding=\"async\" title=\"5-ubound-dan-lbound-seperti-bawah-dan-atas-5\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-ubound-et-lbound-comme-inferieur-et-superieur-5.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"729\" height=\"397\"><\/li><\/ol><p> Berikut kode lengkapnya.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Dim yearSales(1 To 12, 1 To 2) As Integer Dim iCount1 As Integer, iCount2 As Integer iCount1 = UBound(yearSales, 1) - LBound(yearSales, 1) + 1 iCount2 = UBound(yearSales, 2) - LBound(yearSales, 2) + 1 MsgBox iCount1 * iCount2<\/code><\/pre><p class=\"qt-tip\"> <strong>Catatan:<\/strong> Anda pasti bertanya-tanya apakah kami memiliki total 13 baris dalam tabel yang saya bagikan kepada Anda di awal artikel.<\/p><p> Namun kami menggunakan tabel 13 baris karena baris pertama adalah judul. Dan di sini kita telah menggunakan <a href=\"https:\/\/exceladvisor.org\/id\/kosong\/\">fungsi<\/a> <a href=\"https:\/\/exceladvisor.org\/id\/jika-2\/\">IF STATEMENT<\/a> dan ISEMPTY untuk memeriksa apakah array yang dideklarasikan tidak mengandung elemen apa pun.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Dim yearSales(1 To 12, 1 To 2) As Integer Dim iCount1 As Integer, iCount2 As Integer If IsEmpty(yearSales) = 0 Then MsgBox \"This array has zero elements.\" Else iCount1 = UBound(yearSales, 1) - LBound(yearSales, 1) + 1 iCount2 = UBound(yearSales, 2) - LBound(yearSales, 2) + 1 MsgBox \"This array has \" &amp; iCount1 * iCount2 &amp; \" element(s).\"<\/code><\/pre><h2 class=\"wp-block-heading\"> Menggunakan COUNTA untuk mendapatkan panjang array<\/h2><p> Seperti yang Anda ketahui, array adalah sekumpulan elemen yang terstruktur dalam satu dimensi atau multidimensi dan Anda dapat menggunakan fungsi COUNTA ( <a href=\"https:\/\/exceladvisor.org\/id\/fungsi-spreadsheet\/\">fungsi spreadsheet<\/a> ) untuk menghitung elemen-elemen ini sekaligus.<\/p><p> Dalam kode berikut, Anda menggunakan array yang sama yang Anda deklarasikan sebelumnya dan kemudian menggunakan variabel untuk menyimpan jumlah elemen yang dikembalikan oleh fungsi. <\/p><div class=\"wp-block-image is-style-default\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-57227\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-utiliser-une-variable-pour-stocker-lelement-6.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"644\" height=\"374\"><\/figure><\/div><p> Dan seperti yang Anda lihat, hasil yang dikembalikan adalah 24, yang merupakan jumlah total elemen yang kita miliki dalam array.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Dim yearSales(1 To 12, 1 To 2) As Integer iCount = WorksheetFunction.CountA(yearSales) MsgBox iCount<\/code><\/pre><p> Ada satu hal yang perlu Anda perhatikan, cara ini tidak ideal untuk digunakan di setiap situasi, jadi sebaiknya selalu gunakan cara yang telah kita bahas sebelumnya.<\/p><p> Anda juga dapat menulis kode untuk memeriksa terlebih dahulu apakah array yang dideklarasikan tidak kosong.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Dim yearSales(1 To 12, 1 To 2) As Integer If IsEmpty(yearSales) = 0 Then MsgBox \"This array has zero elements.\" Else iCount = WorksheetFunction.CountA(yearSales) MsgBox \"This array has \" &amp; iCount &amp; \" element(s).\"<\/code><\/pre><div class=\"gb-container gb-container-4db6181c gb-container-mt\"> <a class=\"gb-button gb-button-c5897111 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/id\/vba\/\">Apa itu VBA<\/a><h2 class=\"gb-headline gb-headline-665e5f6b gb-headline-text gb-headline-mt-heading\"> Pelajari lebih lanjut tentang <a href=\"https:\/\/exceladvisor.org\/id\/lukisan\/\">tabel VBA<\/a> <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a20baf7c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-65ddf67e\"><div class=\"gb-container gb-container-65ddf67e\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/id\/menambahkan-array-nilai-baru\/\">VBA Tambahkan nilai baru ke array<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/meja-dengan-rantai\/\">Array VBA dengan string<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/menghapus-papan\/\">Array Hapus VBA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/tabel-dinamis\/\">VBA tabel dinamis<\/a><\/li><\/ul><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-2049","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Bagaimana cara mendapatkan panjang array menggunakan VBA?<\/title>\n<meta name=\"description\" content=\"Di sini Anda akan melihat dua cara mudah untuk mendapatkan panjang array (tunggal dan multidimensi) menggunakan fungsi UBOUND dan LBOUND.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/id\/ukuran-susunan\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bagaimana cara mendapatkan panjang array menggunakan VBA?\" \/>\n<meta property=\"og:description\" content=\"Di sini Anda akan melihat dua cara mudah untuk mendapatkan panjang array (tunggal dan multidimensi) menggunakan fungsi UBOUND dan LBOUND.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/ukuran-susunan\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:16:16+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-longueur-de-tableau-vba-1.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/id\/ukuran-susunan\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/ukuran-susunan\/\",\"name\":\"Bagaimana cara mendapatkan panjang array menggunakan VBA?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/ukuran-susunan\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/ukuran-susunan\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-longueur-de-tableau-vba-1.png\",\"datePublished\":\"2023-10-22T20:20:14+00:00\",\"dateModified\":\"2023-12-06T06:16:16+00:00\",\"description\":\"Di sini Anda akan melihat dua cara mudah untuk mendapatkan panjang array (tunggal dan multidimensi) menggunakan fungsi UBOUND dan LBOUND.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/ukuran-susunan\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/ukuran-susunan\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/ukuran-susunan\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-longueur-de-tableau-vba-1.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-longueur-de-tableau-vba-1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/ukuran-susunan\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara mendapatkan panjang array menggunakan vba?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"name\":\"Excel Advisor\",\"description\":\"Panduan utama Anda untuk mendominasi data!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/id\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"id\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Bagaimana cara mendapatkan panjang array menggunakan VBA?","description":"Di sini Anda akan melihat dua cara mudah untuk mendapatkan panjang array (tunggal dan multidimensi) menggunakan fungsi UBOUND dan LBOUND.","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:\/\/exceladvisor.org\/id\/ukuran-susunan\/","og_locale":"id_ID","og_type":"article","og_title":"Bagaimana cara mendapatkan panjang array menggunakan VBA?","og_description":"Di sini Anda akan melihat dua cara mudah untuk mendapatkan panjang array (tunggal dan multidimensi) menggunakan fungsi UBOUND dan LBOUND.","og_url":"https:\/\/exceladvisor.org\/id\/ukuran-susunan\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:16:16+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-longueur-de-tableau-vba-1.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/id\/ukuran-susunan\/","url":"https:\/\/exceladvisor.org\/id\/ukuran-susunan\/","name":"Bagaimana cara mendapatkan panjang array menggunakan VBA?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/ukuran-susunan\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/ukuran-susunan\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-longueur-de-tableau-vba-1.png","datePublished":"2023-10-22T20:20:14+00:00","dateModified":"2023-12-06T06:16:16+00:00","description":"Di sini Anda akan melihat dua cara mudah untuk mendapatkan panjang array (tunggal dan multidimensi) menggunakan fungsi UBOUND dan LBOUND.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/ukuran-susunan\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/ukuran-susunan\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/ukuran-susunan\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-longueur-de-tableau-vba-1.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-longueur-de-tableau-vba-1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/ukuran-susunan\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara mendapatkan panjang array menggunakan vba?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/id\/#website","url":"https:\/\/exceladvisor.org\/id\/","name":"Excel Advisor","description":"Panduan utama Anda untuk mendominasi data!","publisher":{"@id":"https:\/\/exceladvisor.org\/id\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/id\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"id"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/id\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/id\/","logo":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2049","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/comments?post=2049"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2049\/revisions"}],"predecessor-version":[{"id":2512,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2049\/revisions\/2512"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=2049"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}