{"id":516,"date":"2023-10-25T05:20:14","date_gmt":"2023-10-25T05:20:14","guid":{"rendered":"https:\/\/exceladvisor.org\/es\/encuadernado\/"},"modified":"2023-12-25T10:30:46","modified_gmt":"2023-12-25T10:30:46","slug":"encuadernado","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/es\/encuadernado\/","title":{"rendered":"\u00bfc\u00f3mo utilizar la funci\u00f3n vba lbound?"},"content":{"rendered":"<div class=\"excel-antes-del-contenido\" id=\"excel-14792615\"><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 LBOUND aparece en la categor\u00eda de tabla de funciones VBA. Cuando lo usa en c\u00f3digo VBA, <strong>puede devolver el \u00edndice m\u00e1s bajo para una dimensi\u00f3n en la matriz proporcionada<\/strong> . En t\u00e9rminos simples, le ayuda a encontrar el l\u00edmite inferior de una matriz y devolver el valor m\u00e1s bajo en el resultado.<\/p>\n<h2 class=\"wp-block-heading\"> Sintaxis<\/h2>\n<p> <strong>LBound(Nombrematriz, [Dimensi\u00f3n])<\/strong><\/p>\n<h2 class=\"wp-block-heading\"> Argumentos<\/h2>\n<ul>\n<li> <strong>ArrayName<\/strong> : una matriz para la que desea encontrar el \u00edndice m\u00e1s bajo.<\/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 LBOUND, debe seguir el siguiente ejemplo donde escribimos un c\u00f3digo vba us\u00e1ndola: <\/p>\n<figure class=\"wp-block-image is-resized\"><img loading=\"lazy\" decoding=\"async\" title=\"ejemplo-vba-lbound-funci\u00f3n\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-lbound.png\" sizes=\"auto, \" srcset=\"\" alt=\"example-vba-lbound-function\" width=\"830\" height=\"511\"><\/figure>\n<pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub example_LBOUND() Dim myAry(0 To 1100) As Double Range(\"A1\").Value = LBound(myAry, 1) End Sub<\/code><\/pre>\n<p> En el c\u00f3digo anterior, usamos LBOUND para obtener el \u00edndice m\u00e1s bajo para una dimensi\u00f3n de la matriz myAry y devolvi\u00f3 0 en el resultado.<\/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<\/ul>\n<\/div>\n<\/div>\n<div class=\"gb-grid-column gb-grid-column-3151f7cb\">\n<div class=\"gb-container gb-container-3151f7cb\">\n<ul>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/dividir\/\">DIVIDIR VBA<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/ubound\/\">VBA UNIDO<\/a><\/li>\n<\/ul>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>La funci\u00f3n VBA LBOUND aparece en la categor\u00eda de tabla de funciones VBA. Cuando lo usa en c\u00f3digo VBA, puede devolver el \u00edndice m\u00e1s bajo para una dimensi\u00f3n en la matriz proporcionada . En t\u00e9rminos simples, le ayuda a encontrar el l\u00edmite inferior de una matriz y devolver el valor m\u00e1s bajo 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-516","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 lbound?<\/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\/encuadernado\/\" \/>\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 lbound?\" \/>\n<meta property=\"og:description\" content=\"La funci\u00f3n VBA LBOUND aparece en la categor\u00eda de tabla de funciones VBA. Cuando lo usa en c\u00f3digo VBA, puede devolver el \u00edndice m\u00e1s bajo para una dimensi\u00f3n en la matriz proporcionada . En t\u00e9rminos simples, le ayuda a encontrar el l\u00edmite inferior de una matriz y devolver el valor m\u00e1s bajo en el resultado. [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/es\/encuadernado\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-25T10:30:46+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-lbound.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\/encuadernado\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/encuadernado\/\",\"name\":\"\u00bfc\u00f3mo utilizar la funci\u00f3n vba lbound?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/encuadernado\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/encuadernado\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-lbound.png\",\"datePublished\":\"2023-10-25T05:20:14+00:00\",\"dateModified\":\"2023-12-25T10:30:46+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/encuadernado\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/es\/encuadernado\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/encuadernado\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-lbound.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-lbound.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/es\/encuadernado\/#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 lbound?\"}]},{\"@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 lbound?","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\/encuadernado\/","og_locale":"es_ES","og_type":"article","og_title":"\u00bfc\u00f3mo utilizar la funci\u00f3n vba lbound?","og_description":"La funci\u00f3n VBA LBOUND aparece en la categor\u00eda de tabla de funciones VBA. Cuando lo usa en c\u00f3digo VBA, puede devolver el \u00edndice m\u00e1s bajo para una dimensi\u00f3n en la matriz proporcionada . En t\u00e9rminos simples, le ayuda a encontrar el l\u00edmite inferior de una matriz y devolver el valor m\u00e1s bajo en el resultado. [&hellip;]","og_url":"https:\/\/exceladvisor.org\/es\/encuadernado\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-25T10:30:46+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-lbound.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\/encuadernado\/","url":"https:\/\/exceladvisor.org\/es\/encuadernado\/","name":"\u00bfc\u00f3mo utilizar la funci\u00f3n vba lbound?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/es\/encuadernado\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/encuadernado\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-lbound.png","datePublished":"2023-10-25T05:20:14+00:00","dateModified":"2023-12-25T10:30:46+00:00","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/es\/encuadernado\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/es\/encuadernado\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/encuadernado\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-lbound.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-lbound.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/es\/encuadernado\/#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 lbound?"}]},{"@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\/516","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=516"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/516\/revisions"}],"predecessor-version":[{"id":1305,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/516\/revisions\/1305"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/media?parent=516"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}