{"id":4420,"date":"2023-07-11T06:08:28","date_gmt":"2023-07-11T06:08:28","guid":{"rendered":"https:\/\/statorials.org\/id\/vba-menghapus-baris-kosong\/"},"modified":"2023-07-11T06:08:28","modified_gmt":"2023-07-11T06:08:28","slug":"vba-menghapus-baris-kosong","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/vba-menghapus-baris-kosong\/","title":{"rendered":"Cara menghapus baris kosong di vba (dengan contoh)"},"content":{"rendered":"

<\/p>\n

\n

Anda dapat menggunakan metode berikut di VBA untuk menghapus baris kosong:<\/span><\/p>\n

Metode 1: Hapus Baris Kosong dalam Rentang Tertentu<\/strong><\/span><\/p>\n

 Sub<\/span> DeleteEmptyRowsInRange()\n    Sheets(\" Sheet1<\/span> \").Select\n    Range(\" A1:B10<\/span> \").Select\n    Selection.SpecialCells(xlCellTypeBlanks).EntireRow.Delete\nEnd Sub\n<\/span><\/strong><\/span><\/pre>\n
 Makro khusus ini akan menghapus semua baris kosong dari rentang A1:B10<\/strong> dari Sheet1<\/strong> .<\/span><\/p>\n
 Metode 2: Hapus Baris Kosong di Seluruh Lembar<\/strong><\/span><\/p>\n
 Sub<\/span> DeleteEmptyRowsInSheet()\n  \n   'turn off screen updating for faster performance<\/span>\n    Application.ScreenUpdating = False\n  \n    Dim<\/span> i As<\/span> Long\n\n    With<\/span> ActiveSheet\n\n    For<\/span> i = .Cells.SpecialCells(xlCellTypeLastCell).Row To<\/span> 1 Step -1\n        If<\/span> WorksheetFunction.CountA(.Rows(i)) = 0 Then<\/span>\n            ActiveSheet.Rows(i).Delete\n       End If<\/span>\n    Next<\/span>\n\n    End With<\/span>\n  \n    'turn screen updating back on<\/span>\n    Application.ScreenUpdating = True\n  \nEnd Sub\n<\/span><\/strong><\/span><\/pre>\n
 Makro khusus ini akan menghapus semua baris kosong dari seluruh lembar aktif.<\/span><\/p>\n
 Contoh berikut menunjukkan cara menggunakan masing-masing metode dalam praktik.<\/span><\/p>\n
 Contoh 1: Hapus baris kosong dalam rentang tertentu<\/strong><\/span><\/h2>\n
 Katakanlah kita memiliki kumpulan data berikut di Excel yang berisi informasi tentang berbagai pemain bola basket:<\/span> <\/p>\n
\"\"<\/p>\n
 Kita dapat membuat makro berikut untuk menghapus semua baris kosong dari rentang A1:B10<\/strong> pada lembar ini:<\/span><\/p>\n
 Sub<\/span> DeleteEmptyRowsInRange()\n    Sheets(\" Sheet1<\/span> \").Select\n    Range(\" A1:B10<\/span> \").Select\n    Selection.SpecialCells(xlCellTypeBlanks).EntireRow.Delete\nEnd Sub<\/span><\/strong><\/span><\/pre>\n
 Setelah kami menjalankan makro ini, kami menerima keluaran berikut:<\/span> <\/p>\n
\"\"<\/p>\n
 Perhatikan bahwa semua baris kosong telah dihapus dari rentang yang kami tentukan.<\/span><\/p>\n
 Contoh 2: Hapus Baris Kosong di Seluruh Lembar<\/strong><\/span><\/h2>\n
 Katakanlah kita memiliki kumpulan data berikut di Excel yang berisi informasi tentang berbagai pemain bola basket:<\/span> <\/p>\n
\"\"<\/p>\n
 Kita dapat membuat makro berikut untuk menghapus semua baris kosong dari seluruh lembar:<\/span><\/p>\n
 Sub<\/span> DeleteEmptyRowsInSheet()\n  \n   'turn off screen updating for faster performance<\/span>\n    Application.ScreenUpdating = False\n  \n    Dim<\/span> i As<\/span> Long\n\n    With<\/span> ActiveSheet\n\n    For<\/span> i = .Cells.SpecialCells(xlCellTypeLastCell).Row To<\/span> 1 Step -1\n        If<\/span> WorksheetFunction.CountA(.Rows(i)) = 0 Then<\/span>\n            ActiveSheet.Rows(i).Delete\n       End If<\/span>\n    Next<\/span>\n\n    End With<\/span>\n  \n    'turn screen updating back on<\/span>\n    Application.ScreenUpdating = True\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 baris kosong telah dihapus dari seluruh lembar.<\/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 menghapus baris berdasarkan nilai sel<\/a>
 VBA: Cara menghapus sheet jika namanya mengandung teks tertentu<\/a>
 VBA: cara menghapus file<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Anda dapat menggunakan metode berikut di VBA untuk menghapus baris kosong: Metode 1: Hapus Baris Kosong dalam Rentang Tertentu Sub DeleteEmptyRowsInRange() Sheets(” Sheet1 “).Select Range(” A1:B10 “).Select Selection.SpecialCells(xlCellTypeBlanks).EntireRow.Delete End Sub Makro khusus ini akan menghapus semua baris kosong dari rentang A1:B10 dari Sheet1 . Metode 2: Hapus Baris Kosong di Seluruh Lembar Sub DeleteEmptyRowsInSheet() ‘turn […]<\/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":"\nCara Menghapus Baris Kosong di VBA (dengan Contoh) \u2013 Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghapus baris kosong di VBA, dengan beberapa 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-baris-kosong\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menghapus Baris Kosong di VBA (dengan Contoh) \u2013 Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghapus baris kosong di VBA, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/vba-menghapus-baris-kosong\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-11T06:08:28+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/supprimer1.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-kosong\/\",\"url\":\"https:\/\/statorials.org\/id\/vba-menghapus-baris-kosong\/\",\"name\":\"Cara Menghapus Baris Kosong di VBA (dengan Contoh) \u2013 Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-11T06:08:28+00:00\",\"dateModified\":\"2023-07-11T06:08:28+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghapus baris kosong di VBA, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/vba-menghapus-baris-kosong\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/vba-menghapus-baris-kosong\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/vba-menghapus-baris-kosong\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghapus baris kosong di 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 Menghapus Baris Kosong di VBA (dengan Contoh) \u2013 Statorials","description":"Tutorial ini menjelaskan cara menghapus baris kosong di VBA, dengan beberapa 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-baris-kosong\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menghapus Baris Kosong di VBA (dengan Contoh) \u2013 Statorials","og_description":"Tutorial ini menjelaskan cara menghapus baris kosong di VBA, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/vba-menghapus-baris-kosong\/","og_site_name":"Statorials","article_published_time":"2023-07-11T06:08:28+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/supprimer1.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-kosong\/","url":"https:\/\/statorials.org\/id\/vba-menghapus-baris-kosong\/","name":"Cara Menghapus Baris Kosong di VBA (dengan Contoh) \u2013 Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-11T06:08:28+00:00","dateModified":"2023-07-11T06:08:28+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghapus baris kosong di VBA, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/vba-menghapus-baris-kosong\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/vba-menghapus-baris-kosong\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/vba-menghapus-baris-kosong\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghapus baris kosong di 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\/4420"}],"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=4420"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4420\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4420"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4420"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4420"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}