{"id":576,"date":"2023-10-22T20:08:02","date_gmt":"2023-10-22T20:08:02","guid":{"rendered":"https:\/\/exceladvisor.org\/es\/mesa-de-clasificacion\/"},"modified":"2023-12-25T10:26:38","modified_gmt":"2023-12-25T10:26:38","slug":"mesa-de-clasificacion","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/es\/mesa-de-clasificacion\/","title":{"rendered":"\u00bfc\u00f3mo ordenar una matriz en vba?"},"content":{"rendered":"<div class=\"excel-antes-del-contenido\" id=\"excel-617322309\"><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 ordenar una matriz en VBA, necesita escribir un c\u00f3digo en el que pueda hacer coincidir el primer elemento de la matriz con el siguiente e intercambiarlos si el primero debe aparecer antes. Necesita un <a href=\"https:\/\/exceladvisor.org\/es\/para-el-bucle\/\">bucle FOR (For Next)<\/a> para esto y la <a href=\"https:\/\/exceladvisor.org\/es\/ucase\/\">funci\u00f3n UCASE<\/a> .<\/p>\n<p> En este tutorial veremos las dos formas (AZ y ZA) de ordenar los elementos de una matriz.<\/p>\n<h2 class=\"wp-block-heading\"> Ordenar una matriz (AZ)<\/h2>\n<p> En el c\u00f3digo siguiente, tiene una matriz con cinco elementos, y estos elementos tienen valores que van de E a A, y ahora debemos ordenarlos en orden AZ. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-57136\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-trier-un-tableau-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"ordenar-una-matriz-1\" width=\"415\" height=\"411\"><\/figure>\n<\/div>\n<p> <strong>Pasos para ordenar una matriz<\/strong><\/p>\n<ol type=\"1\">\n<li> Primero, necesitas escribir un bucle anidado con For Next usando los l\u00edmites superior e inferior de la matriz.<\/li>\n<li> Despu\u00e9s de eso, en este bucle, debe usar <a href=\"https:\/\/exceladvisor.org\/es\/si-2\/\">la declaraci\u00f3n IF de VBA<\/a> para comparar los dos elementos.<\/li>\n<li> A partir de ah\u00ed, si el primer elemento debe aparecer antes que el siguiente, deber\u00e1 intercambiarlos guardando sus valores en variables.<\/li>\n<li> Al final, utilice la palabra clave \u00abSiguiente\u00bb para completar el ciclo. <\/li>\n<\/ol>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-57137\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-boucles-imbriquees-avec-pour-les-2-suivantes.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"626\" height=\"324\"><\/figure>\n<\/div>\n<pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Option Base 1 Sub vba_sort_array_a_to_z() Dim myArray() As Variant ReDim myArray(5) Dim i As Integer Dim j As Integer Dim Temp As String myArray(1) = \"E\" myArray(2) = \"D\" myArray(3) = \"C\" myArray(4) = \"B\" myArray(5) = \"A\" 'sorting array from A to Z For i = LBound(myArray) To UBound(myArray) For j = i + 1 To UBound(myArray) If UCase(myArray(i)) &gt; UCase(myArray(j)) Then Temp = myArray(j) myArray(j) = myArray(i) myArray(i) = Temp End If Next j Next i Debug.Print myArray(1) Debug.Print myArray(2) Debug.Print myArray(3) Debug.Print myArray(4) Debug.Print myArray(5) End Sub<\/code><\/pre>\n<p> Aseg\u00farese de activar la <a href=\"https:\/\/exceladvisor.org\/es\/impresion-de-depuracion-inmediata-de-ventana\/\">ventana Inmediato<\/a> para ver los resultados all\u00ed.<\/p>\n<h2 class=\"wp-block-heading\"> Ordenar una matriz (ZA)<\/h2>\n<p> De la misma forma, puedes ordenar por ZA. En el m\u00e9todo anterior, comparamos el primer elemento con el siguiente elemento de la secuencia, pero en este c\u00f3digo debes hacer lo contrario. Entonces, si el segundo elemento (el siguiente en orden) es mayor que el primero, el c\u00f3digo los intercambiar\u00e1.<\/p>\n<pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Option Base 1 Sub vba_sort_array_z_to_a() Dim myArray() As Variant ReDim myArray(5) Dim i As Integer Dim j As Integer Dim Temp As String myArray(1) = \"A\" myArray(2) = \"B\" myArray(3) = \"C\" myArray(4) = \"D\" myArray(5) = \"E\" 'sorting array from A to Z For i = LBound(myArray) To UBound(myArray) For j = i + 1 To UBound(myArray) If UCase(myArray(i)) &lt; UCase(myArray(j)) Then Temp = myArray(j) myArray(j) = myArray(i) myArray(i) = Temp End If Next j Next i Debug.Print myArray(1) Debug.Print myArray(2) Debug.Print myArray(3) Debug.Print myArray(4) Debug.Print myArray(5) 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\"> 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\/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>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Para ordenar una matriz en VBA, necesita escribir un c\u00f3digo en el que pueda hacer coincidir el primer elemento de la matriz con el siguiente e intercambiarlos si el primero debe aparecer antes. Necesita un bucle FOR (For Next) para esto y la funci\u00f3n UCASE . En este tutorial veremos las dos formas (AZ y [&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-576","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 ordenar una matriz en vba?<\/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\/mesa-de-clasificacion\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u00bfc\u00f3mo ordenar una matriz en vba?\" \/>\n<meta property=\"og:description\" content=\"Para ordenar una matriz en VBA, necesita escribir un c\u00f3digo en el que pueda hacer coincidir el primer elemento de la matriz con el siguiente e intercambiarlos si el primero debe aparecer antes. Necesita un bucle FOR (For Next) para esto y la funci\u00f3n UCASE . En este tutorial veremos las dos formas (AZ y [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/es\/mesa-de-clasificacion\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-25T10:26:38+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-trier-un-tableau-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=\"2 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/es\/mesa-de-clasificacion\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/mesa-de-clasificacion\/\",\"name\":\"\u00bfc\u00f3mo ordenar una matriz en vba?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/mesa-de-clasificacion\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/mesa-de-clasificacion\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-trier-un-tableau-1.png\",\"datePublished\":\"2023-10-22T20:08:02+00:00\",\"dateModified\":\"2023-12-25T10:26:38+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/mesa-de-clasificacion\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/es\/mesa-de-clasificacion\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/mesa-de-clasificacion\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-trier-un-tableau-1.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-trier-un-tableau-1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/es\/mesa-de-clasificacion\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Hogar\",\"item\":\"https:\/\/exceladvisor.org\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u00bfc\u00f3mo ordenar una matriz en vba?\"}]},{\"@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 ordenar una matriz en vba?","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\/mesa-de-clasificacion\/","og_locale":"es_ES","og_type":"article","og_title":"\u00bfc\u00f3mo ordenar una matriz en vba?","og_description":"Para ordenar una matriz en VBA, necesita escribir un c\u00f3digo en el que pueda hacer coincidir el primer elemento de la matriz con el siguiente e intercambiarlos si el primero debe aparecer antes. Necesita un bucle FOR (For Next) para esto y la funci\u00f3n UCASE . En este tutorial veremos las dos formas (AZ y [&hellip;]","og_url":"https:\/\/exceladvisor.org\/es\/mesa-de-clasificacion\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-25T10:26:38+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-trier-un-tableau-1.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tiempo de lectura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/es\/mesa-de-clasificacion\/","url":"https:\/\/exceladvisor.org\/es\/mesa-de-clasificacion\/","name":"\u00bfc\u00f3mo ordenar una matriz en vba?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/es\/mesa-de-clasificacion\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/mesa-de-clasificacion\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-trier-un-tableau-1.png","datePublished":"2023-10-22T20:08:02+00:00","dateModified":"2023-12-25T10:26:38+00:00","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/es\/mesa-de-clasificacion\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/es\/mesa-de-clasificacion\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/mesa-de-clasificacion\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-trier-un-tableau-1.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-trier-un-tableau-1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/es\/mesa-de-clasificacion\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Hogar","item":"https:\/\/exceladvisor.org\/es\/"},{"@type":"ListItem","position":2,"name":"\u00bfc\u00f3mo ordenar una matriz en vba?"}]},{"@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\/576","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=576"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/576\/revisions"}],"predecessor-version":[{"id":1152,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/576\/revisions\/1152"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/media?parent=576"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}