{"id":491,"date":"2023-10-26T10:22:15","date_gmt":"2023-10-26T10:22:15","guid":{"rendered":"https:\/\/exceladvisor.org\/es\/filtrar\/"},"modified":"2023-12-25T10:28:26","modified_gmt":"2023-12-25T10:28:26","slug":"filtrar","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/es\/filtrar\/","title":{"rendered":"\u00bfc\u00f3mo utilizar la funci\u00f3n filtro vba?"},"content":{"rendered":"<div class=\"excel-antes-del-contenido\" id=\"excel-4011969\"><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 FILTRO VBA aparece en la categor\u00eda de la tabla de funciones VBA. Cuando lo usa en c\u00f3digo VBA, <strong>puede devolver cadenas de una matriz de cadenas basadas en la cadena que especific\u00f3 como subconjunto<\/strong> . En t\u00e9rminos simples, puede especificar una cadena y buscar\u00e1 todos los valores donde esa cadena sea parte de la cadena principal.<\/p>\n<h2 class=\"wp-block-heading\"> Sintaxis<\/h2>\n<p> <strong>Filtro(ArraySource,Coincidencia,[Incluir],[Comparar])<\/strong><\/p>\n<h2 class=\"wp-block-heading\"> Argumento<\/h2>\n<ul>\n<li> <strong>SourceArray<\/strong> : la matriz con las cadenas a filtrar.<\/li>\n<li> <strong>Coincidencia<\/strong> : la cadena que desea filtrar en SourceArray.<\/li>\n<li> <strong>[Incluir]<\/strong> : Este es un valor booleano para definir si el valor meteorol\u00f3gico a filtrar incluye la coincidencia o no incluye [Este es un argumento opcional y, si se omite, VBA por defecto es VERDADERO].<\/li>\n<li> <strong>[Comparar]<\/strong> : un valor de cadena para definir la comparaci\u00f3n que se realizar\u00e1 al filtrar la matriz [Este es un argumento opcional y, si se omite, VBA toma vbBinaryCompare de forma predeterminada].\n<ul>\n<li> vbBinaryCompare: para comparaci\u00f3n binaria.<\/li>\n<li> vbTextCompare: para comparaci\u00f3n de texto.<\/li>\n<li> vbDatabaseCompare: para comparar bases de datos.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<h2 class=\"wp-block-heading\"> Ejemplo<\/h2>\n<p> Para comprender pr\u00e1cticamente c\u00f3mo usar la funci\u00f3n FILTRO VBA, debe seguir el siguiente ejemplo donde hemos escrito 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-filtro-funci\u00f3n-vba\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-de-filtre-vba.png\" sizes=\"auto, \" srcset=\"\" alt=\"example-vba-filter-function\" width=\"849\" height=\"588\"><\/figure>\n<\/div>\n<pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub example_FILTER() Dim nameAry As Variant Dim myAry(0 To 4) As String myAry(0) = Range(\"A1\").Value myAry(1) = Range(\"A2\").Value myAry(2) = Range(\"A3\").Value myAry(3) = Range(\"A4\").Value myAry(4) = Range(\"A5\").Value nameAry = Filter(myAry, \"Sh\") End Sub<\/code><\/pre>\n<p> En el c\u00f3digo anterior, usamos FILTER para obtener el valor de la matriz (myAry tiene valores de las celdas que definimos) que incluye &#8216;Sh&#8217; y ahora, &#8216;nameAry&#8217; incluye &#8216;Jay Sh&#8217; y &#8216;Peter&#8217;. Sh&#8217; porque ambos contienen \u201cSh\u201d.<\/p>\n<h2 class=\"wp-block-heading\"> Comentarios<\/h2>\n<ul>\n<li> Si la matriz fuente que proporcion\u00f3 es NULL, VBA devolver\u00e1 un error.<\/li>\n<li> La matriz devuelta por el filtro siempre ser\u00e1 una matriz unidimensional de base cero.<\/li>\n<\/ul>\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\/unirse\/\">\u00daNETE A VBA<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/encuadernado\/\">VBA LIBADO<\/a><\/li>\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 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 FILTRO VBA aparece en la categor\u00eda de la tabla de funciones VBA. Cuando lo usa en c\u00f3digo VBA, puede devolver cadenas de una matriz de cadenas basadas en la cadena que especific\u00f3 como subconjunto . En t\u00e9rminos simples, puede especificar una cadena y buscar\u00e1 todos los valores donde esa cadena sea parte de [&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-491","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 filtro 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\/filtrar\/\" \/>\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 filtro vba?\" \/>\n<meta property=\"og:description\" content=\"La funci\u00f3n FILTRO VBA aparece en la categor\u00eda de la tabla de funciones VBA. Cuando lo usa en c\u00f3digo VBA, puede devolver cadenas de una matriz de cadenas basadas en la cadena que especific\u00f3 como subconjunto . En t\u00e9rminos simples, puede especificar una cadena y buscar\u00e1 todos los valores donde esa cadena sea parte de [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/es\/filtrar\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-25T10:28:26+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-de-filtre-vba.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\/filtrar\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/filtrar\/\",\"name\":\"\u00bfc\u00f3mo utilizar la funci\u00f3n filtro vba?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/filtrar\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/filtrar\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-de-filtre-vba.png\",\"datePublished\":\"2023-10-26T10:22:15+00:00\",\"dateModified\":\"2023-12-25T10:28:26+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/filtrar\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/es\/filtrar\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/filtrar\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-de-filtre-vba.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-de-filtre-vba.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/es\/filtrar\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Hogar\",\"item\":\"https:\/\/exceladvisor.org\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u00bfc\u00f3mo utilizar la funci\u00f3n filtro 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 utilizar la funci\u00f3n filtro 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\/filtrar\/","og_locale":"es_ES","og_type":"article","og_title":"\u00bfc\u00f3mo utilizar la funci\u00f3n filtro vba?","og_description":"La funci\u00f3n FILTRO VBA aparece en la categor\u00eda de la tabla de funciones VBA. Cuando lo usa en c\u00f3digo VBA, puede devolver cadenas de una matriz de cadenas basadas en la cadena que especific\u00f3 como subconjunto . En t\u00e9rminos simples, puede especificar una cadena y buscar\u00e1 todos los valores donde esa cadena sea parte de [&hellip;]","og_url":"https:\/\/exceladvisor.org\/es\/filtrar\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-25T10:28:26+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-de-filtre-vba.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\/filtrar\/","url":"https:\/\/exceladvisor.org\/es\/filtrar\/","name":"\u00bfc\u00f3mo utilizar la funci\u00f3n filtro vba?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/es\/filtrar\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/filtrar\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-de-filtre-vba.png","datePublished":"2023-10-26T10:22:15+00:00","dateModified":"2023-12-25T10:28:26+00:00","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/es\/filtrar\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/es\/filtrar\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/filtrar\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-de-filtre-vba.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-de-filtre-vba.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/es\/filtrar\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Hogar","item":"https:\/\/exceladvisor.org\/es\/"},{"@type":"ListItem","position":2,"name":"\u00bfc\u00f3mo utilizar la funci\u00f3n filtro 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\/491","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=491"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/491\/revisions"}],"predecessor-version":[{"id":1308,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/491\/revisions\/1308"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/media?parent=491"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}