{"id":4412,"date":"2023-07-11T07:39:44","date_gmt":"2023-07-11T07:39:44","guid":{"rendered":"https:\/\/statorials.org\/id\/vba-menghapus-baris-berdasarkan-nilai-sel\/"},"modified":"2023-07-11T07:39:44","modified_gmt":"2023-07-11T07:39:44","slug":"vba-menghapus-baris-berdasarkan-nilai-sel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/vba-menghapus-baris-berdasarkan-nilai-sel\/","title":{"rendered":"Vba: cara menghapus baris berdasarkan nilai sel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan sintaks berikut di VBA untuk menghapus baris berdasarkan nilai sel:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">Sub<\/span> DeleteRowsByValue()\n\n    <span style=\"color: #0000ff;\">Dim<\/span> ws <span style=\"color: #0000ff;\">As<\/span> Worksheet\n    <span style=\"color: #0000ff;\">Set<\/span> ws = ActiveSheet\n  \n    <span style=\"color: #008000;\">'clear existing filters<\/span>\n    <span style=\"color: #0000ff;\">On Error Resume Next<\/span>\n    ws.ShowAllData\n    <span style=\"color: #0000ff;\">On Error GoTo 0<\/span>\n    \n    <span style=\"color: #008000;\">'filter range where column 2 in range is equal to \"East\"<\/span>\n    ws.Range(\" <span style=\"color: #ff0000;\">A1:C10<\/span> \").AutoFilter Field:=2, Criteria1:=\" <span style=\"color: #ff0000;\">East<\/span> \"\n  \n    <span style=\"color: #008000;\">'delete rows that are visible<\/span>\n    Application.DisplayAlerts = False\n    ws.Range(\" <span style=\"color: #ff0000;\">A2:C10<\/span> \").SpecialCells(xlCellTypeVisible).Delete\n    Application.DisplayAlerts = True\n  \n    <span style=\"color: #008000;\">'remove filter<\/span>\n    <span style=\"color: #0000ff;\">On Error Resume Next<\/span>\n    ws.ShowAllData\n    <span style=\"color: #0000ff;\">On Error GoTo 0<\/span>\n  \n<span style=\"color: #0000ff;\">End Sub\n<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Makro khusus ini menghapus semua baris dalam rentang <strong>A1:C10<\/strong> di mana nilai kolom B sama dengan &#8220;Is&#8221;.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Makro ini menggunakan langkah-langkah berikut:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Terapkan filter ke <strong>A1:C10<\/strong> untuk hanya menampilkan baris yang nilainya di kolom B adalah &#8220;Is&#8221;.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Kemudian hapus semua sel yang terlihat.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Kemudian hapus filternya.<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Hal ini berdampak pada penghapusan semua baris pada rentang <strong>A1:C10<\/strong> yang nilai pada kolom B sama dengan &#8220;Is&#8221;.<\/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: Gunakan VBA untuk Menghapus Baris Berdasarkan Nilai Sel<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita mempunyai kumpulan data berikut yang berisi informasi tentang berbagai pemain bola basket:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-34588 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/db1.jpg\" alt=\"\" width=\"531\" height=\"439\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Katakanlah kita ingin menghapus setiap baris dari kumpulan data yang kolom Konferensinya sama dengan &#8220;Timur&#8221;.<\/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;\">Sub<\/span> DeleteRowsByValue()\n\n    <span style=\"color: #0000ff;\">Dim<\/span> ws <span style=\"color: #0000ff;\">As<\/span> Worksheet\n    <span style=\"color: #0000ff;\">Set<\/span> ws = ActiveSheet\n  \n    <span style=\"color: #008000;\">'clear existing filters<\/span>\n    <span style=\"color: #0000ff;\">On Error Resume Next<\/span>\n    ws.ShowAllData\n    <span style=\"color: #0000ff;\">On Error GoTo 0<\/span>\n    \n    <span style=\"color: #008000;\">'filter range where column 2 in range is equal to \"East\"<\/span>\n    ws.Range(\" <span style=\"color: #ff0000;\">A1:C10<\/span> \").AutoFilter Field:=2, Criteria1:=\" <span style=\"color: #ff0000;\">East<\/span> \"\n  \n    <span style=\"color: #008000;\">'delete rows that are visible<\/span>\n    Application.DisplayAlerts = False\n    ws.Range(\" <span style=\"color: #ff0000;\">A2:C10<\/span> \").SpecialCells(xlCellTypeVisible).Delete\n    Application.DisplayAlerts = True\n  \n    <span style=\"color: #008000;\">'remove filter<\/span>\n    <span style=\"color: #0000ff;\">On Error Resume Next<\/span>\n    ws.ShowAllData\n    <span style=\"color: #0000ff;\">On Error GoTo 0<\/span>\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-34589 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/db2.jpg\" alt=\"\" width=\"523\" height=\"416\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa semua baris yang nilai kolom Konferensinya adalah \u201cTimur\u201d telah dihapus.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Baris <strong>Application.DisplayAlerts=False<\/strong> memberitahu VBA untuk tidak menampilkan proses menghilangkan garis yang terlihat, sehingga mempercepat proses.<\/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\/pemformatan-bersyarat-vba\/\" target=\"_blank\" rel=\"noopener\">VBA: Cara menerapkan pemformatan bersyarat ke sel<\/a><br \/> <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><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan sintaks berikut di VBA untuk menghapus baris berdasarkan nilai sel: Sub DeleteRowsByValue() Dim ws As Worksheet Set ws = ActiveSheet &#8216;clear existing filters On Error Resume Next ws.ShowAllData On Error GoTo 0 &#8216;filter range where column 2 in range is equal to &#8220;East&#8221; ws.Range(&#8221; A1:C10 &#8220;).AutoFilter Field:=2, Criteria1:=&#8221; East &#8221; &#8216;delete rows [&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 menghapus baris berdasarkan nilai sel \u2013 Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghapus baris di Excel berdasarkan nilai sel 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-menghapus-baris-berdasarkan-nilai-sel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"VBA: Cara menghapus baris berdasarkan nilai sel \u2013 Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghapus baris di Excel berdasarkan nilai sel menggunakan VBA, beserta contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/vba-menghapus-baris-berdasarkan-nilai-sel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-11T07:39:44+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/db1.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-menghapus-baris-berdasarkan-nilai-sel\/\",\"url\":\"https:\/\/statorials.org\/id\/vba-menghapus-baris-berdasarkan-nilai-sel\/\",\"name\":\"VBA: Cara menghapus baris berdasarkan nilai sel \u2013 Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-11T07:39:44+00:00\",\"dateModified\":\"2023-07-11T07:39:44+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghapus baris di Excel berdasarkan nilai sel menggunakan VBA, beserta contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/vba-menghapus-baris-berdasarkan-nilai-sel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/vba-menghapus-baris-berdasarkan-nilai-sel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/vba-menghapus-baris-berdasarkan-nilai-sel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Vba: cara menghapus baris berdasarkan nilai sel\"}]},{\"@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 menghapus baris berdasarkan nilai sel \u2013 Statorial","description":"Tutorial ini menjelaskan cara menghapus baris di Excel berdasarkan nilai sel 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-menghapus-baris-berdasarkan-nilai-sel\/","og_locale":"id_ID","og_type":"article","og_title":"VBA: Cara menghapus baris berdasarkan nilai sel \u2013 Statorial","og_description":"Tutorial ini menjelaskan cara menghapus baris di Excel berdasarkan nilai sel menggunakan VBA, beserta contohnya.","og_url":"https:\/\/statorials.org\/id\/vba-menghapus-baris-berdasarkan-nilai-sel\/","og_site_name":"Statorials","article_published_time":"2023-07-11T07:39:44+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/db1.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-menghapus-baris-berdasarkan-nilai-sel\/","url":"https:\/\/statorials.org\/id\/vba-menghapus-baris-berdasarkan-nilai-sel\/","name":"VBA: Cara menghapus baris berdasarkan nilai sel \u2013 Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-11T07:39:44+00:00","dateModified":"2023-07-11T07:39:44+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghapus baris di Excel berdasarkan nilai sel menggunakan VBA, beserta contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/vba-menghapus-baris-berdasarkan-nilai-sel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/vba-menghapus-baris-berdasarkan-nilai-sel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/vba-menghapus-baris-berdasarkan-nilai-sel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Vba: cara menghapus baris berdasarkan nilai sel"}]},{"@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\/4412"}],"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=4412"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4412\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4412"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4412"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4412"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}