{"id":4461,"date":"2023-07-10T22:25:01","date_gmt":"2023-07-10T22:25:01","guid":{"rendered":"https:\/\/statorials.org\/id\/vba-mendapatkan-nilai-sel-dari-lembar-lain\/"},"modified":"2023-07-10T22:25:01","modified_gmt":"2023-07-10T22:25:01","slug":"vba-mendapatkan-nilai-sel-dari-lembar-lain","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/vba-mendapatkan-nilai-sel-dari-lembar-lain\/","title":{"rendered":"Vba: cara mendapatkan nilai sel dari sheet lain"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan metode berikut di VBA untuk mendapatkan nilai sel di lembar lain:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Metode 1: Dapatkan nilai sel dari 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> GetCellAnotherSheet()\nActiveCell.Value = Worksheets(\" <span style=\"color: #ff0000;\">Sheet2<\/span> \").Range(\" <span style=\"color: #ff0000;\">A2<\/span> \") \n<span style=\"color: #0000ff;\">End Sub\n<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Makro khusus ini akan mendapatkan nilai dari sel <strong>A2<\/strong> di <strong>Sheet2<\/strong> dan mengembalikannya ke sel yang sedang aktif.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Metode 2: Dapatkan hasil operasi nilai sel dari lembar lain<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Anda juga dapat melakukan operasi pada sel di lembar lain dan mengembalikan hasil operasi di sel yang sedang aktif.<\/span><\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, Anda bisa menggunakan sintaks berikut untuk menambahkan nilai dalam rentang <strong>B2:B10<\/strong> di <strong>Sheet2<\/strong> dan mengembalikan jumlahnya di sel yang sedang aktif:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">Sub<\/span> GetCellAnotherSheet()\nActiveCell.Value = WorksheetFunction.Sum(Worksheets(\" <span style=\"color: #ff0000;\">Sheet2<\/span> \").Range(\" <span style=\"color: #ff0000;\">B2:B10<\/span> \"))\n<span style=\"color: #0000ff;\">End Sub<\/span><\/strong><\/span><\/pre>\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: Dapatkan nilai sel dari sheet lain<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita mempunyai sheet berikut yang disebut <strong>Sheet2<\/strong> yang berisi informasi tentang berbagai pemain bola basket:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-34924 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/gc1.png\" alt=\"\" width=\"512\" height=\"453\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Asumsikan sel <strong>A2<\/strong> pada <strong>Sheet1<\/strong> saat ini dipilih sebagai sel aktif.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita bisa membuat makro berikut untuk mendapatkan nilai di sel <strong>A2<\/strong> <strong>Sheet2<\/strong> dan mengembalikannya ke sel yang sedang aktif:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">Sub<\/span> GetCellAnotherSheet()\nActiveCell.Value = Worksheets(\" <span style=\"color: #ff0000;\">Sheet2<\/span> \").Range(\" <span style=\"color: #ff0000;\">A2<\/span> \") \n<span style=\"color: #0000ff;\">End Sub<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Ketika kita menjalankan makro ini, kita dapat melihat bahwa nilai sel <strong>A2<\/strong> dari <strong>Sheet1<\/strong> sekarang disetel ke &#8220;Mavs&#8221;, yang cocok dengan nilai sel <strong>A2<\/strong> dari <strong>Sheet2<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-34925 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/gc2.png\" alt=\"\" width=\"493\" height=\"428\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 2: Dapatkan hasil operasi nilai sel dari lembar lain<\/strong><\/span><\/h2>\n<p> Mari kita asumsikan lagi bahwa kita mempunyai <span style=\"color: #000000;\">sheet berikut yang disebut <strong>Sheet2<\/strong> yang berisi informasi tentang berbagai pemain bola basket:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-34924 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/gc1.png\" alt=\"\" width=\"487\" height=\"430\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Kita bisa menggunakan makro berikut untuk menjumlahkan nilai di kolom titik <strong>Sheet2<\/strong> dan mengembalikan hasilnya ke sel yang sedang aktif, yang kebetulan adalah sel <strong>A2<\/strong> dari <strong>Sheet1<\/strong> :<\/span><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">Sub<\/span> GetCellAnotherSheet()\nActiveCell.Value = WorksheetFunction.Sum(Worksheets(\" <span style=\"color: #ff0000;\">Sheet2<\/span> \").Range(\" <span style=\"color: #ff0000;\">A2<\/span> \"))\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 jumlah nilai dalam rentang <strong>A2:A10<\/strong> dari <strong>Sheet2<\/strong> sekarang ditampilkan di sel <strong>A2<\/strong> dari <strong>Sheet1<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-34926 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/gc3.png\" alt=\"\" width=\"504\" height=\"418\" 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> <span style=\"color: #000000;\"><a href=\"https:\/\/statorials.org\/id\/vba-mengatur-nilai-sel-di-lembar-lain\/\" target=\"_blank\" rel=\"noopener\">VBA: Cara mengatur nilai sel di lembar lain<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/vba-pilih-rentang-dari-sel-aktif\/\" target=\"_blank\" rel=\"noopener\">VBA: Cara memilih rentang di sel aktif<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/vba-menghapus-baris-berdasarkan-nilai-sel\/\" target=\"_blank\" rel=\"noopener\">VBA: Cara menghapus baris berdasarkan nilai sel<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan metode berikut di VBA untuk mendapatkan nilai sel di lembar lain: Metode 1: Dapatkan nilai sel dari lembar lain Sub GetCellAnotherSheet() ActiveCell.Value = Worksheets(&#8221; Sheet2 &#8220;).Range(&#8221; A2 &#8220;) End Sub Makro khusus ini akan mendapatkan nilai dari sel A2 di Sheet2 dan mengembalikannya ke sel yang sedang aktif. Metode 2: Dapatkan hasil [&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 mendapatkan nilai sel dari lembar lain - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mendapatkan nilai sel dari sheet lain di Excel menggunakan VBA, beserta contohnya.\" \/>\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-mendapatkan-nilai-sel-dari-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 mendapatkan nilai sel dari lembar lain - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mendapatkan nilai sel dari sheet lain di Excel menggunakan VBA, beserta contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/vba-mendapatkan-nilai-sel-dari-lembar-lain\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-10T22:25:01+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/gc1.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-mendapatkan-nilai-sel-dari-lembar-lain\/\",\"url\":\"https:\/\/statorials.org\/id\/vba-mendapatkan-nilai-sel-dari-lembar-lain\/\",\"name\":\"VBA: Cara mendapatkan nilai sel dari lembar lain - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-10T22:25:01+00:00\",\"dateModified\":\"2023-07-10T22:25:01+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mendapatkan nilai sel dari sheet lain di Excel menggunakan VBA, beserta contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/vba-mendapatkan-nilai-sel-dari-lembar-lain\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/vba-mendapatkan-nilai-sel-dari-lembar-lain\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/vba-mendapatkan-nilai-sel-dari-lembar-lain\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Vba: cara mendapatkan nilai sel dari sheet 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 mendapatkan nilai sel dari lembar lain - Statologi","description":"Tutorial ini menjelaskan cara mendapatkan nilai sel dari sheet lain di Excel menggunakan VBA, beserta contohnya.","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-mendapatkan-nilai-sel-dari-lembar-lain\/","og_locale":"id_ID","og_type":"article","og_title":"VBA: Cara mendapatkan nilai sel dari lembar lain - Statologi","og_description":"Tutorial ini menjelaskan cara mendapatkan nilai sel dari sheet lain di Excel menggunakan VBA, beserta contohnya.","og_url":"https:\/\/statorials.org\/id\/vba-mendapatkan-nilai-sel-dari-lembar-lain\/","og_site_name":"Statorials","article_published_time":"2023-07-10T22:25:01+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/gc1.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-mendapatkan-nilai-sel-dari-lembar-lain\/","url":"https:\/\/statorials.org\/id\/vba-mendapatkan-nilai-sel-dari-lembar-lain\/","name":"VBA: Cara mendapatkan nilai sel dari lembar lain - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-10T22:25:01+00:00","dateModified":"2023-07-10T22:25:01+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mendapatkan nilai sel dari sheet lain di Excel menggunakan VBA, beserta contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/vba-mendapatkan-nilai-sel-dari-lembar-lain\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/vba-mendapatkan-nilai-sel-dari-lembar-lain\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/vba-mendapatkan-nilai-sel-dari-lembar-lain\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Vba: cara mendapatkan nilai sel dari sheet 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\/4461"}],"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=4461"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4461\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4461"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4461"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4461"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}