{"id":630,"date":"2023-10-16T11:29:27","date_gmt":"2023-10-16T11:29:27","guid":{"rendered":"https:\/\/exceladvisor.org\/es\/error-de-indice-fuera-de-rango-9\/"},"modified":"2023-12-25T10:27:22","modified_gmt":"2023-12-25T10:27:22","slug":"error-de-indice-fuera-de-rango-9","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/es\/error-de-indice-fuera-de-rango-9\/","title":{"rendered":"\u00bfc\u00f3mo solucionar el error 9 de vba (\u00edndice fuera de rango)?"},"content":{"rendered":"<div class=\"excel-antes-del-contenido\" id=\"excel-3239684796\"><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\">\u00cdndice fuera de rango (tiempo de ejecuci\u00f3n: error 9)<\/h2>\n<p> El error Sub\u00edndice fuera de rango (tiempo de ejecuci\u00f3n: error 9) ocurre cuando hace referencia a un objeto o intenta usar una variable en el c\u00f3digo que no existe en el c\u00f3digo; en este caso, VBA mostrar\u00e1 este error. Como cada c\u00f3digo que escribes es \u00fanico, la causa del error ser\u00eda. <\/p>\n<div class=\"wp-block-image\">\n<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=\"\u00edndice fuera de rango\" width=\"392\" height=\"221\"><\/figure>\n<\/div>\n<p> En el siguiente ejemplo, intent\u00f3 activar \u00abHoja1\u00bb, que es un objeto. Pero como puede ver en el libro de trabajo, no existe ninguna hoja de trabajo con el nombre \u00abHoja1\u00bb (en su lugar tiene \u00abHoja2\u00bb), por lo que VBA muestra \u00abSub\u00edndice fuera de rango\u00bb para informarle que hay alg\u00fan problema con el c\u00f3digo. <\/p>\n<div class=\"wp-block-image\">\n<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>\n<\/div>\n<h2 class=\"wp-block-heading\"> \u00cdndice fuera de rango<\/h2>\n<p> Puede haber otra situaci\u00f3n en la que tenga que enfrentar el error \u00abSub\u00edndice fuera de rango\u00bb cuando intenta declarar una matriz din\u00e1mica pero olvida usar las declaraciones DIM y ReDim para redefinir la longitud de la matriz. <\/p>\n<div class=\"wp-block-image\">\n<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>\n<\/div>\n<p> Ahora, en el c\u00f3digo anterior, tiene una matriz con el nombre \u00abmyArray\u00bb y, para hacerla din\u00e1mica, inicialmente dejamos la longitud de la matriz vac\u00eda. Pero antes de agregar un elemento, debe redefinir la longitud de la matriz usando la declaraci\u00f3n ReDim.<\/p>\n<p> Y este es el error que cometimos en el c\u00f3digo anterior y VBA devolvi\u00f3 el error \u00abScript fuera de rango\u00bb.<\/p>\n<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>\n<h2 class=\"wp-block-heading\"> \u00bfC\u00f3mo arreglar el \u00edndice fuera de rango en Excel?<\/h2>\n<p> La mejor manera de lidiar con este \u00edndice fuera de rango es escribir c\u00f3digos eficientes y asegurarse de depurar el c\u00f3digo que ha escrito (paso a paso). <\/p>\n<div class=\"wp-block-image\">\n<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>\n<\/div>\n<p> Cuando ejecuta un c\u00f3digo paso a paso, es f\u00e1cil para usted saber en qu\u00e9 l\u00ednea de ese c\u00f3digo tiene un error porque VBA le mostrar\u00e1 el mensaje de error 9 y resaltar\u00e1 esa l\u00ednea en amarillo.<\/p>\n<p> La otra cosa que puedes hacer es usar un \u00abcontrolador de errores\u00bb para saltar a una l\u00ednea de error espec\u00edfica cuando ocurra.<\/p>\n<p> En el siguiente c\u00f3digo, escribimos una l\u00ednea para activar la hoja, pero antes de eso, usamos la instrucci\u00f3n goto para pasar al controlador de errores. En el controlador de errores tiene un cuadro de mensaje que le muestra un mensaje con el mensaje Err. Descripci\u00f3n de que se ha producido un error. <\/p>\n<div class=\"wp-block-image\">\n<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>\n<\/div>\n<p> Entonces, cuando ejecuta este c\u00f3digo y \u00abHoja1\u00bb no est\u00e1 en el libro de trabajo donde intenta activarlo. Le mostrar\u00e1 un cuadro de mensaje como el siguiente. <\/p>\n<div class=\"wp-block-image\">\n<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>\n<\/div>\n<p> Y si la \u00abHoja1\u00bb est\u00e1 ah\u00ed, no habr\u00e1 ning\u00fan mensaje.<\/p>\n<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>\n<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\/es\/vba\/\">\u00bfQu\u00e9 es VBA?<\/a><\/p>\n<h2 class=\"gb-headline gb-headline-665e5f6b gb-headline-text gb-headline-mt-heading\"> Tutoriales relacionados <\/h2>\n<div class=\"gb-grid-wrapper gb-grid-wrapper-a20baf7c gb-grid-wrapper-mt-grid\">\n<div class=\"gb-grid-column gb-grid-column-65ddf67e\">\n<div class=\"gb-container gb-container-65ddf67e\">\n<ul>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/manejo-de-errores\/\">Manejo de errores de VBA<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/error-de-automatizacion-440\/\">Error de automatizaci\u00f3n de VBA (Error 440)<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/error-400\/\">Error 400 de VBA<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/error-de-objeto-requerido-424\/\">Error de objeto VBA requerido (Error 424)<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/error-de-memoria-insuficiente-7\/\">Error de VBA sin memoria (Error 7)<\/a> <\/li>\n<\/ul>\n<\/div>\n<\/div>\n<div class=\"gb-grid-column gb-grid-column-50067b57\">\n<div class=\"gb-container gb-container-50067b57\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>\u00cdndice fuera de rango (tiempo de ejecuci\u00f3n: error 9) El error Sub\u00edndice fuera de rango (tiempo de ejecuci\u00f3n: error 9) ocurre cuando hace referencia a un objeto o intenta usar una variable en el c\u00f3digo que no existe en el c\u00f3digo; en este caso, VBA mostrar\u00e1 este error. Como cada c\u00f3digo que escribes es \u00fanico, [&hellip;]<\/p>\n","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-630","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>\u00bfc\u00f3mo solucionar el error 9 de vba (\u00edndice fuera de rango)?<\/title>\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\/es\/error-de-indice-fuera-de-rango-9\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u00bfc\u00f3mo solucionar el error 9 de vba (\u00edndice fuera de rango)?\" \/>\n<meta property=\"og:description\" content=\"\u00cdndice fuera de rango (tiempo de ejecuci\u00f3n: error 9) El error Sub\u00edndice fuera de rango (tiempo de ejecuci\u00f3n: error 9) ocurre cuando hace referencia a un objeto o intenta usar una variable en el c\u00f3digo que no existe en el c\u00f3digo; en este caso, VBA mostrar\u00e1 este error. Como cada c\u00f3digo que escribes es \u00fanico, [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/es\/error-de-indice-fuera-de-rango-9\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-25T10:27:22+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=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data1\" content=\"3 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/es\/error-de-indice-fuera-de-rango-9\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/error-de-indice-fuera-de-rango-9\/\",\"name\":\"\u00bfc\u00f3mo solucionar el error 9 de vba (\u00edndice fuera de rango)?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/error-de-indice-fuera-de-rango-9\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/error-de-indice-fuera-de-rango-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-25T10:27:22+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/error-de-indice-fuera-de-rango-9\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/es\/error-de-indice-fuera-de-rango-9\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/error-de-indice-fuera-de-rango-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\/es\/error-de-indice-fuera-de-rango-9\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Hogar\",\"item\":\"https:\/\/exceladvisor.org\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u00bfc\u00f3mo solucionar el error 9 de vba (\u00edndice fuera de rango)?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\",\"url\":\"https:\/\/exceladvisor.org\/es\/\",\"name\":\"Excel Advisor\",\"description\":\"Su gu\u00eda para la dominaci\u00f3n de datos!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/es\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/es\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u00bfc\u00f3mo solucionar el error 9 de vba (\u00edndice fuera de rango)?","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\/es\/error-de-indice-fuera-de-rango-9\/","og_locale":"es_ES","og_type":"article","og_title":"\u00bfc\u00f3mo solucionar el error 9 de vba (\u00edndice fuera de rango)?","og_description":"\u00cdndice fuera de rango (tiempo de ejecuci\u00f3n: error 9) El error Sub\u00edndice fuera de rango (tiempo de ejecuci\u00f3n: error 9) ocurre cuando hace referencia a un objeto o intenta usar una variable en el c\u00f3digo que no existe en el c\u00f3digo; en este caso, VBA mostrar\u00e1 este error. Como cada c\u00f3digo que escribes es \u00fanico, [&hellip;]","og_url":"https:\/\/exceladvisor.org\/es\/error-de-indice-fuera-de-rango-9\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-25T10:27:22+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":{"Tiempo de lectura":"3 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/es\/error-de-indice-fuera-de-rango-9\/","url":"https:\/\/exceladvisor.org\/es\/error-de-indice-fuera-de-rango-9\/","name":"\u00bfc\u00f3mo solucionar el error 9 de vba (\u00edndice fuera de rango)?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/es\/error-de-indice-fuera-de-rango-9\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/error-de-indice-fuera-de-rango-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-25T10:27:22+00:00","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/es\/error-de-indice-fuera-de-rango-9\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/es\/error-de-indice-fuera-de-rango-9\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/error-de-indice-fuera-de-rango-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\/es\/error-de-indice-fuera-de-rango-9\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Hogar","item":"https:\/\/exceladvisor.org\/es\/"},{"@type":"ListItem","position":2,"name":"\u00bfc\u00f3mo solucionar el error 9 de vba (\u00edndice fuera de rango)?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/es\/#website","url":"https:\/\/exceladvisor.org\/es\/","name":"Excel Advisor","description":"Su gu\u00eda para la dominaci\u00f3n de datos!","publisher":{"@id":"https:\/\/exceladvisor.org\/es\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/es\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/es\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/es\/","logo":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/630","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/comments?post=630"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/630\/revisions"}],"predecessor-version":[{"id":1196,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/630\/revisions\/1196"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/media?parent=630"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}