{"id":55,"date":"2023-11-17T21:02:46","date_gmt":"2023-11-17T21:02:46","guid":{"rendered":"https:\/\/exceladvisor.org\/es\/matriz-multidimensional\/"},"modified":"2023-12-25T10:25:36","modified_gmt":"2023-12-25T10:25:36","slug":"matriz-multidimensional","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/es\/matriz-multidimensional\/","title":{"rendered":"\u00bfc\u00f3mo crear una tabla multidimensional?"},"content":{"rendered":"<div class=\"excel-antes-del-contenido\" id=\"excel-2583058704\"><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>Para crear una matriz con m\u00faltiples dimensiones, debe definir las dimensiones al declarar la matriz. Bueno, puedes definir tantas dimensiones como quieras (VBA permite 60 dimensiones), pero probablemente no necesitar\u00e1s usar m\u00e1s de 2 o 3 dimensiones de ninguna de las matrices. Usar una tabla bidimensional es como tener filas y columnas.<\/p>\n<p> En este tutorial veremos c\u00f3mo crear una matriz 2D y 3D.<\/p>\n<h2 class=\"wp-block-heading\"> Crear una matriz multidimensional en VBA<\/h2>\n<ol>\n<li> Utilice la <a href=\"https:\/\/exceladvisor.org\/es\/debil\/\">instrucci\u00f3n Dim<\/a> para declarar la matriz con el nombre que desee darle. <br \/><img loading=\"lazy\" decoding=\"async\" title=\"1-matriz-multidimensional-1\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-tableau-multidimensionnel-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"466\" height=\"212\"><\/li>\n<li> Despu\u00e9s de eso, ingrese un par\u00e9ntesis inicial y establezca el n\u00famero de elementos para la primera dimensi\u00f3n. <br \/><img loading=\"lazy\" decoding=\"async\" title=\"2-conjunto-n\u00famero-de-elementos-2\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-definir-le-nombre-delements-2.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"465\" height=\"218\"><\/li>\n<li> A continuaci\u00f3n, escriba un comando e ingrese la cantidad de elementos que desea tener en la segunda dimensi\u00f3n, luego cierre los par\u00e9ntesis. <br \/><img loading=\"lazy\" decoding=\"async\" title=\"3-ingrese-un-recuento-de-art\u00edculos\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-entrez-un-nombre-delements.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"465\" height=\"231\"><\/li>\n<li> Al final, configure el <a href=\"https:\/\/exceladvisor.org\/es\/variables\/\">tipo de datos<\/a> para la tabla como variante o cualquier tipo de datos que desee. <br \/><img loading=\"lazy\" decoding=\"async\" title=\"4-tabla-como-variante-4\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-tableau-en-variante-4.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"512\" height=\"193\"><\/li>\n<\/ol>\n<p> Aqu\u00ed est\u00e1 el c\u00f3digo.<\/p>\n<pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub vba_multi_dimensional_array() Dim myArray(5, 2) As Variant myArray(1, 1) = 1 myArray(2, 1) = 2 myArray(3, 1) = 3 myArray(4, 1) = 4 myArray(5, 1) = 5 myArray(1, 2) = 6 myArray(2, 2) = 7 myArray(3, 2) = 8 myArray(4, 2) = 9 myArray(5, 2) = 10 End Sub<\/code><\/pre>\n<p> El c\u00f3digo anterior para la tabla crea una tabla con 5 filas y 2 columnas y se ver\u00e1 as\u00ed. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-57145\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-cree-un-tableau-5.png\" sizes=\"auto, \" srcset=\"\" alt=\"crear-un-tablero-5\" width=\"158\" height=\"121\"><\/figure>\n<\/div>\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\"> Obtenga m\u00e1s informaci\u00f3n sobre <a href=\"https:\/\/exceladvisor.org\/es\/pinturas\/\">las tablas VBA<\/a> <\/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\/agregar-una-nueva-matriz-de-valores\/\">VBA Agregar nuevo valor a la matriz<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/tamano-de-matriz\/\">Longitud de la matriz VBA (tama\u00f1o)<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/mesa-con-cadenas\/\">Matriz VBA con cadenas<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/borrar-la-pizarra\/\">Matriz clara de VBA<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/tabla-dinamica\/\">Tabla din\u00e1mica VBA<\/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>Para crear una matriz con m\u00faltiples dimensiones, debe definir las dimensiones al declarar la matriz. Bueno, puedes definir tantas dimensiones como quieras (VBA permite 60 dimensiones), pero probablemente no necesitar\u00e1s usar m\u00e1s de 2 o 3 dimensiones de ninguna de las matrices. Usar una tabla bidimensional es como tener filas y columnas. En este tutorial [&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-55","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 crear una tabla multidimensional?<\/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\/matriz-multidimensional\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u00bfc\u00f3mo crear una tabla multidimensional?\" \/>\n<meta property=\"og:description\" content=\"Para crear una matriz con m\u00faltiples dimensiones, debe definir las dimensiones al declarar la matriz. Bueno, puedes definir tantas dimensiones como quieras (VBA permite 60 dimensiones), pero probablemente no necesitar\u00e1s usar m\u00e1s de 2 o 3 dimensiones de ninguna de las matrices. Usar una tabla bidimensional es como tener filas y columnas. En este tutorial [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/es\/matriz-multidimensional\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-25T10:25:36+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-tableau-multidimensionnel-1.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=\"1 minuto\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/es\/matriz-multidimensional\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/matriz-multidimensional\/\",\"name\":\"\u00bfc\u00f3mo crear una tabla multidimensional?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/matriz-multidimensional\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/matriz-multidimensional\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-tableau-multidimensionnel-1.png\",\"datePublished\":\"2023-11-17T21:02:46+00:00\",\"dateModified\":\"2023-12-25T10:25:36+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/matriz-multidimensional\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/es\/matriz-multidimensional\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/matriz-multidimensional\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-tableau-multidimensionnel-1.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-tableau-multidimensionnel-1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/es\/matriz-multidimensional\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Hogar\",\"item\":\"https:\/\/exceladvisor.org\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u00bfc\u00f3mo crear una tabla multidimensional?\"}]},{\"@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 crear una tabla multidimensional?","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\/matriz-multidimensional\/","og_locale":"es_ES","og_type":"article","og_title":"\u00bfc\u00f3mo crear una tabla multidimensional?","og_description":"Para crear una matriz con m\u00faltiples dimensiones, debe definir las dimensiones al declarar la matriz. Bueno, puedes definir tantas dimensiones como quieras (VBA permite 60 dimensiones), pero probablemente no necesitar\u00e1s usar m\u00e1s de 2 o 3 dimensiones de ninguna de las matrices. Usar una tabla bidimensional es como tener filas y columnas. En este tutorial [&hellip;]","og_url":"https:\/\/exceladvisor.org\/es\/matriz-multidimensional\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-25T10:25:36+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-tableau-multidimensionnel-1.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tiempo de lectura":"1 minuto"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/es\/matriz-multidimensional\/","url":"https:\/\/exceladvisor.org\/es\/matriz-multidimensional\/","name":"\u00bfc\u00f3mo crear una tabla multidimensional?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/es\/matriz-multidimensional\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/matriz-multidimensional\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-tableau-multidimensionnel-1.png","datePublished":"2023-11-17T21:02:46+00:00","dateModified":"2023-12-25T10:25:36+00:00","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/es\/matriz-multidimensional\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/es\/matriz-multidimensional\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/matriz-multidimensional\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-tableau-multidimensionnel-1.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-tableau-multidimensionnel-1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/es\/matriz-multidimensional\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Hogar","item":"https:\/\/exceladvisor.org\/es\/"},{"@type":"ListItem","position":2,"name":"\u00bfc\u00f3mo crear una tabla multidimensional?"}]},{"@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\/55","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=55"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/55\/revisions"}],"predecessor-version":[{"id":1085,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/55\/revisions\/1085"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/media?parent=55"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}