{"id":5015,"date":"2023-07-05T02:45:23","date_gmt":"2023-07-05T02:45:23","guid":{"rendered":"https:\/\/statorials.org\/id\/referensi-vba-bernama-rentang\/"},"modified":"2023-07-05T02:45:23","modified_gmt":"2023-07-05T02:45:23","slug":"referensi-vba-bernama-rentang","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/referensi-vba-bernama-rentang\/","title":{"rendered":"Vba: cara mereferensikan rentang bernama"},"content":{"rendered":"

<\/p>\n

\n

Untuk mereferensikan rentang bernama di VBA, cukup gunakan fungsi Range()<\/strong> dengan rentang bernama diapit tanda kutip ganda.<\/span><\/p>\n

Misalnya, Anda bisa membuat makro berikut untuk menetapkan nilai “Tim” ke setiap nilai dalam rentang bernama yang disebut Teams<\/strong> :<\/span><\/p>\n

 SubModifyNamedRange<\/span> ()\n \nRange(\"teams\").Value = \"Team\"\n\nEnd Sub\n<\/span><\/span><\/strong><\/span><\/pre>\n
 Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya.<\/span><\/p>\n
 Contoh: Cara Referensi Rentang Bernama Menggunakan VBA<\/strong><\/span><\/h2>\n
 Katakanlah kita memiliki rentang bernama Teams<\/strong> yang mewakili rentang A2:A11<\/strong> pada lembar tertentu di Excel:<\/span><\/p>\n
 \"\"<\/span><\/p>\n
 Kita bisa membuat makro berikut untuk menetapkan nilai teks “Tim” ke setiap sel dalam rentang bernama ini:<\/span><\/span><\/p>\n
 SubModifyNamedRange<\/span> ()\n\nRange(\"teams\").Value = \"Team\"\n\nEnd Sub<\/span><\/strong><\/span><\/pre>\n
 Saat kami menjalankan makro ini, kami menerima keluaran berikut:<\/span> <\/p>\n
\"\"<\/p>\n
 Perhatikan bahwa setiap sel dalam rentang nama kita sekarang berisi “Tim” dan bukan nama tim asli.<\/span><\/p>\n
 Kita juga bisa menggunakan makro berikut untuk menetapkan nilai numerik 100 ke setiap sel dalam tim yang diberi nama rentang:<\/span><\/p>\n
 SubModifyNamedRange<\/span> ()\n\nRange(\"teams\").Value = 100\n\nEnd Sub<\/span><\/strong><\/span><\/pre>\n
 Saat kami menjalankan makro ini, kami menerima keluaran berikut:<\/span> <\/p>\n
\"\"<\/p>\n
 Atau kita bahkan bisa menggunakan makro berikut untuk membuat setiap sel dalam tim<\/strong> rentang bernama memiliki font tebal dan warna latar belakang hijau:<\/span><\/p>\n
 SubModifyNamedRange<\/span> ()\n\nRange(\"teams\").Interior.Color = vbGreen\nRange(\"teams\").Font.Bold = True\n\nEnd Sub<\/span><\/span><\/strong><\/span><\/pre>\n
 Saat kami menjalankan makro ini, kami menerima keluaran berikut:<\/span> <\/p>\n
\"\"<\/p>\n
 Setiap sel tim<\/strong> pantai yang diberi nama kini memiliki font tebal dan warna latar belakang hijau.<\/span><\/p>\n
 Sumber daya tambahan<\/strong><\/span><\/h2>\n
 Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di VBA:<\/span><\/p>\n
 VBA: cara menghapus rentang bernama<\/a>
 VBA: Cara menyalin garis yang terlihat ke lembar lain<\/a>
 VBA: menyalin baris ke lembar lain berdasarkan kriteria<\/a>
<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"
Untuk mereferensikan rentang bernama di VBA, cukup gunakan fungsi Range() dengan rentang bernama diapit tanda kutip ganda. Misalnya, Anda bisa membuat makro berikut untuk menetapkan nilai “Tim” ke setiap nilai dalam rentang bernama yang disebut Teams : SubModifyNamedRange () Range(“teams”).Value = “Team” End Sub Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya. Contoh: Cara […]<\/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":"\nVBA: Cara mereferensikan rentang bernama \u2013 Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mereferensikan rentang bernama di VBA, dengan sebuah contoh.\" \/>\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\/referensi-vba-bernama-rentang\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"VBA: Cara mereferensikan rentang bernama \u2013 Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mereferensikan rentang bernama di VBA, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/referensi-vba-bernama-rentang\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-05T02:45:23+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/nom-de-reference1.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\/referensi-vba-bernama-rentang\/\",\"url\":\"https:\/\/statorials.org\/id\/referensi-vba-bernama-rentang\/\",\"name\":\"VBA: Cara mereferensikan rentang bernama \u2013 Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-05T02:45:23+00:00\",\"dateModified\":\"2023-07-05T02:45:23+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mereferensikan rentang bernama di VBA, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/referensi-vba-bernama-rentang\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/referensi-vba-bernama-rentang\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/referensi-vba-bernama-rentang\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Vba: cara mereferensikan rentang bernama\"}]},{\"@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":"VBA: Cara mereferensikan rentang bernama \u2013 Statologi","description":"Tutorial ini menjelaskan cara mereferensikan rentang bernama di VBA, dengan sebuah contoh.","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\/referensi-vba-bernama-rentang\/","og_locale":"id_ID","og_type":"article","og_title":"VBA: Cara mereferensikan rentang bernama \u2013 Statologi","og_description":"Tutorial ini menjelaskan cara mereferensikan rentang bernama di VBA, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/referensi-vba-bernama-rentang\/","og_site_name":"Statorials","article_published_time":"2023-07-05T02:45:23+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/nom-de-reference1.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\/referensi-vba-bernama-rentang\/","url":"https:\/\/statorials.org\/id\/referensi-vba-bernama-rentang\/","name":"VBA: Cara mereferensikan rentang bernama \u2013 Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-05T02:45:23+00:00","dateModified":"2023-07-05T02:45:23+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mereferensikan rentang bernama di VBA, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/referensi-vba-bernama-rentang\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/referensi-vba-bernama-rentang\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/referensi-vba-bernama-rentang\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Vba: cara mereferensikan rentang bernama"}]},{"@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\/5015"}],"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=5015"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/5015\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=5015"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=5015"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=5015"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}