{"id":1550,"date":"2023-11-17T09:38:55","date_gmt":"2023-11-17T09:38:55","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/rentang-yang-digunakan\/"},"modified":"2023-12-06T06:18:52","modified_gmt":"2023-12-06T06:18:52","slug":"rentang-yang-digunakan","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/rentang-yang-digunakan\/","title":{"rendered":"Bagaimana cara menggunakan properti usedrange di vba?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-795053400\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p>Di VBA, properti UsedRange mewakili rentang lembar kerja yang berisi data. Rentang yang digunakan dimulai dari sel pertama di lembar kerja tempat Anda memiliki nilai hingga sel terakhir tempat Anda memiliki nilai. Sama seperti contoh berikut di mana Anda menggunakan rentang dari A1 hingga C11. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-53428\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-propriete-usedrange.png\" sizes=\"auto, \" srcset=\"\" alt=\"properti rentang yang digunakan\" width=\"521\" height=\"295\"><\/figure><\/div><p class=\"qt-tip\"> <strong>Catatan: Properti UsedRange adalah properti read-only<\/strong> .<\/p><h2 class=\"wp-block-heading\"> Tulis kode dengan UsedRange<\/h2><p> Gunakan kode berikut.<\/p><ol type=\"1\"><li> Pertama, Anda perlu menentukan spreadsheet.<\/li><li> Kemudian masukkan titik (.) dan masukkan \u201cUsedRange\u201d.<\/li><li> Setelah itu gunakan properti atau metode yang ingin Anda gunakan.<\/li><li> Pada akhirnya, jalankan kodenya.<\/li><\/ol><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub vba_used_range() ActiveSheet.UsedRange.Clear End Sub<\/code><\/pre><p> Kode di atas menghapus semuanya dari rentang lembar aktif yang digunakan.<\/p><h2 class=\"wp-block-heading\"> Salin rentang yang digunakan<\/h2><p> Gunakan kode berikut untuk menyalin seluruh UsedRange. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-53429\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-copier-toute-la-plage-utilisee.png\" sizes=\"auto, \" srcset=\"\" alt=\"salin seluruh rentang yang digunakan\" width=\"551\" height=\"410\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub vba_used_range() ActiveSheet.UsedRange.Copy End Sub<\/code><\/pre><h2 class=\"wp-block-heading\"> Hitung baris dan kolom dalam rentang yang digunakan<\/h2><p> Ada properti count yang dapat Anda gunakan untuk menghitung baris dan kolom dari rentang yang digunakan.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">MsgBox ActiveSheet.UsedRange.Rows.Count MsgBox ActiveSheet.UsedRange.Columns.Count<\/code><\/pre><p> Dua baris kode di atas menampilkan kotak pesan dengan jumlah baris dan kolom yang Anda miliki dalam rentang yang digunakan.<\/p><h2 class=\"wp-block-heading\"> Aktifkan sel terakhir dalam rentang yang digunakan<\/h2><p> Anda juga bisa mengaktifkan sel terakhir dalam rentang yang digunakan (ini akan menjadi sel terakhir yang digunakan di lembar kerja). Perhatikan kode berikut. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-53430\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-dernieres-cellules-actives-de-la-plage-utilisee.png\" sizes=\"auto, \" srcset=\"\" alt=\"sel aktif terakhir dari rentang yang digunakan\" width=\"641\" height=\"403\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub vba_used_range() Dim iCol As Long Dim iRow As Long iRow = ActiveSheet.UsedRange.Rows.Count iCol = ActiveSheet.UsedRange.Columns.Count ActiveSheet.UsedRange.Select Selection.Cells(iRow, iCol).Select End Sub<\/code><\/pre><p> Kode ini mengambil jumlah baris dan kolom menggunakan properti UsedRange dan kemudian menggunakan angka-angka ini untuk memilih sel terakhir dalam rentang yang digunakan.<\/p><h2 class=\"wp-block-heading\"> Lihat UsedRange di lembar kerja lain<\/h2><p> Jika Anda mencoba merujuk ke rentang yang digunakan di lembar kerja selain lembar aktif, VBA akan menampilkan kesalahan seperti ini. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-53431\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-plage-utilisee-dans-une-autre-feuille-de-calcul.png\" sizes=\"auto, \" srcset=\"\" alt=\"rentang yang digunakan di lembar kerja lain\" width=\"465\" height=\"331\"><\/figure><\/div><p> Jadi lembar kerja yang Anda maksud harus diaktifkan (barulah Anda dapat menggunakan properti UsedRange).<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub vba_used_range() Worksheets(\"Sheet4\").Activate Worksheets(\"Sheet4\").UsedRange.Select End Sub<\/code><\/pre><p> Ini berarti Anda tidak bisa mereferensikan rentang yang digunakan dalam buku kerja tertutup. Namun Anda bisa membuka buku kerja terlebih dahulu lalu mengaktifkan lembar kerja untuk menggunakan properti UsedRange.<\/p><h2 class=\"wp-block-heading\"> Dapatkan alamat rentang yang digunakan<\/h2><p> Gunakan baris kode berikut untuk mendapatkan alamat rentang yang digunakan.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub vba_used_range() MsgBox ActiveSheet.UsedRange.Address End Sub<\/code><\/pre><h2 class=\"wp-block-heading\"> Hitung sel kosong dalam rentang yang digunakan<\/h2><p> Kode berikut menggunakan <a href=\"https:\/\/exceladvisor.org\/id\/untuk-lingkaran\/\">perulangan FOR (Untuk Masing-masing)<\/a> dan mengulang semua sel dalam rentang yang digunakan dan menghitung sel kosong.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub vba_used_range() Dim iCell As Range Dim iRange As Range Dim c As Long Dim i As Long Set iRange = ActiveSheet.UsedRange For Each iCell In ActiveSheet.UsedRange c = c + 1 If IsEmpty(iCell) = True Then i = i + 1 End If Next iCell MsgBox \"There are total \" &amp; c &amp; _ \" cell(s) in the range, and out of those \" &amp; _ i &amp; \" cell(s) are empty.\" End Sub<\/code><\/pre><p> Saat Anda menjalankan kode ini, ini akan menampilkan <a href=\"https:\/\/exceladvisor.org\/id\/kotak-pesan-vba\/\">kotak pesan<\/a> dengan jumlah total sel dan jumlah sel kosong.<\/p><div class=\"gb-container gb-container-4db6181c gb-container-mt\"> <a class=\"gb-button gb-button-c5897111 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/id\/vba\/\">Apa itu VBA<\/a><h2 class=\"gb-headline gb-headline-665e5f6b gb-headline-text gb-headline-mt-heading\"> Tutorial terkait <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a20baf7c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-65ddf67e\"><div class=\"gb-container gb-container-65ddf67e\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/id\/jumlah-baris\/\">Hitung baris menggunakan VBA di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/huruf-karakter\/\">Font Excel VBA (warna, ukuran, jenis dan tebal)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/sembunyikan-tampilkan-baris-kolom\/\">Excel VBA Sembunyikan dan tampilkan kolom atau baris<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/rentang-1\/\">Rentang VBA Excel \u2013 Bekerja dengan Rentang dan Sel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/perbatasan\/\">Terapkan batas ke sel menggunakan VBA di Excel<\/a> <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-50067b57\"><div class=\"gb-container gb-container-50067b57\"><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-1550","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Bagaimana cara menggunakan properti UsedRange di VBA di Excel?<\/title>\n<meta name=\"description\" content=\"Properti UsedRange mewakili rentang lembar kerja yang berisi data. Ini dimulai dengan sel pertama tempat Anda memiliki nilai dan\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/id\/rentang-yang-digunakan\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bagaimana cara menggunakan properti UsedRange di VBA di Excel?\" \/>\n<meta property=\"og:description\" content=\"Properti UsedRange mewakili rentang lembar kerja yang berisi data. Ini dimulai dengan sel pertama tempat Anda memiliki nilai dan\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/rentang-yang-digunakan\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:18:52+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-propriete-usedrange.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data1\" content=\"3 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/id\/rentang-yang-digunakan\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/rentang-yang-digunakan\/\",\"name\":\"Bagaimana cara menggunakan properti UsedRange di VBA di Excel?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/rentang-yang-digunakan\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/rentang-yang-digunakan\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-propriete-usedrange.png\",\"datePublished\":\"2023-11-17T09:38:55+00:00\",\"dateModified\":\"2023-12-06T06:18:52+00:00\",\"description\":\"Properti UsedRange mewakili rentang lembar kerja yang berisi data. Ini dimulai dengan sel pertama tempat Anda memiliki nilai dan\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/rentang-yang-digunakan\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/rentang-yang-digunakan\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/rentang-yang-digunakan\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-propriete-usedrange.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-propriete-usedrange.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/rentang-yang-digunakan\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara menggunakan properti usedrange di vba?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"name\":\"Excel Advisor\",\"description\":\"Panduan utama Anda untuk mendominasi data!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/id\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"id\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Bagaimana cara menggunakan properti UsedRange di VBA di Excel?","description":"Properti UsedRange mewakili rentang lembar kerja yang berisi data. Ini dimulai dengan sel pertama tempat Anda memiliki nilai dan","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:\/\/exceladvisor.org\/id\/rentang-yang-digunakan\/","og_locale":"id_ID","og_type":"article","og_title":"Bagaimana cara menggunakan properti UsedRange di VBA di Excel?","og_description":"Properti UsedRange mewakili rentang lembar kerja yang berisi data. Ini dimulai dengan sel pertama tempat Anda memiliki nilai dan","og_url":"https:\/\/exceladvisor.org\/id\/rentang-yang-digunakan\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:18:52+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-propriete-usedrange.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Estimasi waktu membaca":"3 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/id\/rentang-yang-digunakan\/","url":"https:\/\/exceladvisor.org\/id\/rentang-yang-digunakan\/","name":"Bagaimana cara menggunakan properti UsedRange di VBA di Excel?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/rentang-yang-digunakan\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/rentang-yang-digunakan\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-propriete-usedrange.png","datePublished":"2023-11-17T09:38:55+00:00","dateModified":"2023-12-06T06:18:52+00:00","description":"Properti UsedRange mewakili rentang lembar kerja yang berisi data. Ini dimulai dengan sel pertama tempat Anda memiliki nilai dan","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/rentang-yang-digunakan\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/rentang-yang-digunakan\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/rentang-yang-digunakan\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-propriete-usedrange.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-propriete-usedrange.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/rentang-yang-digunakan\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara menggunakan properti usedrange di vba?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/id\/#website","url":"https:\/\/exceladvisor.org\/id\/","name":"Excel Advisor","description":"Panduan utama Anda untuk mendominasi data!","publisher":{"@id":"https:\/\/exceladvisor.org\/id\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/id\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"id"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/id\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/id\/","logo":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1550","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/comments?post=1550"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1550\/revisions"}],"predecessor-version":[{"id":2780,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1550\/revisions\/2780"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1550"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}