{"id":1531,"date":"2023-11-17T19:29:27","date_gmt":"2023-11-17T19:29:27","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/menghapus-papan\/"},"modified":"2023-12-06T06:19:28","modified_gmt":"2023-12-06T06:19:28","slug":"menghapus-papan","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/menghapus-papan\/","title":{"rendered":"Bagaimana cara menghapus tabel di vba?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-395428281\"><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>Anda perlu menggunakan pernyataan \u201cHapus\u201d untuk menghapus array di VBA. Tambahkan kata kunci &#8220;Erase&#8221; sebelum nama tabel yang ingin Anda hapus, namun perhatikan bahwa semua nilai akan direset dari tabel. Pada tabel berikut Anda memiliki 3 elemen dan kami menggunakan pernyataan hapus untuk menghapus semuanya. <\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub myMacro1() Dim myArray() As Long ReDim myArray(4) myArray(1) = 1 myArray(2) = 2 myArray(3) = 3 myArray(4) = 4 ReDim myArray(1 To 5) MsgBox myArray(3) End Sub<\/code> <\/pre><div class=\"wp-block-image is-style-default\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-57463\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/tableau-clair-vba.png\" sizes=\"auto, \" srcset=\"\" alt=\"vba-clear-array\" width=\"732\" height=\"419\"><\/figure><\/div><p> Dan dengan pernyataan ini, ia menghapus semua elemen dari array, dan ketika kita menggunakan <a href=\"https:\/\/exceladvisor.org\/id\/pencetakan-debug-jendela-segera\/\">Debug.Print (Jendela Segera)<\/a> untuk mendapatkan elemen array, tidak ada yang tersisa.<\/p><h2 class=\"wp-block-heading\"> Hapus tabel dinamis<\/h2><p> Saat Anda menggunakan ReDim, itu akan menghapus semua item. Namun Anda dapat menggunakan pernyataan pertahankan untuk mempertahankan beberapa elemen dan menghapus sebagian array. Dalam contoh berikut, kita memiliki sebuah array dan kita telah menghapus sebagian nilai keempat dan kemudian mengatur elemennya kembali ke 5.<\/p><p> Dan jika Anda ingin menghapus sebagian array dinamis.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub myMacro2() Dim myArray() As Long ReDim myArray(1 To 4) myArray(1) = 1 myArray(2) = 2 myArray(3) = 3 myArray(4) = 4 'erase position 4 but preserve the 1,2, and 3 ReDim Preserve myArray(1 To 3) 'redefine the array items to five ReDim Preserve myArray(1 To 5) MsgBox myArray(3) End Sub<\/code><\/pre><h2 class=\"wp-block-heading\"> <strong>Poin penting<\/strong><\/h2><ol type=\"1\"><li> Saat Anda menghapus tabel tetap:<ol><li> Dalam array yang berisi semua nilai string, pernyataan penghapusan akan mengatur ulang semua elemen pada (panjang variabel) menjadi string dengan panjang nol &#8221; &#8221; dan (panjang tetap) menjadi nol.<\/li><li> Dalam array yang berisi nilai numerik, pernyataan penghapusan akan mengatur ulang semua elemen ke nol.<\/li><li> Dalam array yang, sebagai tipe data bervariasi, pernyataan clear akan mengatur ulang semua elemen menjadi kosong.<\/li><li> Dalam array yang berisi objek, pernyataan penghapusan akan mengatur ulang semua elemen menjadi nol.<\/li><li> Dalam array yang berisi objek, pernyataan hapus akan mengatur ulang semua elemen jika itu adalah variabel terpisah.<\/li><\/ol><\/li><li> Saat Anda menghapus array dinamis, pernyataan hapus akan mengosongkan ruang yang digunakan oleh array dinamis.<\/li><\/ol><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\/tabel-dinamis\/\">VBA tabel dinamis<\/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-1531","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 menghapus tabel di VBA? (Tutorial 2023)<\/title>\n<meta name=\"description\" content=\"Anda perlu menggunakan pernyataan \u201cHapus\u201d untuk menghapus array di VBA. Tambahkan kata kunci \u201cErase\u201d sebelum nama tabel Anda\" \/>\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\/menghapus-papan\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 Bagaimana cara menghapus tabel di VBA? (Tutorial 2023)\" \/>\n<meta property=\"og:description\" content=\"Anda perlu menggunakan pernyataan \u201cHapus\u201d untuk menghapus array di VBA. Tambahkan kata kunci \u201cErase\u201d sebelum nama tabel Anda\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/menghapus-papan\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:19:28+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/tableau-clair-vba.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\/menghapus-papan\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/menghapus-papan\/\",\"name\":\"\u25b7 Bagaimana cara menghapus tabel di VBA? (Tutorial 2023)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/menghapus-papan\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/menghapus-papan\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/tableau-clair-vba.png\",\"datePublished\":\"2023-11-17T19:29:27+00:00\",\"dateModified\":\"2023-12-06T06:19:28+00:00\",\"description\":\"Anda perlu menggunakan pernyataan \u201cHapus\u201d untuk menghapus array di VBA. Tambahkan kata kunci \u201cErase\u201d sebelum nama tabel Anda\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/menghapus-papan\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/menghapus-papan\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/menghapus-papan\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/tableau-clair-vba.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/tableau-clair-vba.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/menghapus-papan\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara menghapus tabel 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 menghapus tabel di VBA? (Tutorial 2023)","description":"Anda perlu menggunakan pernyataan \u201cHapus\u201d untuk menghapus array di VBA. Tambahkan kata kunci \u201cErase\u201d sebelum nama tabel Anda","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\/menghapus-papan\/","og_locale":"id_ID","og_type":"article","og_title":"\u25b7 Bagaimana cara menghapus tabel di VBA? (Tutorial 2023)","og_description":"Anda perlu menggunakan pernyataan \u201cHapus\u201d untuk menghapus array di VBA. Tambahkan kata kunci \u201cErase\u201d sebelum nama tabel Anda","og_url":"https:\/\/exceladvisor.org\/id\/menghapus-papan\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:19:28+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/tableau-clair-vba.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\/menghapus-papan\/","url":"https:\/\/exceladvisor.org\/id\/menghapus-papan\/","name":"\u25b7 Bagaimana cara menghapus tabel di VBA? (Tutorial 2023)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/menghapus-papan\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/menghapus-papan\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/tableau-clair-vba.png","datePublished":"2023-11-17T19:29:27+00:00","dateModified":"2023-12-06T06:19:28+00:00","description":"Anda perlu menggunakan pernyataan \u201cHapus\u201d untuk menghapus array di VBA. Tambahkan kata kunci \u201cErase\u201d sebelum nama tabel Anda","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/menghapus-papan\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/menghapus-papan\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/menghapus-papan\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/tableau-clair-vba.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/tableau-clair-vba.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/menghapus-papan\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara menghapus tabel 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\/1531","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=1531"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1531\/revisions"}],"predecessor-version":[{"id":2856,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1531\/revisions\/2856"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1531"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}