{"id":4340,"date":"2023-07-11T21:10:47","date_gmt":"2023-07-11T21:10:47","guid":{"rendered":"https:\/\/statorials.org\/id\/vba-menghitung-jumlah-lembar\/"},"modified":"2023-07-11T21:10:47","modified_gmt":"2023-07-11T21:10:47","slug":"vba-menghitung-jumlah-lembar","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/vba-menghitung-jumlah-lembar\/","title":{"rendered":"Vba: cara menghitung jumlah lembar dalam buku kerja"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda bisa menggunakan metode berikut ini untuk menghitung jumlah lembar dalam buku kerja di Excel:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Metode 1: Hitung jumlah lembar di buku kerja yang aktif<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">SubCountSheetsActive<\/span> ()\n   <span style=\"color: #000000;\">Range(\" <span style=\"color: #ff0000;\">A1<\/span> \") = ThisWorkbook.Worksheets.Count<\/span>\n<span style=\"color: #0000ff;\">End Sub\n<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\"><strong>Metode 2: hitung jumlah lembar dalam buku kerja yang terbuka<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">SubCountSheetsOpen<\/span> ()\n    Range(\" <span style=\"color: #ff0000;\">A1<\/span> \") = Workbooks(\" <span style=\"color: #ff0000;\">my_data.xlsx<\/span> \").Sheets.Count\n<span style=\"color: #0000ff;\">End Sub<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\"><strong>Metode 3: hitung jumlah lembaran dalam pengikat tertutup<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">SubCountSheetsClosed<\/span> ()\n    Application.DisplayAlerts = False\n    Set wb = Workbooks.Open(\" <span style=\"color: #ff0000;\">C:\\Users\\Bob\\Desktop\\my_data.xlsx<\/span> \")\n    \n    <span style=\"color: #008000;\">'count sheets in closed workbook and display count in cell A1 of current workbook<\/span>\n    ThisWorkbook.Sheets(1).Range(\" <span style=\"color: #ff0000;\">A1<\/span> \").Value = wb.Sheets.Count\n\n    wb.Close SaveChanges:=True\n    Application.DisplayAlerts = True\n<span style=\"color: #0000ff;\">End Sub<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan masing-masing metode ini dalam praktik.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 1: Hitung jumlah lembar dalam buku kerja yang aktif<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Katakanlah kita membuka buku kerja Excel berikut dan kita melihatnya:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-34107 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/vbasheets1.jpg\" alt=\"\" width=\"502\" height=\"352\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita bisa menggunakan makro berikut untuk menghitung jumlah total lembar di buku kerja ini dan menampilkan nomor di sel A1:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">SubCountSheetsActive<\/span> ()\n   Range(\" <span style=\"color: #ff0000;\">A1<\/span> \") = ThisWorkbook.Worksheets.Count\n<span style=\"color: #0000ff;\">End Sub<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Saat kami menjalankan makro ini, kami menerima keluaran berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-34108 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/vbasheets2.jpg\" alt=\"\" width=\"481\" height=\"353\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa sel <b>A1<\/b> berisi nilai <strong>6<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Ini memberitahu kita bahwa ada 6 lembar di buku kerja ini.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 2: Hitung jumlah lembar dalam binder terbuka<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Katakanlah kita memiliki buku kerja Excel bernama <strong>my_data.xlsx<\/strong> dengan dua lembar terbuka tetapi saat ini kita tidak melihatnya.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita bisa menggunakan makro berikut untuk menghitung jumlah total lembar dalam buku kerja ini dan menampilkan nomor di sel A1 buku kerja yang aktif:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">SubCountSheetsOpen<\/span> ()\n    Range(\" <span style=\"color: #ff0000;\">A1<\/span> \") = Workbooks(\" <span style=\"color: #ff0000;\">my_data.xlsx<\/span> \").Sheets.Count\n<span style=\"color: #0000ff;\">End Sub<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Saat kami menjalankan makro ini, kami menerima keluaran berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-34109 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/vbasheets3.jpg\" alt=\"\" width=\"499\" height=\"348\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa sel <b>A1<\/b> berisi nilai <strong>2<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Ini memberitahu kita bahwa ada 2 lembar di buku kerja terbuka bernama <strong>my_data.xlsx<\/strong> .<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 3: Menghitung jumlah lembar dalam binder tertutup<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Katakanlah kita memiliki buku kerja Excel bernama <strong>my_data.xlsx<\/strong> dengan dua lembar yang saat ini tidak terbuka tetapi terletak di lokasi file berikut:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>C:\\Users\\Bob\\Desktop\\my_data.xlsx<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita bisa menggunakan makro berikut untuk menghitung jumlah total lembar dalam buku kerja ini dan menampilkan nomor di sel A1 lembar pertama buku kerja yang aktif:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">SubCountSheetsClosed<\/span> ()\n    Application.DisplayAlerts = False\n    Set wb = Workbooks.Open(\" <span style=\"color: #ff0000;\">C:\\Users\\Bob\\Desktop\\my_data.xlsx<\/span> \")\n    \n    <span style=\"color: #008000;\">'count sheets in closed workbook and display count in cell A1 of current workbook<\/span>\n    ThisWorkbook.Sheets(1).Range(\" <span style=\"color: #ff0000;\">A1<\/span> \").Value = wb.Sheets.Count\n\n    wb.Close SaveChanges:=True\n    Application.DisplayAlerts = True\n<span style=\"color: #0000ff;\">End Sub<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Saat kami menjalankan makro ini, kami menerima keluaran berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-34109 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/vbasheets3.jpg\" alt=\"\" width=\"499\" height=\"348\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa sel <b>A1<\/b> berisi nilai <strong>2<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Ini memberitahu kita bahwa ada 2 lembar di buku kerja tertutup yang disebut <strong>my_data.xlsx<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Pada kodenya, <strong>Application.DisplayAlerts=False<\/strong> memberitahu VBA untuk tidak menampilkan proses membuka buku kerja yang tertutup, menghitung lembar, dan kemudian menutup buku kerja.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di VBA:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/vba-menghitung-baris-dalam-jangkauan\/\" target=\"_blank\" rel=\"noopener\">VBA: Cara menghitung jumlah baris dalam jangkauan<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/vba-menghitung-sel-dengan-teks-tertentu\/\" target=\"_blank\" rel=\"noopener\">VBA: Cara menghitung sel dengan teks tertentu<\/a><br \/> VBA: Cara menulis fungsi COUNTIF dan COUNTIFS<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda bisa menggunakan metode berikut ini untuk menghitung jumlah lembar dalam buku kerja di Excel: Metode 1: Hitung jumlah lembar di buku kerja yang aktif SubCountSheetsActive () Range(&#8221; A1 &#8220;) = ThisWorkbook.Worksheets.Count End Sub Metode 2: hitung jumlah lembar dalam buku kerja yang terbuka SubCountSheetsOpen () Range(&#8221; A1 &#8220;) = Workbooks(&#8221; my_data.xlsx &#8220;).Sheets.Count End Sub [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>VBA: Cara menghitung jumlah lembar dalam buku kerja - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung jumlah lembar dalam buku kerja di Excel, beserta contohnya.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/statorials.org\/id\/vba-menghitung-jumlah-lembar\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"VBA: Cara menghitung jumlah lembar dalam buku kerja - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung jumlah lembar dalam buku kerja di Excel, beserta contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/vba-menghitung-jumlah-lembar\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-11T21:10:47+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/vbasheets1.jpg\" \/>\n<meta name=\"author\" content=\"Benjamin anderson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Ditulis oleh\" \/>\n\t<meta name=\"twitter:data1\" content=\"Benjamin anderson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/vba-menghitung-jumlah-lembar\/\",\"url\":\"https:\/\/statorials.org\/id\/vba-menghitung-jumlah-lembar\/\",\"name\":\"VBA: Cara menghitung jumlah lembar dalam buku kerja - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-11T21:10:47+00:00\",\"dateModified\":\"2023-07-11T21:10:47+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung jumlah lembar dalam buku kerja di Excel, beserta contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/vba-menghitung-jumlah-lembar\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/vba-menghitung-jumlah-lembar\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/vba-menghitung-jumlah-lembar\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Vba: cara menghitung jumlah lembar dalam buku kerja\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/statorials.org\/id\/#website\",\"url\":\"https:\/\/statorials.org\/id\/\",\"name\":\"Statorials\",\"description\":\"Panduan anda untuk kompetensi statistik!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/statorials.org\/id\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"id\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\",\"name\":\"Benjamin anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/\",\"url\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"contentUrl\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"caption\":\"Benjamin anderson\"},\"description\":\"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya\",\"sameAs\":[\"http:\/\/statorials.org\/id\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"VBA: Cara menghitung jumlah lembar dalam buku kerja - Statorials","description":"Tutorial ini menjelaskan cara menghitung jumlah lembar dalam buku kerja di Excel, beserta contohnya.","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:\/\/statorials.org\/id\/vba-menghitung-jumlah-lembar\/","og_locale":"id_ID","og_type":"article","og_title":"VBA: Cara menghitung jumlah lembar dalam buku kerja - Statorials","og_description":"Tutorial ini menjelaskan cara menghitung jumlah lembar dalam buku kerja di Excel, beserta contohnya.","og_url":"https:\/\/statorials.org\/id\/vba-menghitung-jumlah-lembar\/","og_site_name":"Statorials","article_published_time":"2023-07-11T21:10:47+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/vbasheets1.jpg"}],"author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/vba-menghitung-jumlah-lembar\/","url":"https:\/\/statorials.org\/id\/vba-menghitung-jumlah-lembar\/","name":"VBA: Cara menghitung jumlah lembar dalam buku kerja - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-11T21:10:47+00:00","dateModified":"2023-07-11T21:10:47+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung jumlah lembar dalam buku kerja di Excel, beserta contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/vba-menghitung-jumlah-lembar\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/vba-menghitung-jumlah-lembar\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/vba-menghitung-jumlah-lembar\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Vba: cara menghitung jumlah lembar dalam buku kerja"}]},{"@type":"WebSite","@id":"https:\/\/statorials.org\/id\/#website","url":"https:\/\/statorials.org\/id\/","name":"Statorials","description":"Panduan anda untuk kompetensi statistik!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/statorials.org\/id\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"id"},{"@type":"Person","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81","name":"Benjamin anderson","image":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/","url":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","contentUrl":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","caption":"Benjamin anderson"},"description":"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya","sameAs":["http:\/\/statorials.org\/id"]}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4340"}],"collection":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/comments?post=4340"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4340\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4340"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4340"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4340"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}