{"id":4479,"date":"2023-07-10T18:49:54","date_gmt":"2023-07-10T18:49:54","guid":{"rendered":"https:\/\/statorials.org\/id\/vba-temukan-dan-ganti\/"},"modified":"2023-07-10T18:49:54","modified_gmt":"2023-07-10T18:49:54","slug":"vba-temukan-dan-ganti","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/vba-temukan-dan-ganti\/","title":{"rendered":"Cara menggunakan temukan dan ganti di vba (dengan contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><span style=\"color: #000000;\">Anda dapat menggunakan metode berikut untuk menemukan dan mengganti string tertentu dalam suatu rentang menggunakan VBA:<\/span><\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Metode 1: Temukan dan ganti string (tidak peka huruf besar-kecil)<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">Sub<\/span> FindReplace()\nRange(\" <span style=\"color: #ff0000;\">A1:B10<\/span> \").Replace What:=\" <span style=\"color: #ff0000;\">Mavs<\/span> \", Replacement:=\" <span style=\"color: #ff0000;\">Mavericks<\/span> \"\n<span style=\"color: #0000ff;\">End Sub<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Makro khusus ini akan menggantikan setiap kemunculan &#8220;Mavs&#8221; dengan &#8220;Mavericks&#8221; dalam rentang <strong>A1:B10<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Metode 2: Temukan dan Ganti String (Peka Huruf Besar-kecil)<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">Sub<\/span> FindReplace()\nRange(\" <span style=\"color: #ff0000;\">A1:B10<\/span> \").Replace What:=\" <span style=\"color: #ff0000;\">Mavs<\/span> \", Replacement:=\" <span style=\"color: #ff0000;\">Mavericks<\/span> \", MatchCase:= <span style=\"color: #0000ff;\">True<\/span>\n<span style=\"color: #0000ff;\">End Sub<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Makro khusus ini akan menggantikan setiap kemunculan &#8220;Mavs&#8221; dengan &#8220;Mavericks&#8221; dalam rentang <strong>A1:B10<\/strong> <em>hanya jika kasusnya cocok<\/em> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, string &#8220;mavs&#8221; tidak akan diganti karena tidak sama persis dengan huruf &#8220;Mavs&#8221;.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut memperlihatkan cara menggunakan metode ini dalam praktik dengan kumpulan data berikut di Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-35048 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/frep1.png\" alt=\"\" width=\"454\" height=\"415\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 1: Temukan dan Ganti String Menggunakan VBA (Tidak Peka Huruf Besar-kecil)<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Katakanlah kita ingin mengganti setiap kemunculan &#8220;Mavs&#8221; dengan &#8220;Mavericks&#8221; dalam rentang <strong>A1:B10<\/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> FindReplace()\nRange(\" <span style=\"color: #ff0000;\">A1:B10<\/span> \").Replace What:=\" <span style=\"color: #ff0000;\">Mavs<\/span> \", Replacement:=\" <span style=\"color: #ff0000;\">Mavericks<\/span> \"\n<span style=\"color: #0000ff;\">End Sub<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Saat kami menjalankan makro ini, kami menerima hasil berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-35049 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/frep2.png\" alt=\"\" width=\"461\" height=\"405\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa setiap kemunculan &#8220;Mavs&#8221; telah diganti dengan string &#8220;Mavericks&#8221; di kolom tim.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 2: Temukan dan Ganti String Menggunakan VBA (Peka Huruf Besar-kecil)<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita ingin mengganti setiap kemunculan &#8220;Mavs&#8221; dengan &#8220;Mavericks&#8221; dalam rentang <strong>A1:B10<\/strong> <em>hanya jika kasusnya cocok<\/em> .<\/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> FindReplace()\nRange(\" <span style=\"color: #ff0000;\">A1:B10<\/span> \").Replace What:=\" <span style=\"color: #ff0000;\">Mavs<\/span> \", Replacement:=\" <span style=\"color: #ff0000;\">Mavericks<\/span> \", MatchCase:= <span style=\"color: #0000ff;\">True<\/span>\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-35050 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/frep3.png\" alt=\"\" width=\"480\" height=\"429\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa penggantian ini <strong>peka huruf besar-kecil<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Artinya setiap kemunculan &#8220;Mavs&#8221; diganti tetapi setiap kemunculan &#8220;mavs&#8221; dibiarkan saja.<\/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 menggunakan VBA:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><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><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>Anda dapat menggunakan metode berikut untuk menemukan dan mengganti string tertentu dalam suatu rentang menggunakan VBA: Metode 1: Temukan dan ganti string (tidak peka huruf besar-kecil) Sub FindReplace() Range(&#8221; A1:B10 &#8220;).Replace What:=&#8221; Mavs &#8220;, Replacement:=&#8221; Mavericks &#8221; End Sub Makro khusus ini akan menggantikan setiap kemunculan &#8220;Mavs&#8221; dengan &#8220;Mavericks&#8221; dalam rentang A1:B10 . Metode 2: [&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 Temukan dan Ganti di VBA (dengan Contoh) - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mencari dan mengganti string di 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-temukan-dan-ganti\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menggunakan Temukan dan Ganti di VBA (dengan Contoh) - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mencari dan mengganti string di VBA, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/vba-temukan-dan-ganti\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-10T18:49:54+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/frep1.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-temukan-dan-ganti\/\",\"url\":\"https:\/\/statorials.org\/id\/vba-temukan-dan-ganti\/\",\"name\":\"Cara Menggunakan Temukan dan Ganti di VBA (dengan Contoh) - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-10T18:49:54+00:00\",\"dateModified\":\"2023-07-10T18:49:54+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mencari dan mengganti string di VBA, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/vba-temukan-dan-ganti\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/vba-temukan-dan-ganti\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/vba-temukan-dan-ganti\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menggunakan temukan dan ganti 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 Temukan dan Ganti di VBA (dengan Contoh) - Statologi","description":"Tutorial ini menjelaskan cara mencari dan mengganti string di 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-temukan-dan-ganti\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menggunakan Temukan dan Ganti di VBA (dengan Contoh) - Statologi","og_description":"Tutorial ini menjelaskan cara mencari dan mengganti string di VBA, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/vba-temukan-dan-ganti\/","og_site_name":"Statorials","article_published_time":"2023-07-10T18:49:54+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/frep1.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-temukan-dan-ganti\/","url":"https:\/\/statorials.org\/id\/vba-temukan-dan-ganti\/","name":"Cara Menggunakan Temukan dan Ganti di VBA (dengan Contoh) - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-10T18:49:54+00:00","dateModified":"2023-07-10T18:49:54+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mencari dan mengganti string di VBA, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/vba-temukan-dan-ganti\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/vba-temukan-dan-ganti\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/vba-temukan-dan-ganti\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menggunakan temukan dan ganti 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\/4479"}],"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=4479"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4479\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4479"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4479"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4479"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}