{"id":2104,"date":"2023-10-16T11:29:27","date_gmt":"2023-10-16T11:29:27","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/kesalahan-indeks-di-luar-kisaran-9\/"},"modified":"2023-12-06T06:14:54","modified_gmt":"2023-12-06T06:14:54","slug":"kesalahan-indeks-di-luar-kisaran-9","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/kesalahan-indeks-di-luar-kisaran-9\/","title":{"rendered":"Bagaimana cara memperbaiki kesalahan vba 9 (indeks di luar jangkauan)?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-1832799148\"><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\">Indeks di luar jangkauan (runtime: error 9)<\/h2><p> Kesalahan Subskrip Di Luar Jangkauan (Waktu Berjalan: Kesalahan 9) terjadi ketika Anda merujuk ke suatu objek atau mencoba menggunakan variabel dalam kode yang tidak ada dalam kode, dalam hal ini VBA akan menampilkan kesalahan ini. Karena setiap kode yang Anda tulis adalah unik, penyebab kesalahannya adalah. <\/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=\"indeks di luar jangkauan\" width=\"392\" height=\"221\"><\/figure><\/div><p> Pada contoh berikut, Anda mencoba mengaktifkan &#8220;Sheet1&#8221; yang merupakan sebuah objek. Namun seperti yang Anda lihat di buku kerja, tidak ada lembar kerja dengan nama &#8220;Sheet1&#8221; (sebaliknya Anda memiliki &#8220;Sheet2&#8221;), jadi VBA menampilkan &#8220;Subskrip Di Luar Jangkauan&#8221; untuk memberi tahu Anda bahwa ada yang salah dengan kode tersebut. <\/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\"> Indeks di luar jangkauan<\/h2><p> Mungkin ada situasi lain di mana Anda harus menghadapi kesalahan \u201cKesalahan Subskrip Di Luar Jangkauan\u201d ketika Anda mencoba mendeklarasikan array dinamis tetapi lupa menggunakan pernyataan DIM dan ReDim untuk mendefinisikan ulang panjang array. <\/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> Sekarang dalam kode di atas Anda memiliki array dengan nama &#8220;myArray&#8221; dan untuk membuatnya dinamis, pertama-tama kita biarkan panjang array kosong. Namun sebelum menambahkan elemen, Anda perlu mendefinisikan ulang panjang array menggunakan pernyataan ReDim.<\/p><p> Dan ini adalah kesalahan yang kami buat pada kode di atas dan VBA mengembalikan kesalahan \u201cScript out of range\u201d.<\/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\"> Bagaimana cara memperbaiki indeks di luar jangkauan di Excel?<\/h2><p> Cara terbaik untuk mengatasi indeks di luar jangkauan ini adalah dengan menulis kode yang efisien dan pastikan untuk men-debug kode yang telah Anda tulis (langkah demi langkah). <\/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> Saat Anda menjalankan kode langkah demi langkah, mudah bagi Anda untuk mengetahui baris kode mana yang mengalami kesalahan karena VBA akan menampilkan pesan kesalahan untuk kesalahan 9 dan menyorot baris tersebut dengan warna kuning.<\/p><p> Hal lain yang dapat Anda lakukan adalah menggunakan &#8220;penanganan kesalahan&#8221; untuk melompat ke baris kesalahan tertentu ketika kesalahan itu terjadi.<\/p><p> Dalam kode berikut, kami telah menulis baris untuk mengaktifkan sheet tetapi sebelum itu, kami menggunakan pernyataan goto untuk meneruskan ke penangan kesalahan. Di pengendali kesalahan Anda memiliki kotak pesan yang menampilkan pesan dengan Err. Deskripsi bahwa telah terjadi kesalahan. <\/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> Jadi ketika Anda menjalankan kode ini dan &#8220;Sheet1&#8221; tidak ada di buku kerja tempat Anda mencoba mengaktifkannya. Ini akan menampilkan kotak pesan seperti di bawah ini. <\/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> Dan jika &#8220;Sheet1&#8221; ada, tidak akan ada pesan sama sekali.<\/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\/id\/vba\/\">Apa itu VBA<\/a><h2 class=\"gb-headline gb-headline-665e5f6b gb-headline-text gb-headline-mt-heading\"> Tutorial terkait <\/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\/penanganan-kesalahan\/\">Penanganan kesalahan VBA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/kesalahan-otomatisasi-440\/\">Kesalahan otomatisasi VBA (Kesalahan 440)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/kesalahan-400\/\">Kesalahan VBA 400<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/objek-diperlukan-kesalahan-424\/\">Kesalahan yang Diperlukan Objek VBA (Kesalahan 424)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/kesalahan-kehabisan-memori-7\/\">Kesalahan VBA Kehabisan Memori (Kesalahan 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-2104","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 memperbaiki kesalahan VBA 9 (subskrip di luar jangkauan)?<\/title>\n<meta name=\"description\" content=\"Dalam tutorial ini Anda akan mempelajari penyebab terjadinya Subscript Out of Range (Error 9) dan cara mengatasinya saat menulis\" \/>\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\/kesalahan-indeks-di-luar-kisaran-9\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 Bagaimana cara memperbaiki kesalahan VBA 9 (subskrip di luar jangkauan)?\" \/>\n<meta property=\"og:description\" content=\"Dalam tutorial ini Anda akan mempelajari penyebab terjadinya Subscript Out of Range (Error 9) dan cara mengatasinya saat menulis\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/kesalahan-indeks-di-luar-kisaran-9\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:14:54+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=\"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\/kesalahan-indeks-di-luar-kisaran-9\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/kesalahan-indeks-di-luar-kisaran-9\/\",\"name\":\"\u25b7 Bagaimana cara memperbaiki kesalahan VBA 9 (subskrip di luar jangkauan)?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/kesalahan-indeks-di-luar-kisaran-9\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/kesalahan-indeks-di-luar-kisaran-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-06T06:14:54+00:00\",\"description\":\"Dalam tutorial ini Anda akan mempelajari penyebab terjadinya Subscript Out of Range (Error 9) dan cara mengatasinya saat menulis\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/kesalahan-indeks-di-luar-kisaran-9\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/kesalahan-indeks-di-luar-kisaran-9\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/kesalahan-indeks-di-luar-kisaran-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\/id\/kesalahan-indeks-di-luar-kisaran-9\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara memperbaiki kesalahan vba 9 (indeks di luar jangkauan)?\"}]},{\"@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 memperbaiki kesalahan VBA 9 (subskrip di luar jangkauan)?","description":"Dalam tutorial ini Anda akan mempelajari penyebab terjadinya Subscript Out of Range (Error 9) dan cara mengatasinya saat menulis","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\/kesalahan-indeks-di-luar-kisaran-9\/","og_locale":"id_ID","og_type":"article","og_title":"\u25b7 Bagaimana cara memperbaiki kesalahan VBA 9 (subskrip di luar jangkauan)?","og_description":"Dalam tutorial ini Anda akan mempelajari penyebab terjadinya Subscript Out of Range (Error 9) dan cara mengatasinya saat menulis","og_url":"https:\/\/exceladvisor.org\/id\/kesalahan-indeks-di-luar-kisaran-9\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:14:54+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":{"Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/id\/kesalahan-indeks-di-luar-kisaran-9\/","url":"https:\/\/exceladvisor.org\/id\/kesalahan-indeks-di-luar-kisaran-9\/","name":"\u25b7 Bagaimana cara memperbaiki kesalahan VBA 9 (subskrip di luar jangkauan)?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/kesalahan-indeks-di-luar-kisaran-9\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/kesalahan-indeks-di-luar-kisaran-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-06T06:14:54+00:00","description":"Dalam tutorial ini Anda akan mempelajari penyebab terjadinya Subscript Out of Range (Error 9) dan cara mengatasinya saat menulis","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/kesalahan-indeks-di-luar-kisaran-9\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/kesalahan-indeks-di-luar-kisaran-9\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/kesalahan-indeks-di-luar-kisaran-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\/id\/kesalahan-indeks-di-luar-kisaran-9\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara memperbaiki kesalahan vba 9 (indeks di luar jangkauan)?"}]},{"@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\/2104","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=2104"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2104\/revisions"}],"predecessor-version":[{"id":2379,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2104\/revisions\/2379"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=2104"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}