{"id":4460,"date":"2023-07-10T22:45:36","date_gmt":"2023-07-10T22:45:36","guid":{"rendered":"https:\/\/statorials.org\/id\/vba-mengatur-nilai-sel-di-lembar-lain\/"},"modified":"2023-07-10T22:45:36","modified_gmt":"2023-07-10T22:45:36","slug":"vba-mengatur-nilai-sel-di-lembar-lain","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/vba-mengatur-nilai-sel-di-lembar-lain\/","title":{"rendered":"Vba: cara mengatur nilai sel di lembar lain"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan metode berikut di VBA untuk mengatur nilai sel di lembar lain:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Metode 1: Tetapkan nilai sel di lembar lain<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">Sub<\/span> SetCellAnotherSheet()\n    \n    <span style=\"color: #0000ff;\">Sun<\/span> wks1 <span style=\"color: #0000ff;\">As<\/span> Worksheet, wks2 <span style=\"color: #0000ff;\">As<\/span> Worksheet\n    \n    <span style=\"color: #008000;\">'specify sheets to use<\/span>\n    <span style=\"color: #0000ff;\">Set<\/span> wks1 = Sheets(\" <span style=\"color: #ff0000;\">Sheet1<\/span> \")\n    <span style=\"color: #0000ff;\">Set<\/span> wks2 = Sheets(\" <span style=\"color: #ff0000;\">Sheet2<\/span> \")\n    \n    <span style=\"color: #008000;\">'set cell value in Sheet2 equal to cell value in Sheet1<\/span>\n    wks2.Range(\" <span style=\"color: #ff0000;\">A2<\/span> \").Value = wks1.Range(\" <span style=\"color: #ff0000;\">A2<\/span> \").Value\n    \n<span style=\"color: #0000ff;\">End Sub\n<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Makro khusus ini akan mengatur nilai sel <strong>A2<\/strong> di <strong>Sheet2<\/strong> sama dengan nilai sel <strong>A2<\/strong> di <strong>Sheet1<\/strong> .<\/span><\/p>\n<p> <b style=\"color: #000000;\">Metode 2: Tetapkan<\/b> <span style=\"color: #000000;\"><b>Beberapa<\/b><\/span> <b style=\"color: #000000;\">Nilai Sel di Lembar Lain<\/b><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">Sub<\/span> SetCellAnotherSheet()\n    \n    <span style=\"color: #0000ff;\">Sun<\/span> wks1 <span style=\"color: #0000ff;\">As<\/span> Worksheet, wks2 <span style=\"color: #0000ff;\">As<\/span> Worksheet\n    \n    <span style=\"color: #008000;\">'specify sheets to use<\/span>\n    <span style=\"color: #0000ff;\">Set<\/span> wks1 = Sheets(\" <span style=\"color: #ff0000;\">Sheet1<\/span> \")\n    <span style=\"color: #0000ff;\">Set<\/span> wks2 = Sheets(\" <span style=\"color: #ff0000;\">Sheet2<\/span> \")\n    \n    <span style=\"color: #008000;\">'set cell range in Sheet2 equal to cell range in Sheet1<\/span>\n    wks2.Range(\" <span style=\"color: #ff0000;\">A2:A11<\/span> \").Value = wks1.Range(\" <span style=\"color: #ff0000;\">A2:A11<\/span> \").Value\n    \n<span style=\"color: #0000ff;\">End Sub<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Makro khusus ini akan menetapkan nilai setiap sel dalam rentang <strong>A2:A11<\/strong> di <strong>Sheet2<\/strong> agar sama dengan nilai setiap sel dalam rentang <strong>A2:A11<\/strong> di <strong>Sheet1<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan masing-masing metode dalam praktik.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 1: Tetapkan nilai sel di lembar lain<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita mempunyai lembar berikut yang disebut <strong>Lembar1<\/strong> yang berisi nama-nama tim bola basket yang berbeda:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-34916 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/setcell1.png\" alt=\"\" width=\"444\" height=\"364\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Dan misalkan kita mempunyai <strong>Sheet2<\/strong> yang hanya berisi satu baris header:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-34917 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/setcell2.png\" alt=\"\" width=\"468\" height=\"384\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat membuat makro berikut untuk mengatur nilai sel <strong>A2<\/strong> pada <strong>Sheet2<\/strong> agar sama dengan nilai sel <strong>A2<\/strong> pada <strong>Sheet1<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">Sub<\/span> SetCellAnotherSheet()\n    \n    <span style=\"color: #0000ff;\">Sun<\/span> wks1 <span style=\"color: #0000ff;\">As<\/span> Worksheet, wks2 <span style=\"color: #0000ff;\">As<\/span> Worksheet\n    \n    <span style=\"color: #008000;\">'specify sheets to use<\/span>\n    <span style=\"color: #0000ff;\">Set<\/span> wks1 = Sheets(\" <span style=\"color: #ff0000;\">Sheet1<\/span> \")\n    <span style=\"color: #0000ff;\">Set<\/span> wks2 = Sheets(\" <span style=\"color: #ff0000;\">Sheet2<\/span> \")\n    \n    <span style=\"color: #008000;\">'set cell value in Sheet2 equal to cell value in Sheet1<\/span>\n    wks2.Range(\" <span style=\"color: #ff0000;\">A2<\/span> \").Value = wks1.Range(\" <span style=\"color: #ff0000;\">A2<\/span> \").Value\n    \n<span style=\"color: #0000ff;\">End Sub<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Saat kita menjalankan makro ini, kita dapat melihat bahwa nilai sel <strong>A2<\/strong> dari <strong>Sheet2<\/strong> sekarang disetel ke &#8220;Mavs&#8221;, yang cocok dengan nilai sel <strong>A2<\/strong> dari <strong>Sheet1<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-34918 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/setcell3.png\" alt=\"\" width=\"465\" height=\"377\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 2: Tetapkan Beberapa Nilai Sel di Lembar Lain<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita ingin mengatur nilai setiap sel dalam rentang <strong>A2:A11<\/strong> dari <strong>Sheet2<\/strong> agar sama dengan setiap sel dalam rentang <strong>A2:A11<\/strong> dari <strong>Sheet1<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat membuat makro berikut untuk melakukan ini:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">Sub<\/span> SetCellAnotherSheet()\n    \n    <span style=\"color: #0000ff;\">Sun<\/span> wks1 <span style=\"color: #0000ff;\">As<\/span> Worksheet, wks2 <span style=\"color: #0000ff;\">As<\/span> Worksheet\n    \n    <span style=\"color: #008000;\">'specify sheets to use<\/span>\n    <span style=\"color: #0000ff;\">Set<\/span> wks1 = Sheets(\" <span style=\"color: #ff0000;\">Sheet1<\/span> \")\n    <span style=\"color: #0000ff;\">Set<\/span> wks2 = Sheets(\" <span style=\"color: #ff0000;\">Sheet2<\/span> \")\n    \n    <span style=\"color: #008000;\">'set cell range in Sheet2 equal to cell range in Sheet1<\/span>\n    wks2.Range(\" <span style=\"color: #ff0000;\">A2:A11<\/span> \").Value = wks1.Range(\" <span style=\"color: #ff0000;\">A2:A11<\/span> \").Value\n    \n<span style=\"color: #0000ff;\">End Sub<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Saat kita menjalankan makro ini, kita dapat melihat bahwa nilai dalam rentang <strong>A2:A11<\/strong> dari <strong>Sheet2<\/strong> sekarang disetel menjadi sama dengan nilai dalam rentang <strong>A2:A11<\/strong> dari <strong>Sheet1<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-34919 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/setcell4.png\" alt=\"\" width=\"493\" height=\"398\" srcset=\"\" sizes=\"\"><\/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> <a href=\"https:\/\/statorials.org\/id\/vba-menemukan-baris-terakhir\/\" target=\"_blank\" rel=\"noopener\">VBA: Cara menemukan baris yang terakhir digunakan<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/vba-menghitung-baris-dalam-jangkauan\/\" target=\"_blank\" rel=\"noopener\">VBA: Cara menghitung jumlah baris dalam jangkauan<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/jumlah-kolom-vba\/\" target=\"_blank\" rel=\"noopener\">VBA: Cara menghitung jumlah kolom yang digunakan<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan metode berikut di VBA untuk mengatur nilai sel di lembar lain: Metode 1: Tetapkan nilai sel di lembar lain Sub SetCellAnotherSheet() Sun wks1 As Worksheet, wks2 As Worksheet &#8216;specify sheets to use Set wks1 = Sheets(&#8221; Sheet1 &#8220;) Set wks2 = Sheets(&#8221; Sheet2 &#8220;) &#8216;set cell value in Sheet2 equal to cell [&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>VBA: Cara mengatur nilai sel di lembar lain - Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mengatur nilai sel di sheet lain menggunakan VBA, 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\/vba-mengatur-nilai-sel-di-lembar-lain\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"VBA: Cara mengatur nilai sel di lembar lain - Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mengatur nilai sel di sheet lain menggunakan VBA, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/vba-mengatur-nilai-sel-di-lembar-lain\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-10T22:45:36+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/setcell1.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\/vba-mengatur-nilai-sel-di-lembar-lain\/\",\"url\":\"https:\/\/statorials.org\/id\/vba-mengatur-nilai-sel-di-lembar-lain\/\",\"name\":\"VBA: Cara mengatur nilai sel di lembar lain - Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-10T22:45:36+00:00\",\"dateModified\":\"2023-07-10T22:45:36+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mengatur nilai sel di sheet lain menggunakan VBA, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/vba-mengatur-nilai-sel-di-lembar-lain\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/vba-mengatur-nilai-sel-di-lembar-lain\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/vba-mengatur-nilai-sel-di-lembar-lain\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Vba: cara mengatur nilai sel di lembar lain\"}]},{\"@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 mengatur nilai sel di lembar lain - Statorial","description":"Tutorial ini menjelaskan cara mengatur nilai sel di sheet lain menggunakan VBA, 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\/vba-mengatur-nilai-sel-di-lembar-lain\/","og_locale":"id_ID","og_type":"article","og_title":"VBA: Cara mengatur nilai sel di lembar lain - Statorial","og_description":"Tutorial ini menjelaskan cara mengatur nilai sel di sheet lain menggunakan VBA, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/vba-mengatur-nilai-sel-di-lembar-lain\/","og_site_name":"Statorials","article_published_time":"2023-07-10T22:45:36+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/setcell1.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\/vba-mengatur-nilai-sel-di-lembar-lain\/","url":"https:\/\/statorials.org\/id\/vba-mengatur-nilai-sel-di-lembar-lain\/","name":"VBA: Cara mengatur nilai sel di lembar lain - Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-10T22:45:36+00:00","dateModified":"2023-07-10T22:45:36+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mengatur nilai sel di sheet lain menggunakan VBA, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/vba-mengatur-nilai-sel-di-lembar-lain\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/vba-mengatur-nilai-sel-di-lembar-lain\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/vba-mengatur-nilai-sel-di-lembar-lain\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Vba: cara mengatur nilai sel di lembar lain"}]},{"@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\/4460"}],"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=4460"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4460\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4460"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4460"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4460"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}