{"id":4984,"date":"2023-07-05T13:33:18","date_gmt":"2023-07-05T13:33:18","guid":{"rendered":"https:\/\/statorials.org\/id\/vba-menghapus-rentang-bernama\/"},"modified":"2023-07-05T13:33:18","modified_gmt":"2023-07-05T13:33:18","slug":"vba-menghapus-rentang-bernama","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/vba-menghapus-rentang-bernama\/","title":{"rendered":"Cara menghapus rentang bernama menggunakan vba (dengan contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda bisa menggunakan sintaks berikut di VBA untuk menghapus rentang bernama dari buku kerja Excel:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">Sub<\/span> DeleteNamedRanges()\n \n<span style=\"color: #0000ff;\">Dim<\/span> NamedRange <span style=\"color: #0000ff;\">As<\/span> Name\n\n<span style=\"color: #0000ff;\">For Each<\/span> NamedRange <span style=\"color: #0000ff;\">In<\/span> ActiveWorkbook.Names\n    <span style=\"color: #0000ff;\">If<\/span> NamedRange.Visible <span style=\"color: #0000ff;\">Then<\/span> NamedRange.Delete\n<span style=\"color: #0000ff;\">Next<\/span> NamedRange\n\n<span style=\"color: #0000ff;\">End Sub\n<\/span><\/strong><\/span><\/pre>\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: Hapus Rentang Bernama di Buku Kerja Excel Menggunakan VBA<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki buku kerja Excel yang berisi tiga rentang bernama berikut:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Rentang bernama yang disebut <strong>sheet1_name<\/strong> di <strong>Sheet1<\/strong><\/span><\/li>\n<li> <span style=\"color: #000000;\">Rentang bernama yang disebut <strong>sheet2_name<\/strong> di <strong>Sheet2<\/strong><\/span><\/li>\n<li> <span style=\"color: #000000;\">Rentang bernama yang disebut <strong>sheet3_name<\/strong> di <strong>Sheet3<\/strong><\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Untuk melihat masing-masing rentang bernama ini, cukup klik panah drop-down di <strong>kotak Nama<\/strong> di sudut kiri atas lembar kerja:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-38880 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/derange1.png\" alt=\"\" width=\"416\" height=\"440\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Katakanlah kita ingin menghapus masing-masing rentang bernama ini.<\/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> DeleteNamedRanges()\n \n<span style=\"color: #0000ff;\">Dim<\/span> NamedRange <span style=\"color: #0000ff;\">As<\/span> Name\n\n<span style=\"color: #0000ff;\">For Each<\/span> NamedRange <span style=\"color: #0000ff;\">In<\/span> ActiveWorkbook.Names\n    <span style=\"color: #0000ff;\">If<\/span> NamedRange.Visible <span style=\"color: #0000ff;\">Then<\/span> NamedRange.Delete\n<span style=\"color: #0000ff;\">Next<\/span> NamedRange\n\n<span style=\"color: #0000ff;\">End Sub<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Setelah makro ini dijalankan, semua rentang bernama di seluruh buku kerja akan dihapus.<\/span><\/span><\/p>\n<p> <span style=\"color: #000000;\">Kami dapat memverifikasi bahwa mereka telah dihapus dengan mengklik lagi <strong>kotak Nama<\/strong> di sudut kiri atas salah satu lembar:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-38881 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/derange2.png\" alt=\"\" width=\"447\" height=\"454\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat melihat bahwa <strong>kotak Nama<\/strong> tidak lagi berisi nama rentang bernama.<\/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> <span style=\"color: #000000;\"><a href=\"https:\/\/statorials.org\/id\/nilai-tempel-vba-saja-tanpa-pemformatan\/\" target=\"_blank\" rel=\"noopener\">VBA: Cara menempelkan nilai saja tanpa memformat<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/vba-menyalin-baris-yang-terlihat-ke-lembar-lain\/\" target=\"_blank\" rel=\"noopener\">VBA: Cara menyalin garis yang terlihat ke lembar lain<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/vba-menyalin-baris-ke-lembar-lain-berdasarkan-kriteria\/\" target=\"_blank\" rel=\"noopener\">VBA: menyalin baris ke lembar lain berdasarkan kriteria<\/a><br \/><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda bisa menggunakan sintaks berikut di VBA untuk menghapus rentang bernama dari buku kerja Excel: Sub DeleteNamedRanges() Dim NamedRange As Name For Each NamedRange In ActiveWorkbook.Names If NamedRange.Visible Then NamedRange.Delete Next NamedRange End Sub Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya. Contoh: Hapus Rentang Bernama di Buku Kerja Excel Menggunakan VBA Misalkan kita [&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>Cara Menghapus Rentang Bernama Menggunakan VBA (dengan Contoh) - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghapus rentang bernama di Excel 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-rentang-bernama\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menghapus Rentang Bernama Menggunakan VBA (dengan Contoh) - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghapus rentang bernama di Excel menggunakan VBA, beserta contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/vba-menghapus-rentang-bernama\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-05T13:33:18+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/derange1.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-rentang-bernama\/\",\"url\":\"https:\/\/statorials.org\/id\/vba-menghapus-rentang-bernama\/\",\"name\":\"Cara Menghapus Rentang Bernama Menggunakan VBA (dengan Contoh) - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-05T13:33:18+00:00\",\"dateModified\":\"2023-07-05T13:33:18+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghapus rentang bernama di Excel menggunakan VBA, beserta contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/vba-menghapus-rentang-bernama\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/vba-menghapus-rentang-bernama\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/vba-menghapus-rentang-bernama\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghapus rentang bernama menggunakan 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 Rentang Bernama Menggunakan VBA (dengan Contoh) - Statologi","description":"Tutorial ini menjelaskan cara menghapus rentang bernama di Excel 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-rentang-bernama\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menghapus Rentang Bernama Menggunakan VBA (dengan Contoh) - Statologi","og_description":"Tutorial ini menjelaskan cara menghapus rentang bernama di Excel menggunakan VBA, beserta contohnya.","og_url":"https:\/\/statorials.org\/id\/vba-menghapus-rentang-bernama\/","og_site_name":"Statorials","article_published_time":"2023-07-05T13:33:18+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/derange1.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-rentang-bernama\/","url":"https:\/\/statorials.org\/id\/vba-menghapus-rentang-bernama\/","name":"Cara Menghapus Rentang Bernama Menggunakan VBA (dengan Contoh) - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-05T13:33:18+00:00","dateModified":"2023-07-05T13:33:18+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghapus rentang bernama di Excel menggunakan VBA, beserta contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/vba-menghapus-rentang-bernama\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/vba-menghapus-rentang-bernama\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/vba-menghapus-rentang-bernama\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghapus rentang bernama menggunakan 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\/4984"}],"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=4984"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4984\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4984"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4984"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4984"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}