{"id":2103,"date":"2023-10-16T11:29:27","date_gmt":"2023-10-16T11:29:27","guid":{"rendered":"https:\/\/exceladvisor.org\/nl\/indexfout-buiten-bereik-9\/"},"modified":"2023-12-06T05:50:53","modified_gmt":"2023-12-06T05:50:53","slug":"indexfout-buiten-bereik-9","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/nl\/indexfout-buiten-bereik-9\/","title":{"rendered":"Hoe vba-fout 9 (index buiten bereik) oplossen?"},"content":{"rendered":"<div class=\"excel-voor-de-inhoud\" id=\"excel-2121578427\"><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> <h2 class=\"wp-block-heading\">Index buiten bereik (runtime: fout 9)<\/h2><p> De Subscript Out of Range (Run Time: Error 9)-fout treedt op wanneer u naar een object verwijst of een variabele probeert te gebruiken in code die niet in de code voorkomt. In dit geval zal VBA deze fout weergeven. Omdat elke code die u schrijft uniek is, zou de oorzaak van de fout zijn. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-57019\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/01-indice-hors-plage.png\" sizes=\"auto, \" srcset=\"\" alt=\"index buiten bereik\" width=\"392\" height=\"221\"><\/figure><\/div><p> In het volgende voorbeeld hebt u geprobeerd &#8220;Blad1&#8221; te activeren, wat een object is. Maar zoals u in de werkmap kunt zien, bestaat er geen werkblad met de naam &#8220;Blad1&#8221; (in plaats daarvan heeft u &#8220;Blad2&#8221;), dus VBA toont &#8220;Subscript buiten bereik&#8221; om u te informeren dat er iets mis is met de code. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-57020\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/02-activer-la-feuille1.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"493\" height=\"608\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Index buiten bereik<\/h2><p> Er kan zich een andere situatie voordoen waarin u te maken krijgt met de foutmelding \u2018Subscript Out of Range Error\u2019 wanneer u probeert een dynamische array te declareren, maar vergeet de DIM- en ReDim-instructies te gebruiken om de lengte van de array opnieuw te defini\u00ebren. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-57021\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/03-erreur-dindice-hors-plage.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"406\" height=\"434\"><\/figure><\/div><p> Nu heb je in de bovenstaande code een array met de naam \u201cmyArray\u201d en om deze dynamisch te maken laten we in eerste instantie de lengte van de array leeg. Maar voordat u een element toevoegt, moet u de lengte van de array opnieuw defini\u00ebren met behulp van de ReDim-instructie.<\/p><p> En dit is de fout die we hebben gemaakt in de bovenstaande code en VBA retourneerde de fout &#8216;Script buiten bereik&#8217;.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub myMacro() Dim myArray() As Variant myArray(1) = \"One\" End Sub<\/code><\/pre><h2 class=\"wp-block-heading\"> Hoe de index buiten bereik in Excel te repareren?<\/h2><p> De beste manier om met deze buiten bereik-index om te gaan, is door effici\u00ebnte codes te schrijven en ervoor te zorgen dat u de code die u hebt geschreven (stap voor stap) debugt. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-57022\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/04-correction-dune-erreur-dindice-hors-plage.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"464\" height=\"411\"><\/figure><\/div><p> Wanneer u stap voor stap een code uitvoert, kunt u gemakkelijk weten op welke regel van die code een fout zit, omdat VBA u de foutmelding voor fout 9 laat zien en die regel geel markeert.<\/p><p> Het andere dat u kunt doen, is een &#8220;error handler&#8221; gebruiken om naar een specifieke foutregel te springen wanneer deze zich voordoet.<\/p><p> In de volgende code hebben we een regel geschreven om het werkblad te activeren, maar daarvoor gebruikten we de goto-instructie om door te geven aan de foutafhandelaar. In de foutafhandelaar hebt u een berichtvenster waarin u een bericht ziet met de melding Err. Beschrijving dat er een fout is opgetreden. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-57023\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/05-ligne-pour-activer-la-feuille.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"701\" height=\"474\"><\/figure><\/div><p> Dus wanneer u deze code uitvoert en &#8220;Blad1&#8221; niet in de werkmap staat waarin u deze probeert te activeren. Er wordt een berichtvenster weergegeven zoals hieronder. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-57024\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/06-boite-de-message-affichant-une-erreur.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"443\" height=\"182\"><\/figure><\/div><p> En als de &#8220;Blad1&#8221; er is, zal er helemaal geen bericht zijn.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub myMacro() Dim wks As Worksheet On Error GoTo myError Sheets(\"Sheet1\").Activate myError: MsgBox \"There's an error in the code: \" &amp; Err.Description &amp; _ \". That means there's some problem with the sheet \" &amp; _ \"that you want to activate\" End Sub<\/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\/nl\/vba\/\">Wat is VBA<\/a><h2 class=\"gb-headline gb-headline-665e5f6b gb-headline-text gb-headline-mt-heading\"> Gerelateerde tutorials <\/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\/foutafhandeling\/\">VBA-foutafhandeling<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/automatiseringsfout-440\/\">VBA-automatiseringsfout (fout 440)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/fout-400\/\">VBA-fout 400<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/object-vereiste-fout-424\/\">VBA-object vereiste fout (fout 424)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/fout-met-onvoldoende-geheugen-7\/\">VBA-geheugenfout (fout 7)<\/a> <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-50067b57\"><div class=\"gb-container gb-container-50067b57\"><\/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-2103","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 VBA-fout 9 (subscript buiten bereik) oplossen?<\/title>\n<meta name=\"description\" content=\"In deze tutorial leert u waarom Subscript Out of Range (Error 9) optreedt en hoe u hiermee omgaat tijdens het schrijven\" \/>\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\/indexfout-buiten-bereik-9\/\" \/>\n<meta property=\"og:locale\" content=\"nl_NL\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 Hoe VBA-fout 9 (subscript buiten bereik) oplossen?\" \/>\n<meta property=\"og:description\" content=\"In deze tutorial leert u waarom Subscript Out of Range (Error 9) optreedt en hoe u hiermee omgaat tijdens het schrijven\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/nl\/indexfout-buiten-bereik-9\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T05:50:53+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/01-indice-hors-plage.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\/indexfout-buiten-bereik-9\/\",\"url\":\"https:\/\/exceladvisor.org\/nl\/indexfout-buiten-bereik-9\/\",\"name\":\"\u25b7 Hoe VBA-fout 9 (subscript buiten bereik) oplossen?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/indexfout-buiten-bereik-9\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/indexfout-buiten-bereik-9\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/01-indice-hors-plage.png\",\"datePublished\":\"2023-10-16T11:29:27+00:00\",\"dateModified\":\"2023-12-06T05:50:53+00:00\",\"description\":\"In deze tutorial leert u waarom Subscript Out of Range (Error 9) optreedt en hoe u hiermee omgaat tijdens het schrijven\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/indexfout-buiten-bereik-9\/#breadcrumb\"},\"inLanguage\":\"nl-NL\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/nl\/indexfout-buiten-bereik-9\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/indexfout-buiten-bereik-9\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/01-indice-hors-plage.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/01-indice-hors-plage.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/indexfout-buiten-bereik-9\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Thuis\",\"item\":\"https:\/\/exceladvisor.org\/nl\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Hoe vba-fout 9 (index buiten bereik) oplossen?\"}]},{\"@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 VBA-fout 9 (subscript buiten bereik) oplossen?","description":"In deze tutorial leert u waarom Subscript Out of Range (Error 9) optreedt en hoe u hiermee omgaat tijdens het schrijven","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\/indexfout-buiten-bereik-9\/","og_locale":"nl_NL","og_type":"article","og_title":"\u25b7 Hoe VBA-fout 9 (subscript buiten bereik) oplossen?","og_description":"In deze tutorial leert u waarom Subscript Out of Range (Error 9) optreedt en hoe u hiermee omgaat tijdens het schrijven","og_url":"https:\/\/exceladvisor.org\/nl\/indexfout-buiten-bereik-9\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T05:50:53+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/01-indice-hors-plage.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\/indexfout-buiten-bereik-9\/","url":"https:\/\/exceladvisor.org\/nl\/indexfout-buiten-bereik-9\/","name":"\u25b7 Hoe VBA-fout 9 (subscript buiten bereik) oplossen?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/nl\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/nl\/indexfout-buiten-bereik-9\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/nl\/indexfout-buiten-bereik-9\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/01-indice-hors-plage.png","datePublished":"2023-10-16T11:29:27+00:00","dateModified":"2023-12-06T05:50:53+00:00","description":"In deze tutorial leert u waarom Subscript Out of Range (Error 9) optreedt en hoe u hiermee omgaat tijdens het schrijven","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/nl\/indexfout-buiten-bereik-9\/#breadcrumb"},"inLanguage":"nl-NL","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/nl\/indexfout-buiten-bereik-9\/"]}]},{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/exceladvisor.org\/nl\/indexfout-buiten-bereik-9\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/01-indice-hors-plage.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/01-indice-hors-plage.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/nl\/indexfout-buiten-bereik-9\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Thuis","item":"https:\/\/exceladvisor.org\/nl\/"},{"@type":"ListItem","position":2,"name":"Hoe vba-fout 9 (index buiten bereik) oplossen?"}]},{"@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\/2103","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=2103"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/2103\/revisions"}],"predecessor-version":[{"id":2801,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/2103\/revisions\/2801"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/media?parent=2103"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}