{"id":304,"date":"2023-11-05T12:20:57","date_gmt":"2023-11-05T12:20:57","guid":{"rendered":"https:\/\/exceladvisor.org\/es\/contar-las-hojas\/"},"modified":"2023-12-25T10:24:42","modified_gmt":"2023-12-25T10:24:42","slug":"contar-las-hojas","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/es\/contar-las-hojas\/","title":{"rendered":"\u00bfc\u00f3mo contar hojas usando vba?"},"content":{"rendered":"<div class=\"excel-antes-del-contenido\" id=\"excel-574376313\"><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>En Excel, si tienes muchas hojas, puedes usar el c\u00f3digo VBA para contarlas r\u00e1pidamente en lugar de contarlas manualmente o usar cualquier f\u00f3rmula. Entonces, en el art\u00edculo veremos diferentes formas de contar las hojas de un libro de trabajo.<\/p>\n<h2 class=\"wp-block-heading\"> Contar hojas en el libro activo<\/h2>\n<p> Aqu\u00ed est\u00e1 el c\u00f3digo que necesita usar para contar la hoja del libro activo. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-52417\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-feuilles-de-comptage-forment-le-classeur-actif.png\" sizes=\"auto, \" srcset=\"\" alt=\"contar-hojas-formar-la-encuadernadora-activa\" width=\"675\" height=\"344\"><\/figure>\n<\/div>\n<pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">ThisWorkbook.Sheets.Count<\/code><\/pre>\n<p> En este c\u00f3digo, primero se ha referido al libro activo usando \u00abThisWorkbook\u00bb y se ha referido a todas las hojas, al final se utiliza el m\u00e9todo de conteo para contar todas las hojas. Y si desea contar hojas de trabajo en lugar de hojas, utilice el siguiente c\u00f3digo.<\/p>\n<pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">ThisWorkbook.Worksheets.Count<\/code><\/pre>\n<p class=\"content-box-grey\"> <em>Enlaces \u00fatiles: <a href=\"https:\/\/exceladvisor.org\/es\/ejecutar-una-macro-2\/\">Ejecutar una macro<\/a> \u2013 <a href=\"https:\/\/exceladvisor.org\/es\/grabar-una-macro\/\">Grabador de macros<\/a> \u2013 <a href=\"https:\/\/exceladvisor.org\/es\/editor-visual-basico\/\">Editor de Visual Basic<\/a> \u2013 <a href=\"https:\/\/exceladvisor.org\/es\/cuaderno-macro-personal\/\">Manual de macros personales<\/a><\/em><\/p>\n<h2 class=\"wp-block-heading\"> Contar hojas de otro libro<\/h2>\n<p> Puede usar el nombre del libro para referirse a \u00e9l y luego contar las hojas que contiene. Suponga que desea contar las hojas del libro de trabajo \u00abLibro1\u00bb.<\/p>\n<p> Aqu\u00ed est\u00e1 el c\u00f3digo.<\/p>\n<pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Workbooks(\"sample-file.xlsx\").Sheets.Count<\/code><\/pre>\n<p> Este c\u00f3digo le proporciona la cantidad de hojas que tiene en el libro de trabajo \u00absample-file.xlsx\u00bb. Hay una cosa que debes tomar: esta carpeta debe estar abierta.<\/p>\n<h2 class=\"wp-block-heading\"> Cuente las hojas de todas las carpetas abiertas.<\/h2>\n<p> Puede tener varios libros abiertos al mismo tiempo y puede contar todas las hojas de todos estos libros.<\/p>\n<pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub vba_loop_all_sheets() Dim wb As Workbook Dim i As Long For Each wb In Application.Workbooks If wb.Name &lt;&gt; \"PERSONAL.XLSB\" Then i = i + wb.Sheets.Count End If Next wb MsgBox \"Total sheets in all the open workbooks: \" &amp; i End Sub<\/code><\/pre>\n<h2 class=\"wp-block-heading\"> Contando las hojas de una carpeta cerrada<\/h2>\n<p> Ahora tenemos un c\u00f3digo aqu\u00ed que hace referencia al libro guardado en el escritorio de mi sistema. Cuando ejecuto este c\u00f3digo, abre este libro en la parte posterior y cuenta las hojas que contiene, luego agrega ese recuento a la celda A1.<\/p>\n<pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub vba_count_sheets() Dim wb As Workbook Application.DisplayAlerts = False Set wb = Workbooks.Open(\"C:UsersDellDesktopsample-file.xlsx\") ThisWorkbook.Sheets(1).Range(\"A1\").Value _ = wb.Sheets.Count wb.Close SaveChanges:=True Application.DisplayAlerts = True End Sub<\/code><\/pre>\n<p> Hemos deshabilitado la visualizaci\u00f3n de alertas para abrir y cerrar el archivo en el backend.<\/p>\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\/hoja-clara\/\">BORRAR una hoja completa usando VBA en Excel<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/copiar-hoja\/\">Copiar y mover una hoja en Excel usando VBA<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/eliminar-una-hoja-1\/\">ELIMINAR una HOJA usando VBA en Excel<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/ocultar-hoja\/\">Ocultar y mostrar una hoja usando VBA en Excel<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/proteger-la-hoja\/\">PROTEGER y DESPROTEGER una hoja usando VBA en Excel<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/cambiar-el-nombre-de-la-hoja\/\">RENOMBRAR una hoja 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>En Excel, si tienes muchas hojas, puedes usar el c\u00f3digo VBA para contarlas r\u00e1pidamente en lugar de contarlas manualmente o usar cualquier f\u00f3rmula. Entonces, en el art\u00edculo veremos diferentes formas de contar las hojas de un libro de trabajo. Contar hojas en el libro activo Aqu\u00ed est\u00e1 el c\u00f3digo que necesita usar para contar la [&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-304","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 contar hojas usando 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\/contar-las-hojas\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u00bfc\u00f3mo contar hojas usando vba?\" \/>\n<meta property=\"og:description\" content=\"En Excel, si tienes muchas hojas, puedes usar el c\u00f3digo VBA para contarlas r\u00e1pidamente en lugar de contarlas manualmente o usar cualquier f\u00f3rmula. Entonces, en el art\u00edculo veremos diferentes formas de contar las hojas de un libro de trabajo. Contar hojas en el libro activo Aqu\u00ed est\u00e1 el c\u00f3digo que necesita usar para contar la [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/es\/contar-las-hojas\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-25T10:24:42+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-feuilles-de-comptage-forment-le-classeur-actif.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\/contar-las-hojas\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/contar-las-hojas\/\",\"name\":\"\u00bfc\u00f3mo contar hojas usando vba?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/contar-las-hojas\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/contar-las-hojas\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-feuilles-de-comptage-forment-le-classeur-actif.png\",\"datePublished\":\"2023-11-05T12:20:57+00:00\",\"dateModified\":\"2023-12-25T10:24:42+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/contar-las-hojas\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/es\/contar-las-hojas\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/contar-las-hojas\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-feuilles-de-comptage-forment-le-classeur-actif.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-feuilles-de-comptage-forment-le-classeur-actif.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/es\/contar-las-hojas\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Hogar\",\"item\":\"https:\/\/exceladvisor.org\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u00bfc\u00f3mo contar hojas usando 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 contar hojas usando 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\/contar-las-hojas\/","og_locale":"es_ES","og_type":"article","og_title":"\u00bfc\u00f3mo contar hojas usando vba?","og_description":"En Excel, si tienes muchas hojas, puedes usar el c\u00f3digo VBA para contarlas r\u00e1pidamente en lugar de contarlas manualmente o usar cualquier f\u00f3rmula. Entonces, en el art\u00edculo veremos diferentes formas de contar las hojas de un libro de trabajo. Contar hojas en el libro activo Aqu\u00ed est\u00e1 el c\u00f3digo que necesita usar para contar la [&hellip;]","og_url":"https:\/\/exceladvisor.org\/es\/contar-las-hojas\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-25T10:24:42+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-feuilles-de-comptage-forment-le-classeur-actif.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\/contar-las-hojas\/","url":"https:\/\/exceladvisor.org\/es\/contar-las-hojas\/","name":"\u00bfc\u00f3mo contar hojas usando vba?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/es\/contar-las-hojas\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/contar-las-hojas\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-feuilles-de-comptage-forment-le-classeur-actif.png","datePublished":"2023-11-05T12:20:57+00:00","dateModified":"2023-12-25T10:24:42+00:00","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/es\/contar-las-hojas\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/es\/contar-las-hojas\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/contar-las-hojas\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-feuilles-de-comptage-forment-le-classeur-actif.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-feuilles-de-comptage-forment-le-classeur-actif.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/es\/contar-las-hojas\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Hogar","item":"https:\/\/exceladvisor.org\/es\/"},{"@type":"ListItem","position":2,"name":"\u00bfc\u00f3mo contar hojas usando 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\/304","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=304"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/304\/revisions"}],"predecessor-version":[{"id":947,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/304\/revisions\/947"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/media?parent=304"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}