{"id":4851,"date":"2023-07-07T06:07:58","date_gmt":"2023-07-07T06:07:58","guid":{"rendered":"https:\/\/statorials.org\/id\/vba-mengisi-sel-kosong-dengan-nilai-di-atas\/"},"modified":"2023-07-07T06:07:58","modified_gmt":"2023-07-07T06:07:58","slug":"vba-mengisi-sel-kosong-dengan-nilai-di-atas","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/vba-mengisi-sel-kosong-dengan-nilai-di-atas\/","title":{"rendered":"Vba: cara mengisi sel kosong dengan nilai di atas"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Seringkali, Anda mungkin ingin menggunakan VBA untuk mengisi sel kosong di lembar Excel dengan nilai sel tepat di atasnya.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk melakukannya, Anda dapat menggunakan sintaks dasar berikut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #0000ff;\">Sub<\/span> Fill_From_Above()\n  <span style=\"color: #0000ff;\">With<\/span> Range(\" <span style=\"color: #ff0000;\">A2:B<\/span> \" &amp; Range(\" <span style=\"color: #ff0000;\">C<\/span> \" &amp; Rows.Count).End(xlUp).Row)\n    .SpecialCells(xlBlanks).FormulaR1C1 = \" <span style=\"color: #ff0000;\">=R[-1]C<\/span> \"\n    .Value = .Value\n  <span style=\"color: #0000ff;\">End With<\/span>\n<span style=\"color: #0000ff;\">End Sub<\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Contoh khusus ini akan mengisi semua sel kosong, dari sel <strong>A2<\/strong> hingga kolom <strong>B<\/strong> hingga baris terakhir yang berisi nilai di kolom <strong>C.<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: Gunakan VBA untuk mengisi sel kosong dengan nilai di atas<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki kumpulan data berikut di Excel yang memperlihatkan poin yang dicetak dalam berbagai permainan oleh pemain bola basket yang berbeda:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37052 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/remplirb1.png\" alt=\"\" width=\"456\" height=\"399\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Misalkan kita ingin mengisi sel kosong di kolom A dan B dengan nilai sel di atasnya.<\/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;\"> <strong><span style=\"color: #0000ff;\">Sub<\/span> Fill_From_Above()\n  <span style=\"color: #0000ff;\">With<\/span> Range(\" <span style=\"color: #ff0000;\">A2:B<\/span> \" &amp; Range(\" <span style=\"color: #ff0000;\">C<\/span> \" &amp; Rows.Count).End(xlUp).Row)\n    .SpecialCells(xlBlanks).FormulaR1C1 = \" <span style=\"color: #ff0000;\">=R[-1]C<\/span> \"\n    .Value = .Value\n  <span style=\"color: #0000ff;\">End With<\/span>\n<span style=\"color: #0000ff;\">End Sub\n<\/span><\/strong><\/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-37912 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/vfill2.png\" alt=\"\" width=\"528\" height=\"423\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa semua sel kosong di kolom <strong>Tim<\/strong> dan <strong>Pemain<\/strong> telah diisi dengan nilai yang sesuai dari sel di atasnya.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Kami menggunakan <strong>xlBlanks<\/strong> untuk mengidentifikasi sel kosong dalam rentang tersebut, lalu menggunakan <strong>=R[-1]C<\/strong> untuk mengisi bagian yang kosong dengan nilai sel satu baris di atasnya.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Hasil akhirnya adalah kita bisa mengisi semua sel kosong dengan nilai sel di atasnya.<\/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-kosong\/\" target=\"_blank\" rel=\"noopener\">VBA: Cara memeriksa apakah sel kosong<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/vba-jika-tidak-kosong\/\" target=\"_blank\" rel=\"noopener\">VBA: Cara menggunakan &#8220;Jika tidak kosong&#8221;<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/vba-menghitung-sel-dengan-teks-tertentu\/\" target=\"_blank\" rel=\"noopener\">VBA: Cara menghitung sel dengan teks tertentu<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Seringkali, Anda mungkin ingin menggunakan VBA untuk mengisi sel kosong di lembar Excel dengan nilai sel tepat di atasnya. Untuk melakukannya, Anda dapat menggunakan sintaks dasar berikut: Sub Fill_From_Above() With Range(&#8221; A2:B &#8221; &amp; Range(&#8221; C &#8221; &amp; Rows.Count).End(xlUp).Row) .SpecialCells(xlBlanks).FormulaR1C1 = &#8221; =R[-1]C &#8221; .Value = .Value End With End Sub Contoh khusus ini akan [&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 mengisi sel kosong dengan nilai lebih besar \u2013 Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mengisi sel kosong dengan nilai sel di atasnya di VBA, beserta 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\/vba-mengisi-sel-kosong-dengan-nilai-di-atas\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"VBA: Cara mengisi sel kosong dengan nilai lebih besar \u2013 Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mengisi sel kosong dengan nilai sel di atasnya di VBA, beserta sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/vba-mengisi-sel-kosong-dengan-nilai-di-atas\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-07T06:07:58+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/remplirb1.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\/vba-mengisi-sel-kosong-dengan-nilai-di-atas\/\",\"url\":\"https:\/\/statorials.org\/id\/vba-mengisi-sel-kosong-dengan-nilai-di-atas\/\",\"name\":\"VBA: Cara mengisi sel kosong dengan nilai lebih besar \u2013 Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-07T06:07:58+00:00\",\"dateModified\":\"2023-07-07T06:07:58+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mengisi sel kosong dengan nilai sel di atasnya di VBA, beserta sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/vba-mengisi-sel-kosong-dengan-nilai-di-atas\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/vba-mengisi-sel-kosong-dengan-nilai-di-atas\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/vba-mengisi-sel-kosong-dengan-nilai-di-atas\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Vba: cara mengisi sel kosong dengan nilai di atas\"}]},{\"@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 mengisi sel kosong dengan nilai lebih besar \u2013 Statorials","description":"Tutorial ini menjelaskan cara mengisi sel kosong dengan nilai sel di atasnya di VBA, beserta 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\/vba-mengisi-sel-kosong-dengan-nilai-di-atas\/","og_locale":"id_ID","og_type":"article","og_title":"VBA: Cara mengisi sel kosong dengan nilai lebih besar \u2013 Statorials","og_description":"Tutorial ini menjelaskan cara mengisi sel kosong dengan nilai sel di atasnya di VBA, beserta sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/vba-mengisi-sel-kosong-dengan-nilai-di-atas\/","og_site_name":"Statorials","article_published_time":"2023-07-07T06:07:58+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/remplirb1.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\/vba-mengisi-sel-kosong-dengan-nilai-di-atas\/","url":"https:\/\/statorials.org\/id\/vba-mengisi-sel-kosong-dengan-nilai-di-atas\/","name":"VBA: Cara mengisi sel kosong dengan nilai lebih besar \u2013 Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-07T06:07:58+00:00","dateModified":"2023-07-07T06:07:58+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mengisi sel kosong dengan nilai sel di atasnya di VBA, beserta sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/vba-mengisi-sel-kosong-dengan-nilai-di-atas\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/vba-mengisi-sel-kosong-dengan-nilai-di-atas\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/vba-mengisi-sel-kosong-dengan-nilai-di-atas\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Vba: cara mengisi sel kosong dengan nilai di atas"}]},{"@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\/4851"}],"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=4851"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4851\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4851"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4851"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4851"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}