{"id":4898,"date":"2023-07-06T16:46:32","date_gmt":"2023-07-06T16:46:32","guid":{"rendered":"https:\/\/statorials.org\/id\/bentuk-vba1c1\/"},"modified":"2023-07-06T16:46:32","modified_gmt":"2023-07-06T16:46:32","slug":"bentuk-vba1c1","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/bentuk-vba1c1\/","title":{"rendered":"Cara menggunakan formular1c1 di vba (dengan contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan properti <strong>FormulaR1C1<\/strong> di VBA untuk membuat referensi absolut atau referensi relatif ke sel tertentu pada lembar.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Ada dua cara umum untuk menggunakan properti ini:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Metode 1: Gunakan rumus R1C1 untuk membuat referensi absolut<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">Sub<\/span> MultipyCell()\n\nRange(\" <span style=\"color: #ff0000;\">C5<\/span> \").FormulaR1C1 = \" <span style=\"color: #ff0000;\">=R1C1*20<\/span> \"\n\n<span style=\"color: #0000ff;\">End Sub\n<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Saat Anda menjalankan makro khusus ini, sel <strong>C5<\/strong> akan menampilkan hasil sel di <strong>baris 1<\/strong> dan <strong>kolom 1<\/strong> dikalikan 20.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Metode 2: Gunakan rumus R1C1 untuk membuat referensi relatif<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">Sub<\/span> MultipyCell()\n\nRange(\" <span style=\"color: #ff0000;\">C5<\/span> \").FormulaR1C1 = \" <span style=\"color: #ff0000;\">=R[-4]C[-2]*20<\/span> \"\n\n<span style=\"color: #0000ff;\">End Sub\n<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Saat Anda menjalankan makro khusus ini, sel <strong>C5<\/strong> akan menampilkan hasil sel <strong>4 baris di atas<\/strong> dan <strong>2 kolom di kirinya<\/strong> dikalikan 20.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut memperlihatkan cara menggunakan setiap metode dalam praktik dengan lembar Excel yang berisi nilai <b>10<\/b> di sel <strong>A1<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-38252 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/r1.png\" alt=\"\" width=\"488\" height=\"366\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 1: Gunakan rumus R1C1 untuk membuat referensi absolut<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kita bisa membuat makro berikut untuk mengalikan nilai sel di <strong>baris 1<\/strong> dan <strong>kolom 1<\/strong> dengan 20 dan menampilkan hasilnya di sel <strong>C5<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">Sub<\/span> MultipyCell()\n\nRange(\" <span style=\"color: #ff0000;\">C5<\/span> \").FormulaR1C1 = \" <span style=\"color: #ff0000;\">=R1C1*20<\/span> \"\n\n<span style=\"color: #0000ff;\">End Sub<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Saat kami menjalankan makro ini, kami menerima keluaran berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-38254 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/r2.png\" alt=\"\" width=\"486\" height=\"385\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat melihat bahwa Excel menggunakan rumus <strong>=$A$1*20<\/strong> untuk menghitung hasil di sel <strong>C5<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Karena kami menggunakan <strong>R1C1<\/strong> dalam rumus kami di VBA, kami membuat referensi absolut ke sel di baris pertama dan kolom pertama, yaitu sel <strong>A1<\/strong> .<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 2: Gunakan rumus R1C1 untuk membuat referensi relatif<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kita bisa membuat makro berikut untuk mengalikan nilai sel yang berada <strong>4 baris di atas<\/strong> dan <strong>2 kolom di sebelah kiri<\/strong> sel <strong>C5<\/strong> dengan 20 dan menampilkan hasilnya di sel <strong>C5<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">Sub<\/span> MultipyCell()\n\nRange(\" <span style=\"color: #ff0000;\">C5<\/span> \").FormulaR1C1 = \" <span style=\"color: #ff0000;\">=R[-4]C[-2]*20<\/span> \"\n\n<span style=\"color: #0000ff;\">End Sub\n<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Saat kami menjalankan makro ini, kami menerima keluaran berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-38255 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/r3.png\" alt=\"\" width=\"455\" height=\"377\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat melihat bahwa Excel menggunakan rumus <strong>=A1*20<\/strong> untuk menghitung hasil di sel <strong>C5<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Karena kami menggunakan tanda kurung dengan <strong>R[-4]C[-2]<\/strong> dalam rumus kami di VBA, kami membuat referensi relatif ke sel yang terletak 4 baris di atas dan 2 kolom di sebelah kiri sel <strong>C5<\/strong> , yaitu sel <strong>A1<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Anda dapat menemukan dokumentasi lengkap untuk properti VBA <b>FormulaR1C1<\/b> <a href=\"https:\/\/learn.microsoft.com\/en-us\/office\/vba\/api\/excel.range.formular1c1\" target=\"_blank\" rel=\"noopener\">di sini<\/a> .<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di VBA:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><a href=\"https:\/\/statorials.org\/id\/vba-jika-sel-berisi\/\" target=\"_blank\" rel=\"noopener\">VBA: rumus sederhana untuk \u201cJika sel berisi\u201d<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/vba-menghitung-kemunculan-karakter-dalam-string\/\" target=\"_blank\" rel=\"noopener\">VBA: Cara menghitung kemunculan karakter dalam sebuah string<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/vba-berisi-string\/\" target=\"_blank\" rel=\"noopener\">VBA: cara memeriksa apakah suatu string berisi string lain<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan properti FormulaR1C1 di VBA untuk membuat referensi absolut atau referensi relatif ke sel tertentu pada lembar. Ada dua cara umum untuk menggunakan properti ini: Metode 1: Gunakan rumus R1C1 untuk membuat referensi absolut Sub MultipyCell() Range(&#8221; C5 &#8220;).FormulaR1C1 = &#8221; =R1C1*20 &#8221; End Sub Saat Anda menjalankan makro khusus ini, sel C5 [&hellip;]<\/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":"<!-- This site is optimized with the Yoast SEO plugin v21.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Cara Menggunakan FormulaR1C1 di VBA (dengan Contoh) \u2013 Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan FormulaR1C1 di VBA untuk membuat referensi sel, dengan beberapa 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\/bentuk-vba1c1\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menggunakan FormulaR1C1 di VBA (dengan Contoh) \u2013 Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan FormulaR1C1 di VBA untuk membuat referensi sel, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/bentuk-vba1c1\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-06T16:46:32+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/r1.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=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/bentuk-vba1c1\/\",\"url\":\"https:\/\/statorials.org\/id\/bentuk-vba1c1\/\",\"name\":\"Cara Menggunakan FormulaR1C1 di VBA (dengan Contoh) \u2013 Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-06T16:46:32+00:00\",\"dateModified\":\"2023-07-06T16:46:32+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan FormulaR1C1 di VBA untuk membuat referensi sel, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/bentuk-vba1c1\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/bentuk-vba1c1\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/bentuk-vba1c1\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menggunakan formular1c1 di vba (dengan contoh)\"}]},{\"@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":"Cara Menggunakan FormulaR1C1 di VBA (dengan Contoh) \u2013 Statorial","description":"Tutorial ini menjelaskan cara menggunakan FormulaR1C1 di VBA untuk membuat referensi sel, dengan beberapa 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\/bentuk-vba1c1\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menggunakan FormulaR1C1 di VBA (dengan Contoh) \u2013 Statorial","og_description":"Tutorial ini menjelaskan cara menggunakan FormulaR1C1 di VBA untuk membuat referensi sel, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/bentuk-vba1c1\/","og_site_name":"Statorials","article_published_time":"2023-07-06T16:46:32+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/r1.png"}],"author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/bentuk-vba1c1\/","url":"https:\/\/statorials.org\/id\/bentuk-vba1c1\/","name":"Cara Menggunakan FormulaR1C1 di VBA (dengan Contoh) \u2013 Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-06T16:46:32+00:00","dateModified":"2023-07-06T16:46:32+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan FormulaR1C1 di VBA untuk membuat referensi sel, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/bentuk-vba1c1\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/bentuk-vba1c1\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/bentuk-vba1c1\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menggunakan formular1c1 di vba (dengan contoh)"}]},{"@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\/4898"}],"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=4898"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4898\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4898"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4898"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4898"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}