{"id":2056,"date":"2023-10-22T09:11:23","date_gmt":"2023-10-22T09:11:23","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/bernama-pantai\/"},"modified":"2023-12-06T06:13:48","modified_gmt":"2023-12-06T06:13:48","slug":"bernama-pantai","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/bernama-pantai\/","title":{"rendered":"Bagaimana cara membuat rentang bernama menggunakan vba?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-1225611277\"><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 membuat rentang bernama menggunakan VBA, Anda perlu menggunakan properti \u201cNama\u201d lebih lanjut dengan metode \u201cTambah\u201d. Dalam metode penambahan Anda memiliki argumen untuk menentukan nama apa yang ingin Anda berikan pada rentang tersebut dan menentukan alamat rentang tersebut (pastikan untuk menggunakan tanda dolar dengan alamat untuk membekukan rentang tersebut).<\/p><h2 class=\"wp-block-heading\"> Buat rentang nama menggunakan VBA<\/h2><ol type=\"1\"><li> Tentukan buku kerja tempat Anda ingin membuat rentang bernama.<\/li><li> Gunakan properti nama, lalu tambahkan metode tambahan.<\/li><li> Tentukan nama dalam argumen \u201cNama\u201d.<\/li><li> Lihat rentang menggunakan argumen \u201cReferTo\u201d. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-53866\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-creer-une-plage-de-noms-en-utilisant-vba.png\" sizes=\"auto, \" srcset=\"\" alt=\"buat rentang nama menggunakan vba\" width=\"669\" height=\"284\"><\/figure><\/div><p> Pada contoh di atas, Anda memiliki buku kerja yang aktif, kemudian menggunakan properti &#8220;Nama&#8221; dengan metode &#8220;Tambah&#8221; Anda menetapkan nama rentang, dan pada akhirnya, alamat rentang yang ingin Anda gunakan.<\/p><p> Seperti yang saya katakan sebelumnya, dalam rentang alamat Anda perlu menggunakan tanda $ untuk membekukan alamat. Anda juga bisa menggunakan <a href=\"https:\/\/exceladvisor.org\/id\/buku-catatan-ini\/\">ThisWorkbook untuk merujuk ke buku kerja tempat Anda menulis kode<\/a> atau Anda bisa menggunakan merujuk ke buku kerja lain menggunakan objek buku kerja.<\/p><h2 class=\"wp-block-heading\"> VBA untuk membuat rentang nama dari pilihan<\/h2><p> Anda juga dapat menggunakan properti pilihan untuk membuat rentang bernama dari pilihan. Perhatikan kode berikut.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">ActiveSheet.Names.Add Name:=\"myRangeName\", RefersTo:=Selection<\/code><\/pre><p> Dan pada kode berikut <a href=\"https:\/\/exceladvisor.org\/id\/kotak-pesan-vba\/\">Anda memiliki kotak pesan<\/a> yang dapat digunakan untuk memasukkan nama yang ingin Anda berikan pada rentang bernama.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub vba_named_range() Dim iName As String iName = InputBox(\"Enter Name for the Selection.\") ActiveSheet.Names.Add Name:=iName, RefersTo:=Selection End Sub<\/code><\/pre><h2 class=\"wp-block-heading\"> Ubah ukuran rentang bernama menggunakan VBA (Dynamic Named Range)<\/h2><p> Untuk mengubah ukuran rentang bernama yang sudah ada di lembar kerja, Anda harus menggunakan properti resize dan memberi tahu VBA berapa banyak baris dan kolom yang ingin Anda perluas dari rentang saat ini. Pertimbangkan kode berikut yang memperluas rentang bernama &#8220;myRange&#8221; yang awalnya memiliki sel A1 sebagai rentangnya tetapi mengubah ukurannya menjadi kolom M dan baris 11. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-53867\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-redimensionner-une-plage-nommee.png\" sizes=\"auto, \" srcset=\"\" alt=\"mengubah ukuran rentang bernama\" width=\"739\" height=\"465\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub vba_named_range() Dim iRow As Long Dim iColumn As Long iRow = ActiveSheet.Range(\"A1\").End(xlDown).Row iColumn = ActiveSheet.Range(\"A1\").End(xlToRight).Column ActiveSheet.Range(\"myRange\") _ .Resize(iRow, iColumn).Name = \"myRange\" End Sub<\/code><\/pre><p> Saya telah membaginya menjadi tiga bagian untuk memperjelasnya bagi Anda, sekarang mari kita mulai. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-53868\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-divise-en-trois-parties.png\" sizes=\"auto, \" srcset=\"\" alt=\"dibagi menjadi tiga bagian\" width=\"596\" height=\"351\"><\/figure><\/div><ul><li> Di bagian PERTAMA Anda memiliki variabel yang dideklarasikan untuk menyimpan baris dan jumlah kolom.<\/li><li> Di bagian KEDUA, Anda menggunakan metode &#8220;END&#8221; dengan rentang untuk mendapatkan baris dan kolom terakhir dan menyimpannya untuk variabel.<\/li><li> Di Bagian TIGA, Anda menggunakan properti Resize dengan rentang bernama \u201cmyRange\u201d. Dan setelah itu nomor baris dan kolom yang Anda miliki di variabelnya. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-53869\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-variables-declarees-pour-stocker-des-lignes.png\" sizes=\"auto, \" srcset=\"\" alt=\"variabel dideklarasikan untuk menyimpan baris\" width=\"656\" height=\"307\"><\/figure><\/div><p> Saat Anda menjalankan kode ini, kode ini akan mengubah ukuran rentang lama berdasarkan data yang Anda miliki dan menjadikannya rentang bernama dinamis. Kapan pun Anda perlu memperbaruinya, Anda dapat menjalankan kode dan mengubah ukuran rentang nama yang ada.<\/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><\/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-2056","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 membuat rentang bernama menggunakan VBA?<\/title>\n<meta name=\"description\" content=\"Pelajari cara menggunakan VBA untuk membuat NAMED RANGE di Excel. Rentang bernama dari pemilihan + mengubah ukuran rentang bernama.\" \/>\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\/bernama-pantai\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bagaimana cara membuat rentang bernama menggunakan VBA?\" \/>\n<meta property=\"og:description\" content=\"Pelajari cara menggunakan VBA untuk membuat NAMED RANGE di Excel. Rentang bernama dari pemilihan + mengubah ukuran rentang bernama.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/bernama-pantai\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:13:48+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-creer-une-plage-de-noms-en-utilisant-vba.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\/bernama-pantai\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/bernama-pantai\/\",\"name\":\"Bagaimana cara membuat rentang bernama menggunakan VBA?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/bernama-pantai\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/bernama-pantai\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-creer-une-plage-de-noms-en-utilisant-vba.png\",\"datePublished\":\"2023-10-22T09:11:23+00:00\",\"dateModified\":\"2023-12-06T06:13:48+00:00\",\"description\":\"Pelajari cara menggunakan VBA untuk membuat NAMED RANGE di Excel. Rentang bernama dari pemilihan + mengubah ukuran rentang bernama.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/bernama-pantai\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/bernama-pantai\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/bernama-pantai\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-creer-une-plage-de-noms-en-utilisant-vba.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-creer-une-plage-de-noms-en-utilisant-vba.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/bernama-pantai\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara membuat rentang bernama 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 membuat rentang bernama menggunakan VBA?","description":"Pelajari cara menggunakan VBA untuk membuat NAMED RANGE di Excel. Rentang bernama dari pemilihan + mengubah ukuran rentang bernama.","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\/bernama-pantai\/","og_locale":"id_ID","og_type":"article","og_title":"Bagaimana cara membuat rentang bernama menggunakan VBA?","og_description":"Pelajari cara menggunakan VBA untuk membuat NAMED RANGE di Excel. Rentang bernama dari pemilihan + mengubah ukuran rentang bernama.","og_url":"https:\/\/exceladvisor.org\/id\/bernama-pantai\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:13:48+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-creer-une-plage-de-noms-en-utilisant-vba.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\/bernama-pantai\/","url":"https:\/\/exceladvisor.org\/id\/bernama-pantai\/","name":"Bagaimana cara membuat rentang bernama menggunakan VBA?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/bernama-pantai\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/bernama-pantai\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-creer-une-plage-de-noms-en-utilisant-vba.png","datePublished":"2023-10-22T09:11:23+00:00","dateModified":"2023-12-06T06:13:48+00:00","description":"Pelajari cara menggunakan VBA untuk membuat NAMED RANGE di Excel. Rentang bernama dari pemilihan + mengubah ukuran rentang bernama.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/bernama-pantai\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/bernama-pantai\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/bernama-pantai\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-creer-une-plage-de-noms-en-utilisant-vba.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-creer-une-plage-de-noms-en-utilisant-vba.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/bernama-pantai\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara membuat rentang bernama 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\/2056","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=2056"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2056\/revisions"}],"predecessor-version":[{"id":2312,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2056\/revisions\/2312"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=2056"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}