{"id":4325,"date":"2023-07-11T23:58:42","date_gmt":"2023-07-11T23:58:42","guid":{"rendered":"https:\/\/statorials.org\/id\/vba-menghitung-baris-dalam-jangkauan\/"},"modified":"2023-07-11T23:58:42","modified_gmt":"2023-07-11T23:58:42","slug":"vba-menghitung-baris-dalam-jangkauan","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/vba-menghitung-baris-dalam-jangkauan\/","title":{"rendered":"Vba: cara menghitung jumlah baris dalam jangkauan"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan sintaks dasar berikut untuk menghitung jumlah baris dalam suatu rentang di Excel menggunakan VBA:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">SubCountRows<\/span> ()\n    Range(\" <span style=\"color: #ff0000;\">E2<\/span> \") = Range(\" <span style=\"color: #ff0000;\">A:A<\/span> \").Cells.SpecialCells(xlCellTypeConstants).Count\n<span style=\"color: #0000ff;\">End Sub<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Contoh khusus ini menghitung jumlah baris di kolom A, lalu menetapkan hasilnya ke sel <strong>E2<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Jika Anda ingin menampilkan jumlah baris dalam kotak pesan, Anda dapat menggunakan sintaks berikut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">SubCountRows<\/span> ()\n    <span style=\"color: #008000;\">'Create variable to store number of rows\n    <span style=\"color: #000000;\"><span style=\"color: #0000ff;\">Dim<\/span> row_count <span style=\"color: #0000ff;\">As<\/span> Integer\n    \n    <span style=\"color: #008000;\">'Calculate number of rows in range<\/span>\n    row_count = Range(\" <span style=\"color: #ff0000;\">A:A<\/span> \").Cells.SpecialCells(xlCellTypeConstants).Count\n    \n    <span style=\"color: #008000;\">'Display the result<\/span>\n    MsgBox \" <span style=\"color: #ff0000;\">Rows in Column A:<\/span> \" &amp; row_count<\/span>\n<span style=\"color: #0000ff;\">End Sub<\/span><\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Contoh berikut memperlihatkan cara menggunakan masing-masing metode ini dalam praktik dengan kumpulan data berikut di Excel yang berisi nama pemain bola basket dari tiga tim berbeda:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-33996 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/lignesrange1.jpg\" alt=\"\" width=\"474\" height=\"469\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 1: Hitung baris dalam rentang menggunakan VBA dan tampilkan hasilnya dalam sel<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita ingin menghitung jumlah baris di kolom A dan menampilkan hasilnya di sel tertentu.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat membuat makro berikut untuk melakukan ini:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">SubCountRows<\/span> ()\n    Range(\" <span style=\"color: #ff0000;\">E2<\/span> \") = Range(\" <span style=\"color: #ff0000;\">A:A<\/span> \").Cells.SpecialCells(xlCellTypeConstants).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-33997 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/lignesrange2.jpg\" alt=\"\" width=\"490\" height=\"410\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa sel <strong>E2<\/strong> berisi nilai <strong>9<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Ini memberitahu kita bahwa ada 9 baris di kolom A dengan nilai.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 2:<\/strong><\/span> <span style=\"color: #000000;\"><strong>Hitung baris dalam rentang menggunakan VBA dan<\/strong><\/span> <span style=\"color: #000000;\"><strong>tampilkan hasilnya di kotak pesan<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita ingin<\/span> <span style=\"color: #000000;\">menghitung jumlah baris di kolom A dan menampilkan hasilnya di kotak pesan.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat membuat makro berikut untuk melakukan ini:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">SubCountRows<\/span> ()\n    <span style=\"color: #008000;\">'Create variable to store number of rows\n<span style=\"color: #000000;\"><span style=\"color: #0000ff;\">Dim<\/span> row_count <span style=\"color: #0000ff;\">As<\/span> Integer\n    \n    <span style=\"color: #008000;\">'Calculate number of rows in range<\/span>\n    row_count = Range(\" <span style=\"color: #ff0000;\">A:A<\/span> \").Cells.SpecialCells(xlCellTypeConstants).Count\n    \n    <span style=\"color: #008000;\">'Display the result<\/span>\n    MsgBox \" <span style=\"color: #ff0000;\">Rows in Column A:<\/span> \" &amp; row_count<\/span>\n<span style=\"color: #0000ff;\">End Sub<\/span><\/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-33998 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/lignesrange3.jpg\" alt=\"\" width=\"490\" height=\"419\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kotak pesan memberitahu kita bahwa ada <strong>9<\/strong> baris di kolom A dengan nilai.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa dalam contoh ini kami menghitung jumlah baris di seluruh kolom A menggunakan <strong>A:A<\/strong> sebagai rentangnya.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Namun, jika Anda ingin menghitung jumlah baris dengan nilai dalam rentang tertentu, Anda dapat mengetikkan <strong>A2:A9<\/strong> (atau rentang lain yang Anda minati).<\/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\/rata-rata-vba-jika\/\" target=\"_blank\" rel=\"noopener\">VBA: Cara menulis fungsi AVERAGEIF dan AVERAGEIFS<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/jumlah-vba\/\" target=\"_blank\" rel=\"noopener\">VBA: Cara menulis fungsi SUMIF dan SUMIFS<\/a><br \/> VBA: Cara menulis fungsi COUNTIF dan COUNTIFS<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan sintaks dasar berikut untuk menghitung jumlah baris dalam suatu rentang di Excel menggunakan VBA: SubCountRows () Range(&#8221; E2 &#8220;) = Range(&#8221; A:A &#8220;).Cells.SpecialCells(xlCellTypeConstants).Count End Sub Contoh khusus ini menghitung jumlah baris di kolom A, lalu menetapkan hasilnya ke sel E2 . Jika Anda ingin menampilkan jumlah baris dalam kotak pesan, Anda dapat [&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 garis dalam suatu rentang \u2013 Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung jumlah baris dalam suatu range di Excel menggunakan VBA, beserta sebuah contoh.\" \/>\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-jangkauan\/\" \/>\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 garis dalam suatu rentang \u2013 Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung jumlah baris dalam suatu range di Excel menggunakan VBA, beserta sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/vba-menghitung-baris-dalam-jangkauan\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-11T23:58:42+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/lignesrange1.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-baris-dalam-jangkauan\/\",\"url\":\"https:\/\/statorials.org\/id\/vba-menghitung-baris-dalam-jangkauan\/\",\"name\":\"VBA: Cara menghitung jumlah garis dalam suatu rentang \u2013 Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-11T23:58:42+00:00\",\"dateModified\":\"2023-07-11T23:58:42+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung jumlah baris dalam suatu range di Excel menggunakan VBA, beserta sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/vba-menghitung-baris-dalam-jangkauan\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/vba-menghitung-baris-dalam-jangkauan\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/vba-menghitung-baris-dalam-jangkauan\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Vba: cara menghitung jumlah baris dalam jangkauan\"}]},{\"@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 garis dalam suatu rentang \u2013 Statorials","description":"Tutorial ini menjelaskan cara menghitung jumlah baris dalam suatu range di Excel menggunakan VBA, beserta sebuah contoh.","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-jangkauan\/","og_locale":"id_ID","og_type":"article","og_title":"VBA: Cara menghitung jumlah garis dalam suatu rentang \u2013 Statorials","og_description":"Tutorial ini menjelaskan cara menghitung jumlah baris dalam suatu range di Excel menggunakan VBA, beserta sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/vba-menghitung-baris-dalam-jangkauan\/","og_site_name":"Statorials","article_published_time":"2023-07-11T23:58:42+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/lignesrange1.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-baris-dalam-jangkauan\/","url":"https:\/\/statorials.org\/id\/vba-menghitung-baris-dalam-jangkauan\/","name":"VBA: Cara menghitung jumlah garis dalam suatu rentang \u2013 Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-11T23:58:42+00:00","dateModified":"2023-07-11T23:58:42+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung jumlah baris dalam suatu range di Excel menggunakan VBA, beserta sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/vba-menghitung-baris-dalam-jangkauan\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/vba-menghitung-baris-dalam-jangkauan\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/vba-menghitung-baris-dalam-jangkauan\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Vba: cara menghitung jumlah baris dalam jangkauan"}]},{"@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\/4325"}],"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=4325"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4325\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4325"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4325"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4325"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}