{"id":104,"date":"2023-11-16T11:52:53","date_gmt":"2023-11-16T11:52:53","guid":{"rendered":"https:\/\/exceladvisor.org\/es\/numero-de-lineas\/"},"modified":"2023-12-25T10:25:06","modified_gmt":"2023-12-25T10:25:06","slug":"numero-de-lineas","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/es\/numero-de-lineas\/","title":{"rendered":"\u00bfc\u00f3mo crear filas usando vba en excel?"},"content":{"rendered":"<div class=\"excel-antes-del-contenido\" id=\"excel-1531542642\"><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 contar filas usando VBA, debe establecer el rango desde el cual desea contar filas, luego usar la propiedad de recuento y filas para obtener el n\u00famero de filas de ese rango. Tambi\u00e9n puedes usar un bucle para contar filas donde solo tienes datos.<\/p>\n<h2 class=\"wp-block-heading\"> Utilice VBA para contar filas<\/h2>\n<ol type=\"1\">\n<li> Primero, debe definir el rango para el cual desea contar filas.<\/li>\n<li> Despu\u00e9s de eso, use un punto (.) para abrir la lista de propiedades y m\u00e9todos.<\/li>\n<li> A continuaci\u00f3n, escriba o seleccione la propiedad \u00abL\u00edneas\u00bb.<\/li>\n<li> Al final, utilice la propiedad \u00abContar\u00bb. <\/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-58865\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-pour-compter-les-lignes.png\" sizes=\"auto, \" srcset=\"\" alt=\"vba para contar filas\" width=\"422\" height=\"262\"><\/figure>\n<\/div>\n<p> Ahora, cuando ejecute este c\u00f3digo, devolver\u00e1 el n\u00famero de filas y, para obtener el n\u00famero, puede usar un <a href=\"https:\/\/exceladvisor.org\/es\/cuadro-de-mensajes-vba\/\">cuadro de mensaje<\/a> o <a href=\"https:\/\/exceladvisor.org\/es\/valor-de-celda\/\">ingresar directamente este valor en una celda<\/a> tambi\u00e9n.<\/p>\n<pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub vba_count_rows() Range(\"A1:A10\").Rows.Count End Sub<\/code><\/pre>\n<h2 class=\"wp-block-heading\"> Contar filas para el rango utilizado<\/h2>\n<pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub vba_count_rows2()   MsgBox Worksheets(\"Sheet1\").UsedRange.Rows.Count End Sub<\/code><\/pre>\n<h2 class=\"wp-block-heading\"> Contar filas con datos usando VBA<\/h2>\n<p> Tambi\u00e9n puede contar filas que contienen datos ignorando las filas vac\u00edas. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-58866\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-lignes-de-comptage-avec-des-donnees-a-laide-de-vba.png\" sizes=\"auto, \" srcset=\"\" alt=\"contar-filas-con-datos-usando-vba\" width=\"627\" height=\"421\"><\/figure>\n<\/div>\n<p> El siguiente c\u00f3digo tomar\u00e1 el rango utilizado como el rango para recorrer y recorrer\u00e1 cada fila una por una y verificar\u00e1 si hay una celda que no est\u00e9 vac\u00eda all\u00ed, y si est\u00e1 all\u00ed, la considerar\u00e1 como una fila con datos, y en Al final se muestra un cuadro de mensaje con el n\u00famero total de l\u00edneas.<\/p>\n<pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub vba_count_rows_with_data() Dim counter As Long Dim iRange As Range With ActiveSheet.UsedRange    'loop through each row from the used range    For Each iRange In .Rows        'check if the row contains a cell with a value        If Application.CountA(iRange) &gt; 0 Then            'counts the number of rows non-empty Cells            counter = counter + 1        End If    Next End With MsgBox \"Number of used rows is \" &amp; counter 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\"> Tutoriales relacionados <\/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\/fuente-de-caracteres\/\">Fuente Excel VBA (color, tama\u00f1o, tipo y negrita)<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/ocultar-mostrar-fila-de-columna\/\">Excel VBA Ocultar y mostrar una columna o fila<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/rango-1\/\">Rango de Excel VBA: trabajar con rango y celdas<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/fronteras\/\">Aplicar bordes a una celda usando VBA en Excel<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/encontrar-la-celda-de-la-columna-de-la-ultima-fila\/\">Encuentre la \u00faltima fila, columna y celda usando VBA en Excel<\/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 contar filas usando VBA, debe establecer el rango desde el cual desea contar filas, luego usar la propiedad de recuento y filas para obtener el n\u00famero de filas de ese rango. Tambi\u00e9n puedes usar un bucle para contar filas donde solo tienes datos. Utilice VBA para contar filas Primero, debe definir el rango para [&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-104","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 filas usando vba en excel?<\/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\/numero-de-lineas\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u00bfc\u00f3mo crear filas usando vba en excel?\" \/>\n<meta property=\"og:description\" content=\"Para contar filas usando VBA, debe establecer el rango desde el cual desea contar filas, luego usar la propiedad de recuento y filas para obtener el n\u00famero de filas de ese rango. Tambi\u00e9n puedes usar un bucle para contar filas donde solo tienes datos. Utilice VBA para contar filas Primero, debe definir el rango para [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/es\/numero-de-lineas\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-25T10:25:06+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-pour-compter-les-lignes.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\/numero-de-lineas\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/numero-de-lineas\/\",\"name\":\"\u00bfc\u00f3mo crear filas usando vba en excel?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/numero-de-lineas\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/numero-de-lineas\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-pour-compter-les-lignes.png\",\"datePublished\":\"2023-11-16T11:52:53+00:00\",\"dateModified\":\"2023-12-25T10:25:06+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/numero-de-lineas\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/es\/numero-de-lineas\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/numero-de-lineas\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-pour-compter-les-lignes.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-pour-compter-les-lignes.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/es\/numero-de-lineas\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Hogar\",\"item\":\"https:\/\/exceladvisor.org\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u00bfc\u00f3mo crear filas usando vba en excel?\"}]},{\"@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 filas usando vba en excel?","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\/numero-de-lineas\/","og_locale":"es_ES","og_type":"article","og_title":"\u00bfc\u00f3mo crear filas usando vba en excel?","og_description":"Para contar filas usando VBA, debe establecer el rango desde el cual desea contar filas, luego usar la propiedad de recuento y filas para obtener el n\u00famero de filas de ese rango. Tambi\u00e9n puedes usar un bucle para contar filas donde solo tienes datos. Utilice VBA para contar filas Primero, debe definir el rango para [&hellip;]","og_url":"https:\/\/exceladvisor.org\/es\/numero-de-lineas\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-25T10:25:06+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-pour-compter-les-lignes.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\/numero-de-lineas\/","url":"https:\/\/exceladvisor.org\/es\/numero-de-lineas\/","name":"\u00bfc\u00f3mo crear filas usando vba en excel?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/es\/numero-de-lineas\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/numero-de-lineas\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-pour-compter-les-lignes.png","datePublished":"2023-11-16T11:52:53+00:00","dateModified":"2023-12-25T10:25:06+00:00","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/es\/numero-de-lineas\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/es\/numero-de-lineas\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/numero-de-lineas\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-pour-compter-les-lignes.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-pour-compter-les-lignes.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/es\/numero-de-lineas\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Hogar","item":"https:\/\/exceladvisor.org\/es\/"},{"@type":"ListItem","position":2,"name":"\u00bfc\u00f3mo crear filas usando vba en excel?"}]},{"@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\/104","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=104"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/104\/revisions"}],"predecessor-version":[{"id":1005,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/104\/revisions\/1005"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/media?parent=104"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}