{"id":2147,"date":"2023-09-28T22:43:00","date_gmt":"2023-09-28T22:43:00","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/melewati-rentang-tersebut\/"},"modified":"2023-12-06T06:16:03","modified_gmt":"2023-12-06T06:16:03","slug":"melewati-rentang-tersebut","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/melewati-rentang-tersebut\/","title":{"rendered":"Bagaimana cara menavigasi rentang menggunakan vba?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-3170770582\"><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>Untuk mengulang suatu rentang di VBA, Anda perlu menggunakan opsi \u201cUntuk Setiap Loop\u201d. Dengan menggunakan loop ini, Anda dapat menulis kode di mana Anda memberitahu VBA untuk menelusuri setiap sel dalam rentang, kolom, atau baris dan melakukan aktivitas tertentu.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\"><strong>Sub<\/strong> vba_loop_range() <strong>Dim<\/strong> iCell <strong>As<\/strong> Range <strong>For<\/strong> <strong>Each<\/strong> iCell <strong>In<\/strong> Range(\"A1:A10\").Cells   iCell.Value = \"Yes\" <strong>Next<\/strong> iCell <strong>End<\/strong> <strong>Sub<\/strong><\/code><\/pre><p> Berikut langkah-langkah berjalan di pantai:<\/p><ol><li> Pertama, deklarasikan variabel yang akan digunakan sebagai sel rentang yang akan diulang. <br><img loading=\"lazy\" decoding=\"async\" title=\"1-loop-through-range\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-boucle-a-travers-la-gamme.png\" sizes=\"auto, \" srcset=\"\" alt=\"loop-through-range\" width=\"281\" height=\"277\"><\/li><li> Setelah itu, mulai perulangan \u201cUntuk Setiap\u201d dan gunakan variabel \u201ciCell\u201d untuk mewakili setiap sel dalam rentang selama perulangan. <br><img loading=\"lazy\" decoding=\"async\" title=\"2-penggunaan-icell-variabel\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-utiliser-la-variable-icecell.png\" sizes=\"auto, \" srcset=\"\" alt=\"use-icell-variable\" width=\"404\" height=\"289\"><\/li><li> Selanjutnya, Anda perlu menulis sebaris kode untuk melakukan aktivitas pada setiap sel tempat kita mengulang rentangnya. <br><img loading=\"lazy\" decoding=\"async\" title=\"3-tulis-sebaris kode\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-ecrire-une-ligne-de-code.png\" sizes=\"auto, \" srcset=\"\" alt=\"write-a-line-of-code\" width=\"420\" height=\"356\"><\/li><li> Pada akhirnya, akhiri kode untuk satu perulangan. <br><img loading=\"lazy\" decoding=\"async\" title=\"4-akhiri-kode-untuk-a-loop\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-terminer-le-code-pour-une-boucle.png\" sizes=\"auto, \" srcset=\"\" alt=\"end-the-code-for-a-loop\" width=\"418\" height=\"363\"><\/li><\/ol><h2 class=\"wp-block-heading\"> Ulangi seluruh kolom dan satu baris menggunakan VBA<\/h2><p> Dengan cara yang sama, Anda dapat mengulangi setiap sel dalam satu baris menggunakan kode berikut yang identik dengan kode yang kita gunakan pada contoh sebelumnya, satu-satunya perbedaan adalah rentang yang kita tentukan. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-61538\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-boucles-sur-toute-la-colonne-et-la-ligne.png\" sizes=\"auto, \" srcset=\"\" alt=\"loop-through-keseluruhan-kolom-dan-baris\" width=\"406\" height=\"344\"><\/figure><\/div><p> Catatan: Sebelum Anda menelusuri seluruh kolom atau baris, Anda harus memahami bahwa perulangan mungkin memerlukan waktu dan Excel Anda mungkin terhenti selama beberapa menit.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\"><strong>Sub<\/strong> vba_loop_range() <strong>Dim<\/strong> iCell <strong>As<\/strong> Range <strong>For<\/strong> <strong>Each<\/strong> iCell <strong>In<\/strong> Range(\"A:A\").Cells   iCell.Value = \"Yes\" <strong>Next<\/strong> iCell <strong>End<\/strong> <strong>Sub<\/strong><\/code><\/pre><p> Dan dengan cara yang sama, Anda dapat menggunakan garis penuh sebagai rentang yang harus dilalui.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\"><strong>Sub<\/strong> vba_loop_range() <strong>Dim<\/strong> iCell <strong>As<\/strong> Range <strong>For<\/strong> <strong>Each<\/strong> iCell <strong>In<\/strong> Range(\"1:1\").Cells   iCell.Value = \"Yes\" <strong>Next<\/strong> iCell <strong>End<\/strong> <strong>Sub<\/strong><\/code><\/pre><h2 class=\"wp-block-heading\"> Ulangi rentang dinamis<\/h2><p> Dan jika Anda ingin mengulangi rentang sel dinamis, lihat kode berikut. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-61539\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-boucles-a-travers-la-plage-dynamique.png\" sizes=\"auto, \" srcset=\"\" alt=\"loop melalui rentang dinamis\" width=\"751\" height=\"469\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\"><strong>Sub<\/strong> vba_dynamic_loop_range() <strong>Dim<\/strong> iCell <strong>As<\/strong> Range <strong>Dim<\/strong> iRange1 <strong>As<\/strong> String <strong>Dim<\/strong> iRange2 <strong>As<\/strong> String <strong>Dim<\/strong> rangeName <strong>As<\/strong> String iRange1 = ActiveCell.Address iRange2 = ActiveCell.Offset(5, 5).Address rangeName = iRange1 &amp; \":\" &amp; iRange2 <strong>For<\/strong> <strong>Each<\/strong> iCell <strong>In<\/strong> Range(rangeName).Cells   iCell = \"Yes\" <strong>Next<\/strong> iCell <strong>End<\/strong> <strong>Sub<\/strong><\/code><\/pre><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\/loop\/\">Loop VBA (Pemula hingga Mahir)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/pilih-kasusnya\/\">VBA Pilih Kasus<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/untuk-melakukan-sementara\/\">Excel VBA Do While Loop dan (Do Loop While) \u2013 Panduan<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/daun-lingkaran\/\">Ulangi semua lembar menggunakan VBA di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/untuk-lingkaran\/\">VBA FOR LOOP (Untuk Berikutnya, Untuk Masing-masing)<\/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-2147","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 menavigasi rentang menggunakan VBA? (Tutorial 2023)<\/title>\n<meta name=\"description\" content=\"Untuk mengulang suatu rentang di VBA, Anda perlu menggunakan opsi &quot;Untuk Setiap Loop&quot;. Dengan menggunakan loop ini Anda dapat menulis kode di mana...\" \/>\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\/melewati-rentang-tersebut\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bagaimana cara menavigasi rentang menggunakan VBA? (Tutorial 2023)\" \/>\n<meta property=\"og:description\" content=\"Untuk mengulang suatu rentang di VBA, Anda perlu menggunakan opsi &quot;Untuk Setiap Loop&quot;. Dengan menggunakan loop ini Anda dapat menulis kode di mana...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/melewati-rentang-tersebut\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:16:03+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-boucle-a-travers-la-gamme.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=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/id\/melewati-rentang-tersebut\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/melewati-rentang-tersebut\/\",\"name\":\"Bagaimana cara menavigasi rentang menggunakan VBA? (Tutorial 2023)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/melewati-rentang-tersebut\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/melewati-rentang-tersebut\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-boucle-a-travers-la-gamme.png\",\"datePublished\":\"2023-09-28T22:43:00+00:00\",\"dateModified\":\"2023-12-06T06:16:03+00:00\",\"description\":\"Untuk mengulang suatu rentang di VBA, Anda perlu menggunakan opsi &quot;Untuk Setiap Loop&quot;. Dengan menggunakan loop ini Anda dapat menulis kode di mana...\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/melewati-rentang-tersebut\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/melewati-rentang-tersebut\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/melewati-rentang-tersebut\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-boucle-a-travers-la-gamme.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-boucle-a-travers-la-gamme.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/melewati-rentang-tersebut\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara menavigasi rentang menggunakan 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 menavigasi rentang menggunakan VBA? (Tutorial 2023)","description":"Untuk mengulang suatu rentang di VBA, Anda perlu menggunakan opsi &quot;Untuk Setiap Loop&quot;. Dengan menggunakan loop ini Anda dapat menulis kode di mana...","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\/melewati-rentang-tersebut\/","og_locale":"id_ID","og_type":"article","og_title":"Bagaimana cara menavigasi rentang menggunakan VBA? (Tutorial 2023)","og_description":"Untuk mengulang suatu rentang di VBA, Anda perlu menggunakan opsi &quot;Untuk Setiap Loop&quot;. Dengan menggunakan loop ini Anda dapat menulis kode di mana...","og_url":"https:\/\/exceladvisor.org\/id\/melewati-rentang-tersebut\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:16:03+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-boucle-a-travers-la-gamme.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/id\/melewati-rentang-tersebut\/","url":"https:\/\/exceladvisor.org\/id\/melewati-rentang-tersebut\/","name":"Bagaimana cara menavigasi rentang menggunakan VBA? (Tutorial 2023)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/melewati-rentang-tersebut\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/melewati-rentang-tersebut\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-boucle-a-travers-la-gamme.png","datePublished":"2023-09-28T22:43:00+00:00","dateModified":"2023-12-06T06:16:03+00:00","description":"Untuk mengulang suatu rentang di VBA, Anda perlu menggunakan opsi &quot;Untuk Setiap Loop&quot;. Dengan menggunakan loop ini Anda dapat menulis kode di mana...","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/melewati-rentang-tersebut\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/melewati-rentang-tersebut\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/melewati-rentang-tersebut\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-boucle-a-travers-la-gamme.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-boucle-a-travers-la-gamme.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/melewati-rentang-tersebut\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara menavigasi rentang menggunakan 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\/2147","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=2147"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2147\/revisions"}],"predecessor-version":[{"id":2486,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2147\/revisions\/2486"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=2147"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}