{"id":1778,"date":"2023-11-05T12:20:57","date_gmt":"2023-11-05T12:20:57","guid":{"rendered":"https:\/\/exceladvisor.org\/nl\/tel-de-bladeren\/"},"modified":"2023-12-06T05:56:25","modified_gmt":"2023-12-06T05:56:25","slug":"tel-de-bladeren","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/nl\/tel-de-bladeren\/","title":{"rendered":"Hoe bladen tellen met vba?"},"content":{"rendered":"<div class=\"excel-voor-de-inhoud\" id=\"excel-1227851777\"><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>Als u in Excel veel werkbladen heeft, kunt u VBA-code gebruiken om ze snel te tellen, in plaats van handmatig te tellen of een formule te gebruiken. In het artikel zullen we dus verschillende manieren zien om de bladen van een werkmap te tellen.<\/p><h2 class=\"wp-block-heading\"> Tel bladen in actieve werkmap<\/h2><p> Hier is de code die u moet gebruiken om het actieve werkmapblad te tellen. <\/p><div class=\"wp-block-image\"><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=\"tellen-vellen-vorm-het-actieve-bindmiddel\" width=\"675\" height=\"344\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">ThisWorkbook.Sheets.Count<\/code><\/pre><p> In deze code heeft u eerst naar de actieve werkmap verwezen met behulp van &#8220;ThisWorkbook&#8221; en naar alle bladen verwezen. Gebruik aan het einde de telmethode om alle bladen te tellen. En als u werkbladen wilt tellen in plaats van bladen, gebruikt u de volgende code.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">ThisWorkbook.Worksheets.Count<\/code><\/pre><p class=\"content-box-grey\"> <em>Handige links: <a href=\"https:\/\/exceladvisor.org\/nl\/voer-een-macro-uit-2\/\">Een macro uitvoeren<\/a> \u2013 <a href=\"https:\/\/exceladvisor.org\/nl\/een-macro-opnemen\/\">Macrorecorder<\/a> \u2013 <a href=\"https:\/\/exceladvisor.org\/nl\/eenvoudige-visuele-editor\/\">Visual Basic Editor<\/a> \u2013 <a href=\"https:\/\/exceladvisor.org\/nl\/persoonlijk-macronotitieboekje\/\">Handboek voor persoonlijke macro&#8217;s<\/a><\/em><\/p><h2 class=\"wp-block-heading\"> Tel bladen uit een andere werkmap<\/h2><p> U kunt de naam van de werkmap gebruiken om ernaar te verwijzen en vervolgens de bladen erin tellen. Stel dat u de bladen in de werkmap &#8220;Boek1&#8221; wilt tellen.<\/p><p> Hier is de code.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Workbooks(\"sample-file.xlsx\").Sheets.Count<\/code><\/pre><p> Deze code geeft u het aantal bladen dat u in de werkmap &#8220;sample-file.xlsx&#8221; heeft. Er is \u00e9\u00e9n ding dat u moet meenemen: deze map moet open zijn.<\/p><h2 class=\"wp-block-heading\"> Tel de vellen van alle geopende ordners<\/h2><p> U kunt meerdere werkmappen tegelijkertijd open hebben en u kunt alle bladen in al deze werkmappen tellen.<\/p><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><h2 class=\"wp-block-heading\"> Het tellen van de vellen van een gesloten map<\/h2><p> Nu hebben we hier een code die verwijst naar de werkmap die op mijn systeembureaublad is opgeslagen. Wanneer ik deze code uitvoer, wordt deze werkmap achterin geopend en worden de bladen erin geteld, waarna dat aantal wordt opgeteld bij cel A1.<\/p><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><p> We hebben weergavewaarschuwingen voor het openen en sluiten van het bestand in de backend uitgeschakeld.<\/p><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\/nl\/vba\/\">Wat is VBA<\/a><h2 class=\"gb-headline gb-headline-665e5f6b gb-headline-text gb-headline-mt-heading\"> Gerelateerde tutorials <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a20baf7c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-65ddf67e\"><div class=\"gb-container gb-container-65ddf67e\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/nl\/duidelijk-blad\/\">WIS een heel blad met VBA in Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/kopieer-blad\/\">Kopieer en verplaats een blad in Excel met VBA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/een-blad-verwijderen-1\/\">VERWIJDER een BLAD met VBA in Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/blad-verbergen\/\">Verberg en toon een blad met VBA in Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/bescherm-het-blad\/\">BESCHERM EN BEVEILIG een blad met VBA in Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/blad-hernoemen\/\">HERnoem een blad met VBA in Excel<\/a> <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-50067b57\"><div class=\"gb-container gb-container-50067b57\"><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"","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-1778","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>Hoe bladen tellen met VBA in Excel?<\/title>\n<meta name=\"description\" content=\"In deze zelfstudie leert u verschillende manieren vinden om bladen in Excel te tellen met behulp van VBA.\" \/>\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\/nl\/tel-de-bladeren\/\" \/>\n<meta property=\"og:locale\" content=\"nl_NL\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Hoe bladen tellen met VBA in Excel?\" \/>\n<meta property=\"og:description\" content=\"In deze zelfstudie leert u verschillende manieren vinden om bladen in Excel te tellen met behulp van VBA.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/nl\/tel-de-bladeren\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T05:56:25+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=\"Geschatte leestijd\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minuten\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/tel-de-bladeren\/\",\"url\":\"https:\/\/exceladvisor.org\/nl\/tel-de-bladeren\/\",\"name\":\"Hoe bladen tellen met VBA in Excel?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/tel-de-bladeren\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/tel-de-bladeren\/#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-06T05:56:25+00:00\",\"description\":\"In deze zelfstudie leert u verschillende manieren vinden om bladen in Excel te tellen met behulp van VBA.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/tel-de-bladeren\/#breadcrumb\"},\"inLanguage\":\"nl-NL\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/nl\/tel-de-bladeren\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/tel-de-bladeren\/#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\/nl\/tel-de-bladeren\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Thuis\",\"item\":\"https:\/\/exceladvisor.org\/nl\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Hoe bladen tellen met vba?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/#website\",\"url\":\"https:\/\/exceladvisor.org\/nl\/\",\"name\":\"Excel Advisor\",\"description\":\"Uw gids voor datadominantie\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/nl\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"nl-NL\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/nl\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/nl\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/nl\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Hoe bladen tellen met VBA in Excel?","description":"In deze zelfstudie leert u verschillende manieren vinden om bladen in Excel te tellen met behulp van 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\/nl\/tel-de-bladeren\/","og_locale":"nl_NL","og_type":"article","og_title":"Hoe bladen tellen met VBA in Excel?","og_description":"In deze zelfstudie leert u verschillende manieren vinden om bladen in Excel te tellen met behulp van VBA.","og_url":"https:\/\/exceladvisor.org\/nl\/tel-de-bladeren\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T05:56:25+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":{"Geschatte leestijd":"2 minuten"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/nl\/tel-de-bladeren\/","url":"https:\/\/exceladvisor.org\/nl\/tel-de-bladeren\/","name":"Hoe bladen tellen met VBA in Excel?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/nl\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/nl\/tel-de-bladeren\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/nl\/tel-de-bladeren\/#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-06T05:56:25+00:00","description":"In deze zelfstudie leert u verschillende manieren vinden om bladen in Excel te tellen met behulp van VBA.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/nl\/tel-de-bladeren\/#breadcrumb"},"inLanguage":"nl-NL","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/nl\/tel-de-bladeren\/"]}]},{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/exceladvisor.org\/nl\/tel-de-bladeren\/#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\/nl\/tel-de-bladeren\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Thuis","item":"https:\/\/exceladvisor.org\/nl\/"},{"@type":"ListItem","position":2,"name":"Hoe bladen tellen met vba?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/nl\/#website","url":"https:\/\/exceladvisor.org\/nl\/","name":"Excel Advisor","description":"Uw gids voor datadominantie","publisher":{"@id":"https:\/\/exceladvisor.org\/nl\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/nl\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"nl-NL"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/nl\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/nl\/","logo":{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/exceladvisor.org\/nl\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/nl\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/nl\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/nl\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/1778","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/comments?post=1778"}],"version-history":[{"count":2,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/1778\/revisions"}],"predecessor-version":[{"id":3052,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/1778\/revisions\/3052"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/media?parent=1778"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}