{"id":4857,"date":"2023-07-07T04:30:13","date_gmt":"2023-07-07T04:30:13","guid":{"rendered":"https:\/\/statorials.org\/id\/rentang-salinan-vba-ke-lembar-lain\/"},"modified":"2023-07-07T04:30:13","modified_gmt":"2023-07-07T04:30:13","slug":"rentang-salinan-vba-ke-lembar-lain","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/rentang-salinan-vba-ke-lembar-lain\/","title":{"rendered":"Vba: cara menyalin rentang ke lembar lain"},"content":{"rendered":"

<\/p>\n

\n

Anda dapat menggunakan sintaks berikut di VBA untuk menyalin rentang sel ke lembar lain:<\/span><\/p>\n

 Sub<\/span> CopyRangeToSheet()\n\nWorksheets(\" Sheet1<\/span> \").Range(\" A1:C11<\/span> \").Copy\nWorksheets(\" Sheet2<\/span> \").Range(\" A1<\/span> \").PasteSpecial\n\nApplication.CutCopyMode = False\n\nEnd Sub\n<\/span><\/strong><\/span><\/pre>\n
 Makro khusus ini akan menyalin sel dalam rentang A1:C11<\/strong> dari Sheet1<\/strong> dan menempelkannya ke dalam rentang yang dimulai pada sel A1<\/strong> dari Sheet2<\/strong> .<\/span><\/p>\n
 Catatan<\/strong> : Baris Application.CutCopyMode = False<\/strong> menetapkan bahwa mode potong dan salin harus dinonaktifkan setelah makro dijalankan.<\/span><\/p>\n
 Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya.<\/span><\/p>\n
 Contoh: Salin Rentang ke Lembar Lain Menggunakan VBA<\/strong><\/span><\/h2>\n
 Katakanlah kita memiliki kumpulan data berikut dalam lembar bernama Sheet1<\/strong> di Excel yang berisi informasi tentang berbagai pemain bola basket:<\/span> <\/p>\n
\"\"<\/p>\n
 Anggaplah kita juga mempunyai sheet lain bernama Sheet2<\/strong> yang saat ini kosong:<\/span> <\/p>\n
\"\"<\/p>\n
 Katakanlah kita ingin menyalin semua nilai dalam rentang A1:C11<\/strong> dari Sheet1<\/strong> dan menempelkannya mulai dari sel A1<\/strong> dari Sheet2<\/strong> .<\/span><\/p>\n
 Kita dapat membuat makro berikut untuk melakukan ini:<\/span><\/p>\n
 Sub<\/span> CopyRangeToSheet()\n\nWorksheets(\" Sheet1<\/span> \").Range(\" A1:C11<\/span> \").Copy\nWorksheets(\" Sheet2<\/span> \").Range(\" A1<\/span> \").PasteSpecial\n\nApplication.CutCopyMode = False\n\nEnd Sub<\/span><\/strong><\/span><\/pre>\n
 Saat kami menjalankan makro ini, kami menerima output berikut di Sheet2<\/strong> :<\/span> <\/p>\n
\"\"<\/p>\n
 Perhatikan bahwa semua nilai dalam rentang A1:C11<\/strong> dari Sheet1<\/strong> disalin ke Sheet2<\/strong> dari sel A1<\/strong> .<\/span><\/p>\n
 Secara default, nilai ditempelkan dengan format sumbernya.<\/span><\/p>\n
 Misalnya, nilai baris header dicetak tebal.<\/span><\/p>\n
 Jika Anda hanya ingin menempelkan nilai tanpa format sumber, Anda dapat menentukan Tempel:=xlPasteValues<\/strong> sebagai berikut:<\/span><\/p>\n
 Sub<\/span> CopyRangeToSheet()\n\nWorksheets(\" Sheet1<\/span> \").Range(\" A1:C11<\/span> \").Copy\nWorksheets(\" Sheet2<\/span> \").Range(\" A1<\/span> \").PasteSpecial Paste=xlPasteValues\n\nApplication.CutCopyMode = False\n\nEnd Sub<\/span><\/strong><\/span><\/pre>\n
 Saat kami menjalankan makro ini, kami menerima output berikut di Sheet2<\/strong> :<\/span> <\/p>\n
\"\"<\/p>\n
 Perhatikan bahwa hanya nilai (tanpa pemformatan) dari rentang A1:C11<\/strong> dari Sheet1<\/strong> yang disalin ke Sheet2<\/strong> .<\/span><\/p>\n
 Catatan<\/strong> : Anda dapat menemukan dokumentasi lengkap untuk metode VBA PasteSpecial<\/strong> di sini<\/a> .<\/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 menempelkan nilai saja tanpa memformat<\/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":"
Anda dapat menggunakan sintaks berikut di VBA untuk menyalin rentang sel ke lembar lain: Sub CopyRangeToSheet() Worksheets(” Sheet1 “).Range(” A1:C11 “).Copy Worksheets(” Sheet2 “).Range(” A1 “).PasteSpecial Application.CutCopyMode = False End Sub Makro khusus ini akan menyalin sel dalam rentang A1:C11 dari Sheet1 dan menempelkannya ke dalam rentang yang dimulai pada sel A1 dari Sheet2 . […]<\/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 menyalin rentang ke lembar lain - Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menyalin rentang ke lembar lain di Excel menggunakan 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\/rentang-salinan-vba-ke-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 menyalin rentang ke lembar lain - Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menyalin rentang ke lembar lain di Excel menggunakan VBA, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/rentang-salinan-vba-ke-lembar-lain\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-07T04:30:13+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/copieur1.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\/rentang-salinan-vba-ke-lembar-lain\/\",\"url\":\"https:\/\/statorials.org\/id\/rentang-salinan-vba-ke-lembar-lain\/\",\"name\":\"VBA: Cara menyalin rentang ke lembar lain - Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-07T04:30:13+00:00\",\"dateModified\":\"2023-07-07T04:30:13+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menyalin rentang ke lembar lain di Excel menggunakan VBA, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/rentang-salinan-vba-ke-lembar-lain\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/rentang-salinan-vba-ke-lembar-lain\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/rentang-salinan-vba-ke-lembar-lain\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Vba: cara menyalin rentang ke 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 menyalin rentang ke lembar lain - Statorial","description":"Tutorial ini menjelaskan cara menyalin rentang ke lembar lain di Excel menggunakan 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\/rentang-salinan-vba-ke-lembar-lain\/","og_locale":"id_ID","og_type":"article","og_title":"VBA: Cara menyalin rentang ke lembar lain - Statorial","og_description":"Tutorial ini menjelaskan cara menyalin rentang ke lembar lain di Excel menggunakan VBA, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/rentang-salinan-vba-ke-lembar-lain\/","og_site_name":"Statorials","article_published_time":"2023-07-07T04:30:13+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/copieur1.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\/rentang-salinan-vba-ke-lembar-lain\/","url":"https:\/\/statorials.org\/id\/rentang-salinan-vba-ke-lembar-lain\/","name":"VBA: Cara menyalin rentang ke lembar lain - Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-07T04:30:13+00:00","dateModified":"2023-07-07T04:30:13+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menyalin rentang ke lembar lain di Excel menggunakan VBA, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/rentang-salinan-vba-ke-lembar-lain\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/rentang-salinan-vba-ke-lembar-lain\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/rentang-salinan-vba-ke-lembar-lain\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Vba: cara menyalin rentang ke 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\/4857"}],"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=4857"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4857\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4857"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4857"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4857"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}