{"id":1778,"date":"2023-11-05T12:20:57","date_gmt":"2023-11-05T12:20:57","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/menghitung-daunnya\/"},"modified":"2023-12-06T06:17:47","modified_gmt":"2023-12-06T06:17:47","slug":"menghitung-daunnya","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/menghitung-daunnya\/","title":{"rendered":"Bagaimana cara menghitung lembar menggunakan vba?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-2383207166\"><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>Di Excel, jika Anda memiliki banyak lembar, Anda bisa menggunakan kode VBA untuk menghitungnya dengan cepat daripada menghitung secara manual atau menggunakan rumus apa pun. Jadi, dalam artikel ini kita akan melihat berbagai cara menghitung lembar buku kerja.<\/p><h2 class=\"wp-block-heading\"> Hitung lembar di buku kerja aktif<\/h2><p> Berikut adalah kode yang perlu Anda gunakan untuk menghitung lembar buku kerja yang aktif. <\/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=\"lembar-hitung-bentuk-pengikat-aktif\" 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> Dalam kode ini, pertama-tama Anda merujuk ke buku kerja yang aktif menggunakan &#8220;Buku Kerja Ini&#8221; dan merujuk ke semua lembar, terakhir gunakan metode penghitungan untuk menghitung semua lembar. Dan jika Anda ingin menghitung lembar kerja, bukan lembar, gunakan kode berikut.<\/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>Tautan yang berguna: <a href=\"https:\/\/exceladvisor.org\/id\/jalankan-makro-2\/\">Jalankan makro<\/a> \u2013 <a href=\"https:\/\/exceladvisor.org\/id\/merekam-makro\/\">Perekam makro<\/a> \u2013 <a href=\"https:\/\/exceladvisor.org\/id\/editor-visual-dasar\/\">Editor Visual Basic<\/a> \u2013 <a href=\"https:\/\/exceladvisor.org\/id\/buku-catatan-makro-pribadi\/\">Buku Pegangan Makro Pribadi<\/a><\/em><\/p><h2 class=\"wp-block-heading\"> Hitung lembar dari buku kerja lain<\/h2><p> Anda bisa menggunakan nama buku kerja untuk merujuknya dan kemudian menghitung lembar di dalamnya. Misalkan Anda ingin menghitung lembar di buku kerja \u201cBuku1\u201d.<\/p><p> Ini kodenya.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Workbooks(\"sample-file.xlsx\").Sheets.Count<\/code><\/pre><p> Kode ini memberi Anda jumlah lembar yang Anda miliki di buku kerja \u201csample-file.xlsx\u201d. Ada satu hal yang perlu Anda ambil, pengikat ini harus terbuka.<\/p><h2 class=\"wp-block-heading\"> Hitung lembar semua pengikat terbuka<\/h2><p> Anda bisa membuka beberapa buku kerja secara bersamaan dan Anda bisa menghitung semua lembar di semua buku kerja ini.<\/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\"> Menghitung lembaran pengikat tertutup<\/h2><p> Sekarang kami memiliki beberapa kode di sini yang merujuk ke buku kerja yang disimpan di desktop sistem saya. Saat saya menjalankan kode ini, kode ini akan membuka buku kerja ini di bagian belakang dan menghitung lembar di dalamnya, lalu menambahkan jumlah tersebut ke sel 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> Kami telah menonaktifkan peringatan tampilan untuk membuka dan menutup file di backend.<\/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\/id\/vba\/\">Apa itu VBA<\/a><h2 class=\"gb-headline gb-headline-665e5f6b gb-headline-text gb-headline-mt-heading\"> Tutorial terkait <\/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\/id\/lembar-bening\/\">HAPUS seluruh lembar menggunakan VBA di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/lembar-salinan\/\">Salin dan pindahkan lembar di Excel menggunakan VBA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/menghapus-lembar-1\/\">HAPUS LEMBAR menggunakan VBA di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/lembar-sembunyikan\/\">Sembunyikan dan tampilkan lembar menggunakan VBA di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/melindungi-daunnya\/\">PROTECT dan UNPROTECT sheet menggunakan VBA di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/ganti-nama-lembar\/\">GANTI NAMA lembar menggunakan VBA di 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>Bagaimana cara MENGHITUNG lembar menggunakan VBA di Excel?<\/title>\n<meta name=\"description\" content=\"Dalam tutorial ini, Anda akan dapat menemukan berbagai cara menghitung lembar di Excel menggunakan 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\/id\/menghitung-daunnya\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bagaimana cara MENGHITUNG lembar menggunakan VBA di Excel?\" \/>\n<meta property=\"og:description\" content=\"Dalam tutorial ini, Anda akan dapat menemukan berbagai cara menghitung lembar di Excel menggunakan VBA.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/menghitung-daunnya\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:17:47+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=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/id\/menghitung-daunnya\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/menghitung-daunnya\/\",\"name\":\"Bagaimana cara MENGHITUNG lembar menggunakan VBA di Excel?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/menghitung-daunnya\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/menghitung-daunnya\/#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-06T06:17:47+00:00\",\"description\":\"Dalam tutorial ini, Anda akan dapat menemukan berbagai cara menghitung lembar di Excel menggunakan VBA.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/menghitung-daunnya\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/menghitung-daunnya\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/menghitung-daunnya\/#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\/id\/menghitung-daunnya\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara menghitung lembar menggunakan vba?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"name\":\"Excel Advisor\",\"description\":\"Panduan utama Anda untuk mendominasi data!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/id\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"id\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Bagaimana cara MENGHITUNG lembar menggunakan VBA di Excel?","description":"Dalam tutorial ini, Anda akan dapat menemukan berbagai cara menghitung lembar di Excel menggunakan 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\/id\/menghitung-daunnya\/","og_locale":"id_ID","og_type":"article","og_title":"Bagaimana cara MENGHITUNG lembar menggunakan VBA di Excel?","og_description":"Dalam tutorial ini, Anda akan dapat menemukan berbagai cara menghitung lembar di Excel menggunakan VBA.","og_url":"https:\/\/exceladvisor.org\/id\/menghitung-daunnya\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:17:47+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":{"Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/id\/menghitung-daunnya\/","url":"https:\/\/exceladvisor.org\/id\/menghitung-daunnya\/","name":"Bagaimana cara MENGHITUNG lembar menggunakan VBA di Excel?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/menghitung-daunnya\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/menghitung-daunnya\/#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-06T06:17:47+00:00","description":"Dalam tutorial ini, Anda akan dapat menemukan berbagai cara menghitung lembar di Excel menggunakan VBA.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/menghitung-daunnya\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/menghitung-daunnya\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/menghitung-daunnya\/#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\/id\/menghitung-daunnya\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara menghitung lembar menggunakan vba?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/id\/#website","url":"https:\/\/exceladvisor.org\/id\/","name":"Excel Advisor","description":"Panduan utama Anda untuk mendominasi data!","publisher":{"@id":"https:\/\/exceladvisor.org\/id\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/id\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"id"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/id\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/id\/","logo":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1778","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/comments?post=1778"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1778\/revisions"}],"predecessor-version":[{"id":2644,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1778\/revisions\/2644"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1778"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}