{"id":4953,"date":"2023-07-06T00:02:04","date_gmt":"2023-07-06T00:02:04","guid":{"rendered":"https:\/\/statorials.org\/id\/persimpangan-vba\/"},"modified":"2023-07-06T00:02:04","modified_gmt":"2023-07-06T00:02:04","slug":"persimpangan-vba","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/persimpangan-vba\/","title":{"rendered":"Cara menggunakan intersect di vba (dengan contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan metode <b>Intersect<\/b> di VBA untuk mengembalikan rentang yang mewakili perpotongan dua rentang tertentu.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Berikut adalah cara umum untuk menggunakan metode ini dalam praktik:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">Function<\/span> FindIntersect(range1, range2)\n    FindIntersect = Application.Intersect(range1, range2)\n<span style=\"color: #0000ff;\">End Function\n<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Anda kemudian dapat memasukkan fungsi ini langsung ke dalam spreadsheet Excel, menentukan dua rentang, dan fungsi tersebut akan mengembalikan setiap nilai dalam rentang yang mewakili perpotongan kedua rentang tersebut.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut memperlihatkan cara menggunakan fungsi ini dalam praktik dengan kumpulan data berikut di Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-38212 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/refa1.png\" alt=\"\" width=\"486\" height=\"405\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 1: Temukan perpotongan dua rentang (dengan satu sel sebagai hasilnya)<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita ingin mengembalikan nilai sel yang mewakili perpotongan antara rentang <strong>A2:C2<\/strong> dan <strong>A1:A11<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat mendefinisikan fungsi berikut di VBA:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">Function<\/span> FindIntersect(range1, range2)\n    FindIntersect = Application.Intersect(range1, range2)\n<span style=\"color: #0000ff;\">End Function<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Kita kemudian dapat mengetikkan fungsi ini langsung ke dalam sel di spreadsheet kita:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-38666 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/trouveri1.png\" alt=\"\" width=\"583\" height=\"415\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Rumusnya mengembalikan nilai <strong>Mavs<\/strong> , yang mewakili perpotongan rentang <strong>A2:C2<\/strong> dan <strong>A1:A11<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-38667 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/trouveri2.png\" alt=\"\" width=\"524\" height=\"399\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 2: Temukan perpotongan dua rentang (dengan hasil beberapa sel)<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita ingin mengembalikan seluruh rentang sel yang mewakili perpotongan antara rentang <strong>A1:C3<\/strong> dan <strong>A1:B10<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat mendefinisikan fungsi berikut di VBA:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">Function<\/span> FindIntersect(range1, range2)\n    FindIntersect = Application.Intersect(range1, range2)\n<span style=\"color: #0000ff;\">End Function<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Kita kemudian dapat mengetikkan fungsi ini langsung ke dalam sel di spreadsheet kita:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-38668 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/trouveri3.png\" alt=\"\" width=\"564\" height=\"385\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Rumusnya mengembalikan seluruh rentang nilai persegi panjang yang mewakili perpotongan rentang <strong>A1:C3<\/strong> dan <strong>A1:B10<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-38669 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/trouveri4.png\" alt=\"\" width=\"538\" height=\"362\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Anda dapat menemukan dokumentasi lengkap untuk metode VBA <b>Intersect<\/b> <a href=\"https:\/\/learn.microsoft.com\/en-us\/office\/vba\/api\/excel.application.intersect\" target=\"_blank\" rel=\"noopener\">di sini<\/a> .<\/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\/jumlah-kolom-vba\/\" target=\"_blank\" rel=\"noopener\">VBA: Cara menghitung jumlah kolom yang digunakan<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/vba-menghitung-baris-dalam-tabel\/\" target=\"_blank\" rel=\"noopener\">VBA: Cara menghitung baris dalam sebuah tabel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/vba-menghitung-jumlah-lembar\/\" target=\"_blank\" rel=\"noopener\">VBA: Cara menghitung jumlah lembar dalam buku kerja<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan metode Intersect di VBA untuk mengembalikan rentang yang mewakili perpotongan dua rentang tertentu. Berikut adalah cara umum untuk menggunakan metode ini dalam praktik: Function FindIntersect(range1, range2) FindIntersect = Application.Intersect(range1, range2) End Function Anda kemudian dapat memasukkan fungsi ini langsung ke dalam spreadsheet Excel, menentukan dua rentang, dan fungsi tersebut akan mengembalikan setiap [&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 Intersect di VBA (dengan Contoh) \u2013 Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan metode Intersect di VBA untuk menemukan persimpangan atau dua rentang, 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\/persimpangan-vba\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menggunakan Intersect di VBA (dengan Contoh) \u2013 Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan metode Intersect di VBA untuk menemukan persimpangan atau dua rentang, beserta contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/persimpangan-vba\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-06T00:02:04+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/refa1.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\/persimpangan-vba\/\",\"url\":\"https:\/\/statorials.org\/id\/persimpangan-vba\/\",\"name\":\"Cara Menggunakan Intersect di VBA (dengan Contoh) \u2013 Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-06T00:02:04+00:00\",\"dateModified\":\"2023-07-06T00:02:04+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan metode Intersect di VBA untuk menemukan persimpangan atau dua rentang, beserta contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/persimpangan-vba\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/persimpangan-vba\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/persimpangan-vba\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menggunakan intersect 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 Intersect di VBA (dengan Contoh) \u2013 Statologi","description":"Tutorial ini menjelaskan cara menggunakan metode Intersect di VBA untuk menemukan persimpangan atau dua rentang, 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\/persimpangan-vba\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menggunakan Intersect di VBA (dengan Contoh) \u2013 Statologi","og_description":"Tutorial ini menjelaskan cara menggunakan metode Intersect di VBA untuk menemukan persimpangan atau dua rentang, beserta contohnya.","og_url":"https:\/\/statorials.org\/id\/persimpangan-vba\/","og_site_name":"Statorials","article_published_time":"2023-07-06T00:02:04+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/refa1.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\/persimpangan-vba\/","url":"https:\/\/statorials.org\/id\/persimpangan-vba\/","name":"Cara Menggunakan Intersect di VBA (dengan Contoh) \u2013 Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-06T00:02:04+00:00","dateModified":"2023-07-06T00:02:04+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan metode Intersect di VBA untuk menemukan persimpangan atau dua rentang, beserta contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/persimpangan-vba\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/persimpangan-vba\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/persimpangan-vba\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menggunakan intersect 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\/4953"}],"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=4953"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4953\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4953"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4953"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4953"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}