{"id":2212,"date":"2023-09-01T07:29:00","date_gmt":"2023-09-01T07:29:00","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/sel-khusus\/"},"modified":"2023-12-06T06:18:37","modified_gmt":"2023-12-06T06:18:37","slug":"sel-khusus","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/sel-khusus\/","title":{"rendered":"Bagaimana cara menggunakan metode sel khusus?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-3325849352\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p>Di VBA, metode sel khusus memungkinkan Anda memilih sel atau rentang sel dengan tipe tertentu dan tipe nilai tertentu. Katakanlah Anda ingin mengetahui bahwa dalam rentang A1:A10, sel mana yang memiliki rumus dan diberi nomor sebagai nilai? Nah, Anda bisa mencapai hasil ini dengan metode SpecialCells.<\/p><h2 class=\"wp-block-heading\"> Gunakan metode sel khusus di VBA <\/h2><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-54756\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-utiliser-la-methode-des-cellules-speciales-dans-vba.png\" sizes=\"auto, \" srcset=\"\" alt=\"gunakan metode sel khusus di vba\" width=\"614\" height=\"275\"><\/figure><\/div><p> Disini kita menulis kode untuk mengetahui alamat sel yang terakhir digunakan di range A1:A10. Perhatikan bahwa dalam metode sel khusus ada dua argumen, salah satunya wajib dan yang lainnya opsional.<\/p><ol><li> Pertama, deklarasikan variabel sebagai rentang untuk menyimpan alamat sel yang dikembalikan oleh kode. <br><img loading=\"lazy\" decoding=\"async\" title=\"2-deklarasikan-variabel-sebagai-rentang\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-declarer-une-variable-comme-plage.png\" sizes=\"auto, \" srcset=\"\" alt=\"declare a variable as range\" width=\"328\" height=\"284\"><\/li><li> Setelah itu, lihat rentangnya dan gunakan metode \u201cSpecialCells\u201d di mana Anda perlu menentukan argumen \u201cType\u201d dengan \u201cxlCellTypeLastCell\u201d.<\/li><li> Selanjutnya, atur baris kode sel khusus ini ke variabel yang Anda tentukan di langkah pertama. <br><img loading=\"lazy\" decoding=\"async\" title=\"3-gunakan-metode-sel-khusus\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-utiliser-la-methode-des-cellules-speciales.png\" sizes=\"auto, \" srcset=\"\" alt=\"use the specialcells method\" width=\"462\" height=\"209\"><\/li><li> Dari sini Anda perlu menggunakan kotak pesan VBA untuk mendapatkan alamat pengembalian sel dengan metode sel khusus.<\/li><li> Pada akhirnya, gunakan properti alamat dengan variabel untuk mendapatkan alamat sel tipe terakhir. <br><img loading=\"lazy\" decoding=\"async\" title=\"4-Vba-kotak-pesan-untuk-mendapatkan-alamat\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Boite-de-message-4-vba-pour-obtenir-ladresse.png\" sizes=\"auto, \" srcset=\"\" alt=\"Vba message box to get the address\" width=\"449\" height=\"203\"><\/li><\/ol><p> Berikut kode lengkapnya.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Dim myRng As Range Set myRng = Range(\"A1:A10\").SpecialCells(xlCellTypeLastCell) MsgBox myRng.Address<\/code><\/pre><p> Sekarang ketika Anda menjalankan kode ini, ia akan menampilkan kotak pesan dengan alamat sel yang terakhir digunakan (diketik). Jadi di sini dalam kasus saya, saya menggunakan sel A10 dan hal yang sama saya terima di kotak pesan.<\/p><h2 class=\"wp-block-heading\"> Pilih sel dengan catatan<\/h2><p> Di Excel, \u201cKomentar\u201d lama sekarang menjadi \u201cCatatan\u201d. Saat Anda menulis kode untuk memilih komentar, itu akan memilih catatan yang Anda miliki dalam rentang yang ditentukan. Perhatikan kode berikut. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-54760\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-cellules-selectionnees-avec-des-notes.png\" sizes=\"auto, \" srcset=\"\" alt=\"pilih sel dengan catatan\" width=\"590\" height=\"296\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Dim myRng As Range Set myRng = _ Range(\"A1:A10\").SpecialCells(xlCellTypeComments) myRng.Select<\/code><\/pre><h2 class=\"wp-block-heading\"> Gunakan kedua argumen tersebut<\/h2><p> Seperti yang saya katakan sebelumnya, Anda memiliki dua argumen untuk metode SpecialCells. Sekarang mari kita lihat bagaimana Anda bisa menggunakan dua argumen untuk memilih sel yang memiliki rumus, dan nilai yang dikembalikan oleh rumus tersebut adalah nilai logika.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Dim myRng As Range Set myRng = Range(\"A1:A11\").SpecialCells(xlCellTypeFormulas, xlLogical) myRng.Select<\/code><\/pre><p> Sekarang ketika saya menjalankan kode di atas, ia memilih sel dari rentang A1 hingga A11 di mana saya memiliki rumus dan nilai logika. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-54761\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-en-utilisant-les-deux-arguments.png\" sizes=\"auto, \" srcset=\"\" alt=\"menggunakan kedua argumen tersebut\" width=\"588\" height=\"243\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Pilih sel dengan format bersyarat<\/h2><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Range(\"A1:A11\").SpecialCells(xlCellTypeSameFormatConditions) Range(\"A1:A11\").SpecialCells(xlCellTypeAllFormatConditions)<\/code><\/pre><h2 class=\"wp-block-heading\"> Pilih sel yang terlihat<\/h2><p> Dan Anda juga dapat memilih yang terlihat menggunakan konstanta \u201cxlCellTypeVisible\u201d. Perhatikan kode berikut. <\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Dim myRng As Range Set myRng = Range(\"A1:A11\").SpecialCells(xlCellTypeVisible) myRng.Select<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-54762\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-cellules-selectionnees-avec-mise-en-forme-conditionnelle.png\" sizes=\"auto, \" srcset=\"\" alt=\"pilih sel dengan format bersyarat\" width=\"607\" height=\"266\"><\/figure><\/div><p> Atau Anda juga bisa menggunakan &#8220;12&#8221; sebagai nilai argumen.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Dim myRng As Range Set myRng = Range(\"A1:A11\").SpecialCells(12) myRng.Select<\/code><\/pre><h2 class=\"wp-block-heading\"> Sel dengan validasi data<\/h2><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Range(\"A1:A11\").SpecialCells(xlCellTypeAllValidation) Range(\"A1:A11\").SpecialCells(xlCellTypeSameValidation)<\/code><\/pre><div class=\"gb-container gb-container-4db6181c gb-container-mt\"> <a class=\"gb-button gb-button-c5897111 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/id\/vba\/\">Apa itu VBA<\/a><h2 class=\"gb-headline gb-headline-665e5f6b gb-headline-text gb-headline-mt-heading\"> Tutorial terkait <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a20baf7c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-65ddf67e\"><div class=\"gb-container gb-container-65ddf67e\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/id\/jumlah-baris\/\">Hitung baris menggunakan VBA di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/huruf-karakter\/\">Font Excel VBA (warna, ukuran, jenis dan tebal)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/sembunyikan-tampilkan-baris-kolom\/\">Excel VBA Sembunyikan dan tampilkan kolom atau baris<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/rentang-1\/\">Rentang VBA Excel \u2013 Bekerja dengan Rentang dan Sel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/perbatasan\/\">Terapkan batas ke sel menggunakan VBA di Excel<\/a> <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-50067b57\"><div class=\"gb-container gb-container-50067b57\"><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-2212","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Bagaimana cara menggunakan metode sel khusus melalui VBA?<\/title>\n<meta name=\"description\" content=\"Tutorial ini menunjukkan cara menggunakan metode sel khusus di VBA untuk mengakses sel dengan properti khusus.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/id\/sel-khusus\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bagaimana cara menggunakan metode sel khusus melalui VBA?\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menunjukkan cara menggunakan metode sel khusus di VBA untuk mengakses sel dengan properti khusus.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/sel-khusus\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:18:37+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-utiliser-la-methode-des-cellules-speciales-dans-vba.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/id\/sel-khusus\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/sel-khusus\/\",\"name\":\"Bagaimana cara menggunakan metode sel khusus melalui VBA?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/sel-khusus\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/sel-khusus\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-utiliser-la-methode-des-cellules-speciales-dans-vba.png\",\"datePublished\":\"2023-09-01T07:29:00+00:00\",\"dateModified\":\"2023-12-06T06:18:37+00:00\",\"description\":\"Tutorial ini menunjukkan cara menggunakan metode sel khusus di VBA untuk mengakses sel dengan properti khusus.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/sel-khusus\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/sel-khusus\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/sel-khusus\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-utiliser-la-methode-des-cellules-speciales-dans-vba.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-utiliser-la-methode-des-cellules-speciales-dans-vba.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/sel-khusus\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara menggunakan metode sel khusus?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"name\":\"Excel Advisor\",\"description\":\"Panduan utama Anda untuk mendominasi data!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/id\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"id\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Bagaimana cara menggunakan metode sel khusus melalui VBA?","description":"Tutorial ini menunjukkan cara menggunakan metode sel khusus di VBA untuk mengakses sel dengan properti khusus.","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:\/\/exceladvisor.org\/id\/sel-khusus\/","og_locale":"id_ID","og_type":"article","og_title":"Bagaimana cara menggunakan metode sel khusus melalui VBA?","og_description":"Tutorial ini menunjukkan cara menggunakan metode sel khusus di VBA untuk mengakses sel dengan properti khusus.","og_url":"https:\/\/exceladvisor.org\/id\/sel-khusus\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:18:37+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-utiliser-la-methode-des-cellules-speciales-dans-vba.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/id\/sel-khusus\/","url":"https:\/\/exceladvisor.org\/id\/sel-khusus\/","name":"Bagaimana cara menggunakan metode sel khusus melalui VBA?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/sel-khusus\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/sel-khusus\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-utiliser-la-methode-des-cellules-speciales-dans-vba.png","datePublished":"2023-09-01T07:29:00+00:00","dateModified":"2023-12-06T06:18:37+00:00","description":"Tutorial ini menunjukkan cara menggunakan metode sel khusus di VBA untuk mengakses sel dengan properti khusus.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/sel-khusus\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/sel-khusus\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/sel-khusus\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-utiliser-la-methode-des-cellules-speciales-dans-vba.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-utiliser-la-methode-des-cellules-speciales-dans-vba.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/sel-khusus\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara menggunakan metode sel khusus?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/id\/#website","url":"https:\/\/exceladvisor.org\/id\/","name":"Excel Advisor","description":"Panduan utama Anda untuk mendominasi data!","publisher":{"@id":"https:\/\/exceladvisor.org\/id\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/id\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"id"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/id\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/id\/","logo":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2212","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/comments?post=2212"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2212\/revisions"}],"predecessor-version":[{"id":2747,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2212\/revisions\/2747"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=2212"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}