{"id":4867,"date":"2023-07-07T01:42:13","date_gmt":"2023-07-07T01:42:13","guid":{"rendered":"https:\/\/statorials.org\/id\/vba-menghapus-konten-jika-sel-berisi\/"},"modified":"2023-07-07T01:42:13","modified_gmt":"2023-07-07T01:42:13","slug":"vba-menghapus-konten-jika-sel-berisi","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/vba-menghapus-konten-jika-sel-berisi\/","title":{"rendered":"Vba: cara menghapus konten jika sel berisi nilai tertentu"},"content":{"rendered":"

<\/p>\n

\n

Anda bisa menggunakan sintaks dasar berikut untuk menghapus konten setiap sel di lembar kerja Excel yang sama dengan nilai tertentu:<\/span><\/p>\n

 SubClearContentsIfContains<\/span> ()\n\nDim<\/span> cell, rng As<\/span> Range\nSet<\/span> rng = Range(\" A2:A11<\/span> \")\n\nFor Each<\/span> cell In<\/span> rng\n    If<\/span> cell.Value = \" Mavs<\/span> \" Then<\/span>\n    cell.ClearContents\n    Else<\/span>\n    End If<\/span>\nNext<\/span> cell\n\nEnd Sub<\/span><\/strong><\/span><\/pre>\n
 Makro khusus ini akan menghapus konten setiap sel dalam rentang A2:A11<\/strong> yang sama dengan “Mavs”.<\/span><\/span><\/p>\n
 Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya.<\/span><\/p>\n
 Contoh: Gunakan VBA untuk menghapus konten jika sel berisi nilai tertentu<\/strong><\/span><\/h2>\n
 Katakanlah kita memiliki lembar Excel dengan informasi tentang pemain bola basket yang berbeda:<\/span> <\/p>\n
\"\"<\/p>\n
 Katakanlah kita ingin menghapus isi setiap sel di kolom Tim<\/strong> sama dengan “Mavs”.<\/span><\/p>\n
 Kita dapat membuat makro berikut untuk melakukan ini:<\/span><\/p>\n
 SubClearContentsIfContains<\/span> ()\n\nDim<\/span> cell, rng As<\/span> Range\nSet<\/span> rng = Range(\" A2:A11<\/span> \")\n\nFor Each<\/span> cell In<\/span> rng\n    If<\/span> cell.Value = \" Mavs<\/span> \" Then<\/span>\n    cell.ClearContents\n    Else<\/span>\n    End If<\/span>\nNext<\/span> cell\n\nEnd Sub<\/span><\/strong><\/span><\/pre>\n
 Setelah makro ini dijalankan, semua sel dengan nilai “Mavs” di kolom Tim<\/strong> akan dihapus:<\/span> <\/p>\n
\"\"<\/p>\n
 Jika Anda ingin menghapus semua sel di setiap baris dengan nilai “Mavs” di kolom Tim<\/strong> , Anda bisa menggunakan sintaks berikut:<\/span><\/p>\n
 SubClearContentsIfContains<\/span> ()\n\nDim<\/span> cell, rng As<\/span> Range\nSet<\/span> rng = Range(\" A2:A11<\/span> \")\n\nFor Each<\/span> cell In<\/span> rng\n    If<\/span> cell.Value = \" Mavs<\/span> \" Then<\/span>\n    cell.EntireRow.ClearContents\n    Else<\/span>\n    End If<\/span>\nNext<\/span> cell\n\nEnd Sub<\/span><\/strong><\/span><\/pre>\n
 Setelah kami menjalankan makro ini, kami menerima keluaran berikut:<\/span> <\/p>\n
\"\"<\/p>\n
 Perhatikan bahwa semua sel di setiap baris yang berisi “Mavs” di kolom Tim<\/strong> telah dihapus.<\/span><\/p>\n
 Catatan<\/strong> : Anda dapat menemukan dokumentasi lengkap metode ClearContents<\/b> di VBA di sini<\/a> .<\/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 menemukan baris yang terakhir digunakan<\/a>
 VBA: Cara menemukan kolom yang terakhir digunakan<\/a>
 VBA: Cara menampilkan semua sheet<\/a>
<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"
Anda bisa menggunakan sintaks dasar berikut untuk menghapus konten setiap sel di lembar kerja Excel yang sama dengan nilai tertentu: SubClearContentsIfContains () Dim cell, rng As Range Set rng = Range(” A2:A11 “) For Each cell In rng If cell.Value = ” Mavs ” Then cell.ClearContents Else End If Next cell End Sub Makro khusus […]<\/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 menghapus konten jika sel berisi nilai tertentu - Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan VBA untuk menghapus konten sel Excel yang berisi nilai tertentu, dengan 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-menghapus-konten-jika-sel-berisi\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"VBA: Cara menghapus konten jika sel berisi nilai tertentu - Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan VBA untuk menghapus konten sel Excel yang berisi nilai tertentu, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/vba-menghapus-konten-jika-sel-berisi\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-07T01:42:13+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/effacerc1.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=\"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-menghapus-konten-jika-sel-berisi\/\",\"url\":\"https:\/\/statorials.org\/id\/vba-menghapus-konten-jika-sel-berisi\/\",\"name\":\"VBA: Cara menghapus konten jika sel berisi nilai tertentu - Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-07T01:42:13+00:00\",\"dateModified\":\"2023-07-07T01:42:13+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan VBA untuk menghapus konten sel Excel yang berisi nilai tertentu, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/vba-menghapus-konten-jika-sel-berisi\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/vba-menghapus-konten-jika-sel-berisi\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/vba-menghapus-konten-jika-sel-berisi\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Vba: cara menghapus konten jika sel berisi nilai tertentu\"}]},{\"@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 konten jika sel berisi nilai tertentu - Statorial","description":"Tutorial ini menjelaskan cara menggunakan VBA untuk menghapus konten sel Excel yang berisi nilai tertentu, dengan 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-menghapus-konten-jika-sel-berisi\/","og_locale":"id_ID","og_type":"article","og_title":"VBA: Cara menghapus konten jika sel berisi nilai tertentu - Statorial","og_description":"Tutorial ini menjelaskan cara menggunakan VBA untuk menghapus konten sel Excel yang berisi nilai tertentu, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/vba-menghapus-konten-jika-sel-berisi\/","og_site_name":"Statorials","article_published_time":"2023-07-07T01:42:13+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/effacerc1.png"}],"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-menghapus-konten-jika-sel-berisi\/","url":"https:\/\/statorials.org\/id\/vba-menghapus-konten-jika-sel-berisi\/","name":"VBA: Cara menghapus konten jika sel berisi nilai tertentu - Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-07T01:42:13+00:00","dateModified":"2023-07-07T01:42:13+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan VBA untuk menghapus konten sel Excel yang berisi nilai tertentu, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/vba-menghapus-konten-jika-sel-berisi\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/vba-menghapus-konten-jika-sel-berisi\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/vba-menghapus-konten-jika-sel-berisi\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Vba: cara menghapus konten jika sel berisi nilai tertentu"}]},{"@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\/4867"}],"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=4867"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4867\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4867"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4867"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4867"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}