{"id":558,"date":"2023-10-23T20:34:49","date_gmt":"2023-10-23T20:34:49","guid":{"rendered":"https:\/\/exceladvisor.org\/es\/ubound\/"},"modified":"2023-12-25T10:31:21","modified_gmt":"2023-12-25T10:31:21","slug":"ubound","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/es\/ubound\/","title":{"rendered":"\u00bfc\u00f3mo utilizar la funci\u00f3n vba ubound?"},"content":{"rendered":"<div class=\"excel-antes-del-contenido\" id=\"excel-3822665748\"><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>La funci\u00f3n VBA UBOUND aparece en la categor\u00eda de tabla de funciones VBA. Cuando lo usa en c\u00f3digo VBA, <strong><span style=\"color: #000000;\">puede devolver el \u00edndice m\u00e1s alto para una dimensi\u00f3n en la matriz proporcionada<\/span><\/strong> . En t\u00e9rminos simples, le ayuda a encontrar el l\u00edmite superior de una matriz y devolver el valor m\u00e1s alto en el resultado.<\/p>\n<h2 class=\"wp-block-heading\"> Sintaxis<\/h2>\n<p> <strong>UBound(Nombrematriz, [Dimensi\u00f3n])<\/strong><\/p>\n<h2 class=\"wp-block-heading\"> Argumentos<\/h2>\n<ul>\n<li> <strong>ArrayName<\/strong> : la matriz para la que desea encontrar el \u00edndice m\u00e1s alto.<\/li>\n<li> <strong>[Dimensi\u00f3n]<\/strong> : un n\u00famero entero para definir la dimensi\u00f3n de la matriz (este es un argumento opcional y, si se omite, VBA toma 1 de forma predeterminada).<\/li>\n<\/ul>\n<h2 class=\"wp-block-heading\"> Ejemplo<\/h2>\n<p> Para comprender pr\u00e1cticamente c\u00f3mo usar la funci\u00f3n VBA UBOUND, debe seguir el siguiente ejemplo donde escribimos un c\u00f3digo vba us\u00e1ndola: <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter is-resized\"><img loading=\"lazy\" decoding=\"async\" title=\"ejemplo-vba-ubound-funci\u00f3n\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-ubound.png\" sizes=\"auto, \" srcset=\"\" alt=\"example-vba-ubound-function\" width=\"834\" height=\"487\"><\/figure>\n<\/div>\n<pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub example_UBOUND() Dim myAry(0 To 1100) As Double Range(\"A1\").Value = UBound(myAry, 1) End Sub<\/code><\/pre>\n<p> En el c\u00f3digo anterior utilizamos UBOUND para obtener el \u00edndice m\u00e1s alto para una dimensi\u00f3n de la matriz \u00abmyAry\u00bb y devolvi\u00f3 1100 en el resultado, que es el valor m\u00e1s alto de 0 a 1100.<\/p>\n<div class=\"gb-container gb-container-078e99df gb-container-mt\"> <a class=\"gb-button gb-button-b61bc159 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-eb94b2aa gb-headline-text gb-headline-mt-heading\"> <a href=\"https:\/\/exceladvisor.org\/es\/funciones\/\">Funciones de VBA<\/a> relacionadas <\/h2>\n<div class=\"gb-grid-wrapper gb-grid-wrapper-bea82d60 gb-grid-wrapper-mt-grid\">\n<div class=\"gb-grid-column gb-grid-column-98a91fbb\">\n<div class=\"gb-container gb-container-98a91fbb\">\n<ul>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/desplegar\/\">TABLA VBA<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/filtrar\/\">FILTRO VBA<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/unirse\/\">\u00daNETE A VBA<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/encuadernado\/\">VBA LIBADO<\/a> <\/li>\n<\/ul>\n<\/div>\n<\/div>\n<div class=\"gb-grid-column gb-grid-column-3151f7cb\">\n<div class=\"gb-container gb-container-3151f7cb\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>La funci\u00f3n VBA UBOUND aparece en la categor\u00eda de tabla de funciones VBA. Cuando lo usa en c\u00f3digo VBA, puede devolver el \u00edndice m\u00e1s alto para una dimensi\u00f3n en la matriz proporcionada . En t\u00e9rminos simples, le ayuda a encontrar el l\u00edmite superior de una matriz y devolver el valor m\u00e1s alto en el resultado. [&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-558","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 utilizar la funci\u00f3n vba ubound?<\/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\/ubound\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u00bfc\u00f3mo utilizar la funci\u00f3n vba ubound?\" \/>\n<meta property=\"og:description\" content=\"La funci\u00f3n VBA UBOUND aparece en la categor\u00eda de tabla de funciones VBA. Cuando lo usa en c\u00f3digo VBA, puede devolver el \u00edndice m\u00e1s alto para una dimensi\u00f3n en la matriz proporcionada . En t\u00e9rminos simples, le ayuda a encontrar el l\u00edmite superior de una matriz y devolver el valor m\u00e1s alto en el resultado. [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/es\/ubound\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-25T10:31:21+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-ubound.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\/ubound\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/ubound\/\",\"name\":\"\u00bfc\u00f3mo utilizar la funci\u00f3n vba ubound?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/ubound\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/ubound\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-ubound.png\",\"datePublished\":\"2023-10-23T20:34:49+00:00\",\"dateModified\":\"2023-12-25T10:31:21+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/ubound\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/es\/ubound\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/ubound\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-ubound.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-ubound.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/es\/ubound\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Hogar\",\"item\":\"https:\/\/exceladvisor.org\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u00bfc\u00f3mo utilizar la funci\u00f3n vba ubound?\"}]},{\"@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 utilizar la funci\u00f3n vba ubound?","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\/ubound\/","og_locale":"es_ES","og_type":"article","og_title":"\u00bfc\u00f3mo utilizar la funci\u00f3n vba ubound?","og_description":"La funci\u00f3n VBA UBOUND aparece en la categor\u00eda de tabla de funciones VBA. Cuando lo usa en c\u00f3digo VBA, puede devolver el \u00edndice m\u00e1s alto para una dimensi\u00f3n en la matriz proporcionada . En t\u00e9rminos simples, le ayuda a encontrar el l\u00edmite superior de una matriz y devolver el valor m\u00e1s alto en el resultado. [&hellip;]","og_url":"https:\/\/exceladvisor.org\/es\/ubound\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-25T10:31:21+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-ubound.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\/ubound\/","url":"https:\/\/exceladvisor.org\/es\/ubound\/","name":"\u00bfc\u00f3mo utilizar la funci\u00f3n vba ubound?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/es\/ubound\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/ubound\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-ubound.png","datePublished":"2023-10-23T20:34:49+00:00","dateModified":"2023-12-25T10:31:21+00:00","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/es\/ubound\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/es\/ubound\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/ubound\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-ubound.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-ubound.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/es\/ubound\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Hogar","item":"https:\/\/exceladvisor.org\/es\/"},{"@type":"ListItem","position":2,"name":"\u00bfc\u00f3mo utilizar la funci\u00f3n vba ubound?"}]},{"@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\/558","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=558"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/558\/revisions"}],"predecessor-version":[{"id":1355,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/558\/revisions\/1355"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/media?parent=558"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}