{"id":1531,"date":"2023-11-17T19:29:27","date_gmt":"2023-11-17T19:29:27","guid":{"rendered":"https:\/\/exceladvisor.org\/nl\/wis-het-bord\/"},"modified":"2023-12-06T05:50:15","modified_gmt":"2023-12-06T05:50:15","slug":"wis-het-bord","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/nl\/wis-het-bord\/","title":{"rendered":"Hoe maak je een tabel leeg in vba?"},"content":{"rendered":"<div class=\"excel-voor-de-inhoud\" id=\"excel-3685924706\"><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>U moet de instructie &#8220;Erase&#8221; gebruiken om een array in VBA te wissen. Voeg het trefwoord &#8220;Wissen&#8221; toe v\u00f3\u00f3r de naam van de tabel die u wilt wissen, maar houd er rekening mee dat alle waarden uit de tabel opnieuw worden ingesteld. In de volgende tabel heb je 3 elementen en we hebben de erase-instructie gebruikt om alles te wissen. <\/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> En met deze verklaring werden alle elementen uit de array gewist, en als we <a href=\"https:\/\/exceladvisor.org\/nl\/onmiddellijke-vensterfoutopsporing-afdrukken\/\">Debug.Print (Immediate Window)<\/a> gebruiken om het array-element op te halen, is er niets meer over.<\/p><h2 class=\"wp-block-heading\"> Duidelijke dynamische tabel<\/h2><p> Wanneer u ReDim gebruikt, worden alle items verwijderd. Maar u kunt de instructie &#8216;behoud&#8217; gebruiken om enkele elementen te behouden en een array gedeeltelijk te wissen. In het volgende voorbeeld hebben we een array en hebben we de vierde waarde gedeeltelijk gewist en vervolgens de elementen teruggezet op 5.<\/p><p> En als u een dynamische array gedeeltelijk wilt wissen.<\/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>Belangrijke punten<\/strong><\/h2><ol type=\"1\"><li> Wanneer u een vaste tafel afruimt:<ol><li> In een array die alle waarden van een string bevat, zal de erase-instructie alle elementen op (variabele lengte) resetten naar de string &#8221; &#8221; met lengte nul en (vaste lengte) naar nul.<\/li><li> In een array met numerieke waarden zal de erase-instructie alle elementen terugzetten op nul.<\/li><li> In een array die, bij een vari\u00ebrend gegevenstype, duidelijke instructies alle elementen op leeg zetten.<\/li><li> In een array met objecten zal de erase-instructie alle elementen op nul zetten.<\/li><li> In een array die objecten bevat, zal de erase-instructie alle elementen resetten als het een afzonderlijke variabele was.<\/li><\/ol><\/li><li> Wanneer u een dynamische array wist, maakt de erase-instructie de ruimte vrij die door de dynamische array wordt gebruikt.<\/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\/nl\/vba\/\">Wat is VBA<\/a><h2 class=\"gb-headline gb-headline-665e5f6b gb-headline-text gb-headline-mt-heading\"> Meer informatie over <a href=\"https:\/\/exceladvisor.org\/nl\/schilderijen\/\">VBA-tabellen<\/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\/nl\/voeg-een-nieuwe-reeks-waarden-toe\/\">VBA Voeg nieuwe waarde toe aan array<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/array-grootte\/\">VBA-arraylengte (grootte)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/tafel-met-kettingen\/\">VBA-array met tekenreeksen<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/dynamische-tafel\/\">Dynamische tabel 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\/nl\/vba-lusarray\/\">VBA-lus in een array<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/multidimensionale-array\/\">Multidimensionale array VBA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/strand-heeft-een-schilderij\/\">VBA-bereik naar een array<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/sorteertafel\/\">VBA-uitvoertabel<\/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 Hoe maak ik een tabel leeg in VBA? (Tutorial 2023)<\/title>\n<meta name=\"description\" content=\"U moet de instructie &quot;Erase&quot; gebruiken om een array in VBA te wissen. Voeg het trefwoord \u201cWissen\u201d toe v\u00f3\u00f3r de naam van de tabel die u gebruikt\" \/>\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\/nl\/wis-het-bord\/\" \/>\n<meta property=\"og:locale\" content=\"nl_NL\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 Hoe maak ik een tabel leeg in VBA? (Tutorial 2023)\" \/>\n<meta property=\"og:description\" content=\"U moet de instructie &quot;Erase&quot; gebruiken om een array in VBA te wissen. Voeg het trefwoord \u201cWissen\u201d toe v\u00f3\u00f3r de naam van de tabel die u gebruikt\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/nl\/wis-het-bord\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T05:50:15+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=\"Geschatte leestijd\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minuten\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/wis-het-bord\/\",\"url\":\"https:\/\/exceladvisor.org\/nl\/wis-het-bord\/\",\"name\":\"\u25b7 Hoe maak ik een tabel leeg in VBA? (Tutorial 2023)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/wis-het-bord\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/wis-het-bord\/#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-06T05:50:15+00:00\",\"description\":\"U moet de instructie &quot;Erase&quot; gebruiken om een array in VBA te wissen. Voeg het trefwoord \u201cWissen\u201d toe v\u00f3\u00f3r de naam van de tabel die u gebruikt\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/wis-het-bord\/#breadcrumb\"},\"inLanguage\":\"nl-NL\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/nl\/wis-het-bord\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/wis-het-bord\/#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\/nl\/wis-het-bord\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Thuis\",\"item\":\"https:\/\/exceladvisor.org\/nl\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Hoe maak je een tabel leeg in vba?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/#website\",\"url\":\"https:\/\/exceladvisor.org\/nl\/\",\"name\":\"Excel Advisor\",\"description\":\"Uw gids voor datadominantie\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/nl\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"nl-NL\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/nl\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/nl\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/nl\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u25b7 Hoe maak ik een tabel leeg in VBA? (Tutorial 2023)","description":"U moet de instructie &quot;Erase&quot; gebruiken om een array in VBA te wissen. Voeg het trefwoord \u201cWissen\u201d toe v\u00f3\u00f3r de naam van de tabel die u gebruikt","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\/nl\/wis-het-bord\/","og_locale":"nl_NL","og_type":"article","og_title":"\u25b7 Hoe maak ik een tabel leeg in VBA? (Tutorial 2023)","og_description":"U moet de instructie &quot;Erase&quot; gebruiken om een array in VBA te wissen. Voeg het trefwoord \u201cWissen\u201d toe v\u00f3\u00f3r de naam van de tabel die u gebruikt","og_url":"https:\/\/exceladvisor.org\/nl\/wis-het-bord\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T05:50:15+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":{"Geschatte leestijd":"2 minuten"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/nl\/wis-het-bord\/","url":"https:\/\/exceladvisor.org\/nl\/wis-het-bord\/","name":"\u25b7 Hoe maak ik een tabel leeg in VBA? (Tutorial 2023)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/nl\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/nl\/wis-het-bord\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/nl\/wis-het-bord\/#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-06T05:50:15+00:00","description":"U moet de instructie &quot;Erase&quot; gebruiken om een array in VBA te wissen. Voeg het trefwoord \u201cWissen\u201d toe v\u00f3\u00f3r de naam van de tabel die u gebruikt","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/nl\/wis-het-bord\/#breadcrumb"},"inLanguage":"nl-NL","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/nl\/wis-het-bord\/"]}]},{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/exceladvisor.org\/nl\/wis-het-bord\/#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\/nl\/wis-het-bord\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Thuis","item":"https:\/\/exceladvisor.org\/nl\/"},{"@type":"ListItem","position":2,"name":"Hoe maak je een tabel leeg in vba?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/nl\/#website","url":"https:\/\/exceladvisor.org\/nl\/","name":"Excel Advisor","description":"Uw gids voor datadominantie","publisher":{"@id":"https:\/\/exceladvisor.org\/nl\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/nl\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"nl-NL"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/nl\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/nl\/","logo":{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/exceladvisor.org\/nl\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/nl\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/nl\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/nl\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/1531","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/comments?post=1531"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/1531\/revisions"}],"predecessor-version":[{"id":2696,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/1531\/revisions\/2696"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/media?parent=1531"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}