{"id":4424,"date":"2023-07-11T05:25:46","date_gmt":"2023-07-11T05:25:46","guid":{"rendered":"https:\/\/statorials.org\/id\/vba-menyembunyikan-garis-berdasarkan-kriteria\/"},"modified":"2023-07-11T05:25:46","modified_gmt":"2023-07-11T05:25:46","slug":"vba-menyembunyikan-garis-berdasarkan-kriteria","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/vba-menyembunyikan-garis-berdasarkan-kriteria\/","title":{"rendered":"Vba: cara menyembunyikan baris berdasarkan kriteria"},"content":{"rendered":"

<\/p>\n

\n

Anda dapat menggunakan sintaks berikut di VBA untuk menyembunyikan baris berdasarkan nilai sel:<\/span><\/p>\n

 SubHideRows<\/span> ()\n\n    Dim<\/span> i As<\/span> Integer\n    \n    For<\/span> i = 2 To<\/span> 10\n    \n        If<\/span> Cells(i, 1).Value = \" Mavs<\/span> \" Then<\/span>\n            Cells(i, 1).EntireRow.Hidden = True\n        Else<\/span>\n            Cells(i, 1).EntireRow.Hidden = False\n        End If<\/span>\n        \n    Next<\/span> i\n\nEnd Sub\n<\/span><\/strong><\/span><\/pre>\n
 Makro khusus ini menyembunyikan semua baris dalam rentang 2 hingga 10 yang memiliki nilai sel sama dengan “Mavs” di kolom pertama.<\/span><\/p>\n
 Anda juga bisa menggunakan makro berikut untuk menampilkan semua baris:<\/span><\/span><\/p>\n
 SubUnhideRows<\/span> ()\n    Rows.EntireRow.Hidden = False\nEnd Sub<\/span>\n<\/strong><\/span><\/pre>\n
 Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya.<\/span><\/p>\n
 Contoh: Gunakan VBA untuk menyembunyikan baris berdasarkan kriteria<\/strong><\/span><\/h2>\n
 Misalkan kita mempunyai kumpulan data berikut yang berisi informasi tentang berbagai pemain bola basket:<\/span> <\/p>\n
\"\"<\/p>\n
 Katakanlah kita ingin menyembunyikan setiap baris yang berisi “Mavs” di kolom tim.<\/span><\/p>\n
 Kita dapat membuat makro berikut untuk melakukan ini:<\/span><\/p>\n
 SubHideRows<\/span> ()\n\n    Dim<\/span> i As<\/span> Integer\n    \n    For<\/span> i = 2 To<\/span> 10\n    \n        If<\/span> Cells(i, 1).Value = \" Mavs<\/span> \" Then<\/span>\n            Cells(i, 1).EntireRow.Hidden = True\n        Else<\/span>\n            Cells(i, 1).EntireRow.Hidden = False\n        End If<\/span>\n        \n    Next<\/span> i\n\nEnd Sub<\/span><\/strong><\/span><\/pre>\n
 Saat kami menjalankan makro ini, kami menerima keluaran berikut:<\/span> <\/p>\n
\"\"<\/p>\n
 Perhatikan bahwa setiap baris yang berisi “Mavs” di kolom tim kini telah disembunyikan.<\/span><\/p>\n
 Jika mau, kita bisa membuat makro berikut untuk menampilkan semua baris:<\/span><\/p>\n
 SubUnhideRows<\/span> ()\n    Rows.EntireRow.Hidden = False\nEnd Sub<\/span><\/strong><\/span><\/pre>\n
 Saat kami menjalankan makro ini, kami menerima keluaran berikut:<\/span> <\/p>\n
\"\"<\/p>\n
 Perhatikan bahwa semua baris ditampilkan lagi.<\/span><\/p>\n
 Perhatikan bahwa di makro kami, kami menentukan For i = 2 To 10<\/strong> untuk menyembunyikan baris antara 2 dan 10 berdasarkan kriteria.<\/span><\/p>\n
 Jangan ragu untuk mengubah nilai awal dan akhir ini untuk menyembunyikan baris dalam rentang baris yang berbeda.<\/span><\/p>\n
 Sumber daya tambahan<\/strong><\/span><\/h2>\n
 Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di VBA:<\/span><\/p>\n
 VBA: Cara menerapkan pemformatan bersyarat ke sel<\/a>
 VBA: Cara menghitung jumlah baris dalam jangkauan<\/a>
 VBA: Cara menghitung sel dengan teks tertentu<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Anda dapat menggunakan sintaks berikut di VBA untuk menyembunyikan baris berdasarkan nilai sel: SubHideRows () Dim i As Integer For i = 2 To 10 If Cells(i, 1).Value = ” Mavs ” Then Cells(i, 1).EntireRow.Hidden = True Else Cells(i, 1).EntireRow.Hidden = False End If Next i End Sub Makro khusus ini menyembunyikan semua baris dalam […]<\/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":"\nVBA: Cara menyembunyikan garis berdasarkan kriteria - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan VBA untuk menyembunyikan baris di Excel berdasarkan kriteria, 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-menyembunyikan-garis-berdasarkan-kriteria\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"VBA: Cara menyembunyikan garis berdasarkan kriteria - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan VBA untuk menyembunyikan baris di Excel berdasarkan kriteria, beserta sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/vba-menyembunyikan-garis-berdasarkan-kriteria\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-11T05:25:46+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/euh1.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=\"1 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/vba-menyembunyikan-garis-berdasarkan-kriteria\/\",\"url\":\"https:\/\/statorials.org\/id\/vba-menyembunyikan-garis-berdasarkan-kriteria\/\",\"name\":\"VBA: Cara menyembunyikan garis berdasarkan kriteria - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-11T05:25:46+00:00\",\"dateModified\":\"2023-07-11T05:25:46+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan VBA untuk menyembunyikan baris di Excel berdasarkan kriteria, beserta sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/vba-menyembunyikan-garis-berdasarkan-kriteria\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/vba-menyembunyikan-garis-berdasarkan-kriteria\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/vba-menyembunyikan-garis-berdasarkan-kriteria\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Vba: cara menyembunyikan baris berdasarkan kriteria\"}]},{\"@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 menyembunyikan garis berdasarkan kriteria - Statorials","description":"Tutorial ini menjelaskan cara menggunakan VBA untuk menyembunyikan baris di Excel berdasarkan kriteria, 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-menyembunyikan-garis-berdasarkan-kriteria\/","og_locale":"id_ID","og_type":"article","og_title":"VBA: Cara menyembunyikan garis berdasarkan kriteria - Statorials","og_description":"Tutorial ini menjelaskan cara menggunakan VBA untuk menyembunyikan baris di Excel berdasarkan kriteria, beserta sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/vba-menyembunyikan-garis-berdasarkan-kriteria\/","og_site_name":"Statorials","article_published_time":"2023-07-11T05:25:46+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/euh1.jpg"}],"author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"1 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/vba-menyembunyikan-garis-berdasarkan-kriteria\/","url":"https:\/\/statorials.org\/id\/vba-menyembunyikan-garis-berdasarkan-kriteria\/","name":"VBA: Cara menyembunyikan garis berdasarkan kriteria - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-11T05:25:46+00:00","dateModified":"2023-07-11T05:25:46+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan VBA untuk menyembunyikan baris di Excel berdasarkan kriteria, beserta sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/vba-menyembunyikan-garis-berdasarkan-kriteria\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/vba-menyembunyikan-garis-berdasarkan-kriteria\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/vba-menyembunyikan-garis-berdasarkan-kriteria\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Vba: cara menyembunyikan baris berdasarkan kriteria"}]},{"@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\/4424"}],"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=4424"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4424\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4424"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4424"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4424"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}