{"id":4470,"date":"2023-07-10T20:42:32","date_gmt":"2023-07-10T20:42:32","guid":{"rendered":"https:\/\/statorials.org\/id\/vba-menghitung-baris-dalam-tabel\/"},"modified":"2023-07-10T20:42:32","modified_gmt":"2023-07-10T20:42:32","slug":"vba-menghitung-baris-dalam-tabel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/vba-menghitung-baris-dalam-tabel\/","title":{"rendered":"Cara menghitung baris dalam tabel menggunakan vba (dengan contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan sintaks berikut untuk menghitung jumlah baris dalam tabel di Excel menggunakan VBA:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">SubCountTableRow<\/span> ()\n\n<span style=\"color: #0000ff;\">Dim<\/span> tbl <span style=\"color: #0000ff;\">As<\/span> ListObject\n\n<span style=\"color: #008000;\">'specify table to count rows in\n<\/span><span style=\"color: #0000ff;\">Set<\/span> tbl = ActiveSheet.ListObjects(\" <span style=\"color: #ff0000;\">Table1<\/span> \")\n\n<span style=\"color: #008000;\">'create message box that displays row count\n<\/span>MsgBox \" <span style=\"color: #ff0000;\">Total Rows:<\/span> \" &amp; tbl.Range.Rows.Count &amp; vbNewLine &amp; _\n       \" <span style=\"color: #ff0000;\">Header Rows:<\/span> \" &amp; tbl.HeaderRowRange.Rows.Count &amp; vbNewLine &amp; _\n       \" <span style=\"color: #ff0000;\">Body Rows:<\/span> \" &amp; tbl.ListRows.Count\n\n<span style=\"color: #008000;\">'set tbl variable to Nothing\n<\/span><span style=\"color: #0000ff;\">Set<\/span> tbl = Nothing\n\n<span style=\"color: #0000ff;\">End Sub\n<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Contoh khusus ini menghitung jumlah baris berikut untuk tabel pada lembar aktif yang disebut <strong>Tabel1<\/strong> :<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Jumlah total baris<\/span><\/li>\n<li> <span style=\"color: #000000;\">Jumlah total baris header<\/span><\/li>\n<li> <span style=\"color: #000000;\">Jumlah total garis tubuh<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Kami menggunakan fungsi <strong>MsgBox<\/strong> untuk membuat kotak pesan yang menampilkan masing-masing nilai ini dalam satu kotak pesan.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Kami menggunakan pernyataan <strong>vbNewLine<\/strong> untuk menyisipkan baris baru dan membuat kotak pesan dengan banyak baris.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: Cara menghitung baris dalam tabel menggunakan VBA<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita mempunyai tabel berikut bernama <strong>Tabel1<\/strong> yang berisi informasi tentang berbagai pemain bola basket:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-34987 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/compte1.png\" alt=\"\" width=\"578\" height=\"500\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat membuat makro berikut untuk menghitung jumlah baris dalam tabel ini:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">SubCountTableRow<\/span> ()\n\n<span style=\"color: #0000ff;\">Dim<\/span> tbl <span style=\"color: #0000ff;\">As<\/span> ListObject\n\n<span style=\"color: #008000;\">'specify table to count rows in\n<\/span><span style=\"color: #0000ff;\">Set<\/span> tbl = ActiveSheet.ListObjects(\" <span style=\"color: #ff0000;\">Table1<\/span> \")\n\n<span style=\"color: #008000;\">'create message box that displays row count\n<\/span>MsgBox \" <span style=\"color: #ff0000;\">Total Rows:<\/span> \" &amp; tbl.Range.Rows.Count &amp; vbNewLine &amp; _\n       \" <span style=\"color: #ff0000;\">Header Rows:<\/span> \" &amp; tbl.HeaderRowRange.Rows.Count &amp; vbNewLine &amp; _\n       \" <span style=\"color: #ff0000;\">Body Rows:<\/span> \" &amp; tbl.ListRows.Count\n\n<span style=\"color: #008000;\">'set tbl variable to Nothing\n<\/span><span style=\"color: #0000ff;\">Set<\/span> tbl = Nothing\n\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-34988 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/compte2.png\" alt=\"\" width=\"528\" height=\"478\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Kotak pesan memberitahu kita bahwa ada total <strong>10<\/strong> baris dalam tabel.<\/span><\/span><\/p>\n<p> <span style=\"color: #000000;\">Ini juga memberitahu kita bahwa ada <strong>1<\/strong> baris header dan <strong>9<\/strong> baris isi.<\/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\/jumlah-vba-unik\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung nilai unik dalam rentang menggunakan VBA<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/vba-menghitung-baris-dalam-jangkauan\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung jumlah baris dalam suatu rentang menggunakan VBA<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/vba-menghitung-sel-dengan-teks-tertentu\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung sel dengan teks tertentu menggunakan VBA<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan sintaks berikut untuk menghitung jumlah baris dalam tabel di Excel menggunakan VBA: SubCountTableRow () Dim tbl As ListObject &#8216;specify table to count rows in Set tbl = ActiveSheet.ListObjects(&#8221; Table1 &#8220;) &#8216;create message box that displays row count MsgBox &#8221; Total Rows: &#8221; &amp; tbl.Range.Rows.Count &amp; vbNewLine &amp; _ &#8221; Header Rows: &#8221; [&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>Cara Menghitung Baris dalam Tabel Menggunakan VBA (dengan Contoh) - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung jumlah baris dalam tabel menggunakan VBA, 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-baris-dalam-tabel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menghitung Baris dalam Tabel Menggunakan VBA (dengan Contoh) - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung jumlah baris dalam tabel menggunakan VBA, beserta contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/vba-menghitung-baris-dalam-tabel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-10T20:42:32+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/compte1.png\" \/>\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-baris-dalam-tabel\/\",\"url\":\"https:\/\/statorials.org\/id\/vba-menghitung-baris-dalam-tabel\/\",\"name\":\"Cara Menghitung Baris dalam Tabel Menggunakan VBA (dengan Contoh) - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-10T20:42:32+00:00\",\"dateModified\":\"2023-07-10T20:42:32+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung jumlah baris dalam tabel menggunakan VBA, beserta contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/vba-menghitung-baris-dalam-tabel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/vba-menghitung-baris-dalam-tabel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/vba-menghitung-baris-dalam-tabel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung baris dalam tabel menggunakan vba (dengan contoh)\"}]},{\"@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":"Cara Menghitung Baris dalam Tabel Menggunakan VBA (dengan Contoh) - Statorials","description":"Tutorial ini menjelaskan cara menghitung jumlah baris dalam tabel menggunakan VBA, 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-baris-dalam-tabel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menghitung Baris dalam Tabel Menggunakan VBA (dengan Contoh) - Statorials","og_description":"Tutorial ini menjelaskan cara menghitung jumlah baris dalam tabel menggunakan VBA, beserta contohnya.","og_url":"https:\/\/statorials.org\/id\/vba-menghitung-baris-dalam-tabel\/","og_site_name":"Statorials","article_published_time":"2023-07-10T20:42:32+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/compte1.png"}],"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-baris-dalam-tabel\/","url":"https:\/\/statorials.org\/id\/vba-menghitung-baris-dalam-tabel\/","name":"Cara Menghitung Baris dalam Tabel Menggunakan VBA (dengan Contoh) - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-10T20:42:32+00:00","dateModified":"2023-07-10T20:42:32+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung jumlah baris dalam tabel menggunakan VBA, beserta contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/vba-menghitung-baris-dalam-tabel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/vba-menghitung-baris-dalam-tabel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/vba-menghitung-baris-dalam-tabel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung baris dalam tabel menggunakan vba (dengan contoh)"}]},{"@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\/4470"}],"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=4470"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4470\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4470"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4470"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4470"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}