{"id":1551,"date":"2023-11-17T09:32:12","date_gmt":"2023-11-17T09:32:12","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/rentang-variabel\/"},"modified":"2023-12-06T06:18:55","modified_gmt":"2023-12-06T06:18:55","slug":"rentang-variabel","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/rentang-variabel\/","title":{"rendered":"Bagaimana cara menggunakan sel sebagai variabel di vba?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-2127275057\"><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 menggunakan rentang atau sel tunggal sebagai variabel, Anda harus mendeklarasikan variabel tersebut terlebih dahulu dengan tipe data rentang. Setelah Anda selesai melakukannya, Anda perlu menentukan rentang dari satu sel ke variabel ini menggunakan objek rentang. Ini juga memberi Anda akses ke semua properti dan metode yang dapat Anda gunakan dengan suatu rentang.<\/p><ol type=\"1\"><li> Gunakan kata kunci \u201cRedupkan\u201d dan masukkan nama variabel.<\/li><li> Deklarasikan kata kunci sebagai <a href=\"https:\/\/exceladvisor.org\/id\/rentang-1\/\">Range<\/a> .<\/li><li> Ketikkan nama variabel.<\/li><li> Tentukan rentang yang ingin Anda tetapkan ke variabel. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-53824\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-utiliser-le-mot-cle-dim.png\" sizes=\"auto, \" srcset=\"\" alt=\"gunakan kata kunci redup\" width=\"355\" height=\"264\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Tetapkan pilihan ke variabel rentang<\/h2><p> Anda juga dapat menggunakan rentang yang dipilih untuk suatu variabel dan kemudian menggunakan variabel tersebut untuk mengakses properti dan metode. Perhatikan kode berikut.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub vba_range_variable() Dim rng As Range Set rng = Selection Selection.Clear End Sub<\/code><\/pre><p> Namun ada satu hal yang perlu Anda waspadai, yaitu ketika Anda <a href=\"https:\/\/exceladvisor.org\/id\/objek\/\">memilih objek<\/a> selain rentang, VBA akan menampilkan kesalahan. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-53825\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-selection-dun-objet-autre-que-la-plage.png\" sizes=\"auto, \" srcset=\"\" alt=\"memilih objek selain rentang\" width=\"580\" height=\"384\"><\/figure><\/div><p> Namun ini juga merupakan metode dinamis di mana Anda tidak perlu mengubah rentangnya lagi dan lagi.<\/p><h2 class=\"wp-block-heading\"> Salin rentang menggunakan variabel<\/h2><p> Setelah Anda <a href=\"https:\/\/exceladvisor.org\/id\/variabel\/\">mendeklarasikan variabel<\/a> sebagai rentang, Anda juga dapat menyalin rentang tersebut menggunakan nama variabel tersebut. Misalkan Anda telah mendeklarasikan rentang A1:A10 sebagai variabel rng (contoh di atas), Anda dapat menyalinnya menggunakan kode berikut. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-53826\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-copier-la-plage-en-utilisant-la-variable.png\" sizes=\"auto, \" srcset=\"\" alt=\"salin susunan menggunakan variabel\" width=\"567\" height=\"309\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub vba_range_variable() Dim rng As Range Set rng = Range(\"A1:A10\") rng.Copy End Sub<\/code><\/pre><h2 class=\"wp-block-heading\"> Menggunakan variabel rentang dalam suatu fungsi<\/h2><p> Anda juga bisa menggunakan variabel rentang untuk merujuk ke rentang dalam suatu fungsi saat menulis makro. Perhatikan kode berikut. <\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub vba_range_variable() Dim iNames As Variant Dim rng As Range Set rng = Range(\"A1:A10\") Range(\"B1\") = WorksheetFunction.Max(rng) End Sub<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-53827\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-plage-dutilisation-disponible-dans-une-fonction.png\" sizes=\"auto, \" srcset=\"\" alt=\"menggunakan variabel rentang dalam suatu fungsi\" width=\"546\" height=\"312\"><\/figure><\/div><p> Dibutuhkan nilai dalam rentang A1:A10 dan karena Anda perlu menggunakan variabel \u201crng\u201d, kami menggunakan variabel dalam nilai maksimum untuk mengeluarkannya.<\/p><p> <strong>Terkait:<\/strong> <a href=\"https:\/\/exceladvisor.org\/id\/fungsi-spreadsheet\/\">Cara Menggunakan Fungsi Lembar Kerja di VBA<\/a><\/p><h2 class=\"wp-block-heading\"> Hitung jumlah baris dan kolom<\/h2><p> Seperti yang saya katakan sebelumnya, setelah Anda menentukan variabel sebagai rentang, Anda juga akan mendapatkan semua properti dan metode akses. Bayangkan jika Anda ingin menghitung baris dan kolom. Berikut kode yang bisa digunakan. <\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub vba_range_variable() Dim rng As Range Set rng = Range(\"A1:A10\") MsgBox \"This range has \" &amp; _ rng.Rows.Count &amp; \" row(s) and \" &amp; _ rng.Columns.Count &amp; \" coulmn(s).\" End Sub<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-53828\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-compter-le-nombre-de-lignes-et-de-colonnes.png\" sizes=\"auto, \" srcset=\"\" alt=\"menghitung jumlah baris dan kolom\" width=\"464\" height=\"388\"><\/figure><\/div><p> Saat Anda menjalankan kode ini, ini <a href=\"https:\/\/exceladvisor.org\/id\/kotak-pesan-vba\/\">akan menampilkan pesan<\/a> dengan jumlah baris dan kolom dalam rentang yang Anda tentukan dalam variabel.<\/p><h2 class=\"wp-block-heading\"> Definisi lembar kerja dengan jangkauan<\/h2><p> Dalam semua contoh di atas, kami menggunakan rentang tanpa menyebutkan lembar kerja, jadi ketika Anda menjalankan kode ini, VBA akan selalu mengacu pada rentang di lembar aktif. Namun jika Anda ingin merujuk ke lembar kerja tertentu, Anda perlu menggunakan <a href=\"https:\/\/exceladvisor.org\/id\/lembar-kerja-1\/\">objek lembar kerja<\/a> dengan rentangnya.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Dim rng As Range Set rng = Worksheets(\"Sheet1\").Range(\"A1:A10\")<\/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\/variabel-global\/\">Deklarasikan variabel global (publik) di VBA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/opsi-eksplisit-2\/\">Pernyataan opsi eksplisit di VBA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/kotak-pesan-variabel\/\">Variabel dalam kotak pesan<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/konstanta\/\">VBA konstan<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/lemah\/\">Redupkan instruksi VBA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/variabel\/\">Variabel VBA (deklarasikan, tipe data, dan cakupan)<\/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-1551","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 sel sebagai variabel di VBA?<\/title>\n<meta name=\"description\" content=\"Untuk menggunakan rentang atau sel sebagai variabel, Anda harus mendeklarasikan variabel tersebut sebagai rentang terlebih dahulu. Sekali kamu\" \/>\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-variabel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bagaimana cara menggunakan sel sebagai variabel di VBA?\" \/>\n<meta property=\"og:description\" content=\"Untuk menggunakan rentang atau sel sebagai variabel, Anda harus mendeklarasikan variabel tersebut sebagai rentang terlebih dahulu. Sekali kamu\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/rentang-variabel\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:18:55+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-utiliser-le-mot-cle-dim.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\/rentang-variabel\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/rentang-variabel\/\",\"name\":\"Bagaimana cara menggunakan sel sebagai variabel di VBA?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/rentang-variabel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/rentang-variabel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-utiliser-le-mot-cle-dim.png\",\"datePublished\":\"2023-11-17T09:32:12+00:00\",\"dateModified\":\"2023-12-06T06:18:55+00:00\",\"description\":\"Untuk menggunakan rentang atau sel sebagai variabel, Anda harus mendeklarasikan variabel tersebut sebagai rentang terlebih dahulu. Sekali kamu\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/rentang-variabel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/rentang-variabel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/rentang-variabel\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-utiliser-le-mot-cle-dim.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-utiliser-le-mot-cle-dim.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/rentang-variabel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara menggunakan sel sebagai variabel 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 sel sebagai variabel di VBA?","description":"Untuk menggunakan rentang atau sel sebagai variabel, Anda harus mendeklarasikan variabel tersebut sebagai rentang terlebih dahulu. Sekali kamu","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-variabel\/","og_locale":"id_ID","og_type":"article","og_title":"Bagaimana cara menggunakan sel sebagai variabel di VBA?","og_description":"Untuk menggunakan rentang atau sel sebagai variabel, Anda harus mendeklarasikan variabel tersebut sebagai rentang terlebih dahulu. Sekali kamu","og_url":"https:\/\/exceladvisor.org\/id\/rentang-variabel\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:18:55+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-utiliser-le-mot-cle-dim.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\/rentang-variabel\/","url":"https:\/\/exceladvisor.org\/id\/rentang-variabel\/","name":"Bagaimana cara menggunakan sel sebagai variabel di VBA?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/rentang-variabel\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/rentang-variabel\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-utiliser-le-mot-cle-dim.png","datePublished":"2023-11-17T09:32:12+00:00","dateModified":"2023-12-06T06:18:55+00:00","description":"Untuk menggunakan rentang atau sel sebagai variabel, Anda harus mendeklarasikan variabel tersebut sebagai rentang terlebih dahulu. Sekali kamu","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/rentang-variabel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/rentang-variabel\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/rentang-variabel\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-utiliser-le-mot-cle-dim.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-utiliser-le-mot-cle-dim.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/rentang-variabel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara menggunakan sel sebagai variabel 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\/1551","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=1551"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1551\/revisions"}],"predecessor-version":[{"id":2787,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1551\/revisions\/2787"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1551"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}