{"id":1552,"date":"2023-11-17T08:33:05","date_gmt":"2023-11-17T08:33:05","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/periksa-sel-kosong\/"},"modified":"2023-12-06T06:14:25","modified_gmt":"2023-12-06T06:14:25","slug":"periksa-sel-kosong","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/periksa-sel-kosong\/","title":{"rendered":"Bagaimana cara memeriksa apakah suatu sel kosong melalui vba?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-4222960948\"><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>Untuk memeriksa apakah suatu sel kosong, Anda dapat menggunakan <a href=\"https:\/\/exceladvisor.org\/id\/kosong\/\">fungsi ISEMPTY VBA<\/a> . Dalam fungsi ini, Anda perlu menggunakan objek rentang untuk menentukan sel yang ingin Anda periksa, dan mengembalikan nilai benar jika sel tersebut kosong, jika tidak maka akan salah. Anda dapat menggunakan kotak pesan atau menggunakan sel untuk mendapatkan hasilnya.<\/p><h2 class=\"wp-block-heading\"> Gunakan VBA untuk memeriksa apakah sel kosong<\/h2><ol type=\"1\"><li> Mulailah dengan nama fungsi \u201cIsEmpty\u201d.<\/li><li> Tentukan sel yang ingin Anda periksa.<\/li><li> Gunakan kotak pesan atau sel untuk mendapatkan nilai hasil.<\/li><li> Pada akhirnya, jalankan kodenya. <\/li><\/ol><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">MsgBox IsEmpty(Range(\"A1\"))<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-54527\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-utiliser-vba-pour-verifier-si-une-cellule-est-vide.png\" sizes=\"auto, \" srcset=\"\" alt=\"gunakan vba untuk memeriksa apakah sel kosong\" width=\"584\" height=\"472\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Periksa apakah beberapa sel kosong<\/h2><p> Jika Anda ingin memeriksa dan menghitung sel kosong dalam suatu rentang saat Anda perlu mengulangi setiap sel dalam rentang tersebut.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub vba_check_empty_cells() Dim i As Long Dim c As Long Dim myRange As Range Dim myCell As Range Set myRange = Range(\"A1:A10\") For Each myCell In myRange c = c + 1 If IsEmpty(myCell) Then i = i + 1 End If Next myCell MsgBox _ \"There are total \" &amp; i &amp; \" empty cell(s) out of \" &amp; c &amp; \".\" End Sub<\/code><\/pre><p> Kode di atas melewati setiap sel dalam rentang A1:A10 dan memeriksa setiap sel satu per satu menggunakan fungsi ISEMPTY apakah kosong atau tidak.<\/p><p> Dan untuk setiap sel kosong, dibutuhkan penghitungan, dan pada akhirnya menampilkan kotak pesan dengan jumlah total sel dan sel kosong.<\/p><p> Gunakan kode berikut jika Anda juga ingin menyorot sel kosong.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Dim i As Long Dim c As Long Dim myRange As Range Dim myCell As Range Set myRange = Range(\"A1:A10\") For Each myCell In myRange ' c = c + 1 If IsEmpty(myCell) Then myCell.Interior.Color = RGB(255, 87, 87) i = i + 1 End If Next myCell MsgBox _ \"There are total \" &amp; i &amp; \" empty cell(s) out of \" &amp; c &amp; \".\"<\/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-1552","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 memeriksa apakah suatu sel kosong melalui VBA? (Tutorial 2023)<\/title>\n<meta name=\"description\" content=\"Tutorial ini menunjukkan cara menggunakan VBA untuk memeriksa apakah sel atau rentang kosong atau tidak menggunakan fungsi tersebut\" \/>\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\/periksa-sel-kosong\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bagaimana cara memeriksa apakah suatu sel kosong melalui VBA? (Tutorial 2023)\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menunjukkan cara menggunakan VBA untuk memeriksa apakah sel atau rentang kosong atau tidak menggunakan fungsi tersebut\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/periksa-sel-kosong\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:14:25+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-utiliser-vba-pour-verifier-si-une-cellule-est-vide.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\/periksa-sel-kosong\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/periksa-sel-kosong\/\",\"name\":\"Bagaimana cara memeriksa apakah suatu sel kosong melalui VBA? (Tutorial 2023)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/periksa-sel-kosong\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/periksa-sel-kosong\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-utiliser-vba-pour-verifier-si-une-cellule-est-vide.png\",\"datePublished\":\"2023-11-17T08:33:05+00:00\",\"dateModified\":\"2023-12-06T06:14:25+00:00\",\"description\":\"Tutorial ini menunjukkan cara menggunakan VBA untuk memeriksa apakah sel atau rentang kosong atau tidak menggunakan fungsi tersebut\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/periksa-sel-kosong\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/periksa-sel-kosong\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/periksa-sel-kosong\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-utiliser-vba-pour-verifier-si-une-cellule-est-vide.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-utiliser-vba-pour-verifier-si-une-cellule-est-vide.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/periksa-sel-kosong\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara memeriksa apakah suatu sel kosong melalui vba?\"}]},{\"@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 memeriksa apakah suatu sel kosong melalui VBA? (Tutorial 2023)","description":"Tutorial ini menunjukkan cara menggunakan VBA untuk memeriksa apakah sel atau rentang kosong atau tidak menggunakan fungsi tersebut","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\/periksa-sel-kosong\/","og_locale":"id_ID","og_type":"article","og_title":"Bagaimana cara memeriksa apakah suatu sel kosong melalui VBA? (Tutorial 2023)","og_description":"Tutorial ini menunjukkan cara menggunakan VBA untuk memeriksa apakah sel atau rentang kosong atau tidak menggunakan fungsi tersebut","og_url":"https:\/\/exceladvisor.org\/id\/periksa-sel-kosong\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:14:25+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-utiliser-vba-pour-verifier-si-une-cellule-est-vide.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\/periksa-sel-kosong\/","url":"https:\/\/exceladvisor.org\/id\/periksa-sel-kosong\/","name":"Bagaimana cara memeriksa apakah suatu sel kosong melalui VBA? (Tutorial 2023)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/periksa-sel-kosong\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/periksa-sel-kosong\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-utiliser-vba-pour-verifier-si-une-cellule-est-vide.png","datePublished":"2023-11-17T08:33:05+00:00","dateModified":"2023-12-06T06:14:25+00:00","description":"Tutorial ini menunjukkan cara menggunakan VBA untuk memeriksa apakah sel atau rentang kosong atau tidak menggunakan fungsi tersebut","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/periksa-sel-kosong\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/periksa-sel-kosong\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/periksa-sel-kosong\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-utiliser-vba-pour-verifier-si-une-cellule-est-vide.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-utiliser-vba-pour-verifier-si-une-cellule-est-vide.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/periksa-sel-kosong\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara memeriksa apakah suatu sel kosong melalui vba?"}]},{"@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\/1552","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=1552"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1552\/revisions"}],"predecessor-version":[{"id":2349,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1552\/revisions\/2349"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1552"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}