{"id":1526,"date":"2023-11-17T21:36:05","date_gmt":"2023-11-17T21:36:05","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/tabel-dinamis\/"},"modified":"2023-12-06T06:13:54","modified_gmt":"2023-12-06T06:13:54","slug":"tabel-dinamis","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/tabel-dinamis\/","title":{"rendered":"Bagaimana cara membuat tabel dinamis di vba?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-1018161342\"><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>Array dinamis adalah sesuatu di mana Anda dapat mengubah ukuran array dan menambahkan nilai lebih ke dalamnya saat menjalankan kode. Dalam tutorial ini, kita akan mengeksplorasi cara menulis kode di mana Anda dapat mengubah ukuran dan menambahkan lebih banyak elemen.<\/p><h2 class=\"wp-block-heading\"> Buat tabel dinamis di VBA<\/h2><ol type=\"1\"><li> Pertama, deklarasikan array dengan namanya.<\/li><li> Setelah itu, jumlah elemen dikosongkan dalam tanda kurung.<\/li><li> Sekarang gunakan instruksi ReDim.<\/li><li> Pada akhirnya, tentukan jumlah elemen yang ingin Anda tambahkan ke array. <\/li><\/ol><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Dim myArray() As String ReDim myArray(5)<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-57185\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-tableau-dynamique-en-vba-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"array dinamis di vba\" width=\"386\" height=\"292\"><\/figure><\/div><p> Jangan lupa untuk membaca <a href=\"https:\/\/bytecomb.com\/vba-internals-performance-of-fixed-vs-dynamic-arrays\/\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">artikel<\/a> Joshua tentang kinerja array tetap dan dinamis.<\/p><h2 class=\"wp-block-heading\"> Array multidimensi dinamis<\/h2><p> Contoh yang kami gunakan adalah array satu dimensi dan dengan cara yang sama, Anda juga menggunakan pernyataan ReDim untuk membuat array multidimensi dinamis. <\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Dim myArray() As String ReDim myArray(5, 8)<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-57186\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-reseau-dynamique-multidimensionnel-2.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"428\" height=\"310\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Tambahkan elemen baru ke array dinamis di VBA<\/h2><p> Array dinamis tidak akan ada artinya jika Anda tidak dapat menambahkan elemen baru ke dalamnya. Pada contoh berikut, kita akan melihat cara menambahkan elemen baru setelah Anda mendefinisikan ulang jumlah elemen dalam array.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">'declaring array with no element. '--------------------- Dim iNames() As String '--------------------- 'declaring variables to store counter _ 'and elements from the range. '---------------------- Dim iCount As Integer Dim iElement As Integer '---------------------- 'get the last row number to decide the _ 'number of elements for the array. '------------------------------------ iCount = Range(\"A1\").End(xlDown).Row '------------------------------------ 're-defining the elements for the array. '------------------- ReDim iNames(iCount) '------------------- 'using a for loop to add elements in the array 'from the range starting from cell A1 '-------------------------------------------------- For iElement = 1 To iCount iNames(iElement - 1) = Cells(iElement, 1).Value Next iElement '-------------------------------------------------- 'print all the elements from the 'to the immediate window '-------------------- Debug.Print iNames(0) Debug.Print iNames(1) Debug.Print iNames(2) '--------------------<\/code><\/pre><p> Mari kita pahami kode ini langkah demi langkah.<\/p><ol type=\"1\"><li> Pada langkah pertama, Anda mendeklarasikan array dengan nama &#8220;myArray&#8221;.<\/li><li> Setelah itu Anda memiliki dua variabel untuk menyimpan nilai penghitung untuk loop yang nantinya perlu Anda gunakan dalam kode untuk mendapatkan nilai dari rentang dan menambahkan nilai tersebut sebagai elemen ke dalam array.<\/li><li> Kemudian Anda memiliki sebaris kode untuk mendapatkan baris terakhir dari rentang yang membantu Anda mengetahui elemen mana yang perlu Anda tambahkan ke array.<\/li><li> Pada langkah keempat, Anda menggunakan pernyataan ReDim untuk mendefinisikan ulang elemen array menggunakan nomor baris terakhir yang diperoleh pada langkah sebelumnya.<\/li><li> Kemudian Anda memiliki FOR LOOP (Untuk Berikutnya) yang mengulang rentang mulai dari sel A1, mengambil nilai dari sana dan menambahkannya sebagai elemen ke array satu per satu.<\/li><li> Pada akhirnya, Anda memiliki pernyataan Debug.Print untuk mencetak semua item di <a href=\"https:\/\/exceladvisor.org\/id\/pencetakan-debug-jendela-segera\/\">jendela langsung<\/a> . <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-57187\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-ajouter-un-nouvel-element-au-tableau-dynamique-3.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"623\" height=\"329\"><\/figure><\/div><p> Dan ketika saya menambahkan nilai baru ke rentang dan menjalankan kode lagi, secara otomatis menambahkan elemen tersebut ke array dan mencetaknya ke <a href=\"https:\/\/exceladvisor.org\/id\/pencetakan-debug-jendela-segera\/\">window langsung<\/a> . <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-57188\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-ajouter-une-nouvelle-valeur-a-la-plage-4.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"549\" height=\"397\"><\/figure><\/div><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\/ukuran-susunan\/\">Panjang array VBA (ukuran)<\/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><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-50067b57\"><div class=\"gb-container gb-container-50067b57\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/id\/susunan-lingkaran-vba\/\">Perulangan VBA dalam array<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/array-multidimensi\/\">VBA array multidimensi<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/pantai-memiliki-lukisan\/\">Rentang VBA ke array<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/meja-penyortiran\/\">Tabel keluaran VBA<\/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-1526","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>\u25b7 Bagaimana cara membuat tabel dinamis di VBA (ReDim)?<\/title>\n<meta name=\"description\" content=\"Dalam tutorial ini, Anda mempelajari cara membuat tabel dinamis di mana Anda bisa mengubah ukuran tabel.\" \/>\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\/tabel-dinamis\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 Bagaimana cara membuat tabel dinamis di VBA (ReDim)?\" \/>\n<meta property=\"og:description\" content=\"Dalam tutorial ini, Anda mempelajari cara membuat tabel dinamis di mana Anda bisa mengubah ukuran tabel.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/tabel-dinamis\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:13:54+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-tableau-dynamique-en-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\/tabel-dinamis\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/tabel-dinamis\/\",\"name\":\"\u25b7 Bagaimana cara membuat tabel dinamis di VBA (ReDim)?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/tabel-dinamis\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/tabel-dinamis\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-tableau-dynamique-en-vba-1.png\",\"datePublished\":\"2023-11-17T21:36:05+00:00\",\"dateModified\":\"2023-12-06T06:13:54+00:00\",\"description\":\"Dalam tutorial ini, Anda mempelajari cara membuat tabel dinamis di mana Anda bisa mengubah ukuran tabel.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/tabel-dinamis\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/tabel-dinamis\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/tabel-dinamis\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-tableau-dynamique-en-vba-1.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-tableau-dynamique-en-vba-1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/tabel-dinamis\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara membuat tabel dinamis di 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":"\u25b7 Bagaimana cara membuat tabel dinamis di VBA (ReDim)?","description":"Dalam tutorial ini, Anda mempelajari cara membuat tabel dinamis di mana Anda bisa mengubah ukuran tabel.","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\/tabel-dinamis\/","og_locale":"id_ID","og_type":"article","og_title":"\u25b7 Bagaimana cara membuat tabel dinamis di VBA (ReDim)?","og_description":"Dalam tutorial ini, Anda mempelajari cara membuat tabel dinamis di mana Anda bisa mengubah ukuran tabel.","og_url":"https:\/\/exceladvisor.org\/id\/tabel-dinamis\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:13:54+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-tableau-dynamique-en-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\/tabel-dinamis\/","url":"https:\/\/exceladvisor.org\/id\/tabel-dinamis\/","name":"\u25b7 Bagaimana cara membuat tabel dinamis di VBA (ReDim)?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/tabel-dinamis\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/tabel-dinamis\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-tableau-dynamique-en-vba-1.png","datePublished":"2023-11-17T21:36:05+00:00","dateModified":"2023-12-06T06:13:54+00:00","description":"Dalam tutorial ini, Anda mempelajari cara membuat tabel dinamis di mana Anda bisa mengubah ukuran tabel.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/tabel-dinamis\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/tabel-dinamis\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/tabel-dinamis\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-tableau-dynamique-en-vba-1.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-tableau-dynamique-en-vba-1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/tabel-dinamis\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara membuat tabel dinamis di 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\/1526","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=1526"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1526\/revisions"}],"predecessor-version":[{"id":2318,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1526\/revisions\/2318"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1526"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}