{"id":1550,"date":"2023-11-17T08:33:05","date_gmt":"2023-11-17T08:33:05","guid":{"rendered":"https:\/\/exceladvisor.org\/tr\/bos-hucreyi-kontrol-et\/"},"modified":"2023-12-10T06:04:52","modified_gmt":"2023-12-10T06:04:52","slug":"bos-hucreyi-kontrol-et","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/tr\/bos-hucreyi-kontrol-et\/","title":{"rendered":"Vba arac\u0131l\u0131\u011f\u0131yla bir h\u00fccrenin bo\u015f olup olmad\u0131\u011f\u0131 nas\u0131l kontrol edilir?"},"content":{"rendered":"<div class=\"excel-icerikten-once\" id=\"excel-861740067\"><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>Bir h\u00fccrenin bo\u015f olup olmad\u0131\u011f\u0131n\u0131 kontrol etmek i\u00e7in <a href=\"https:\/\/exceladvisor.org\/tr\/bos\/\">VBA&#8217;n\u0131n ISEMPTY i\u015flevini<\/a> kullanabilirsiniz. Bu fonksiyonda, kontrol etmek istedi\u011finiz h\u00fccreyi belirtmek i\u00e7in range nesnesini kullanman\u0131z gerekir ve bu h\u00fccre bo\u015fsa true, aksi halde false de\u011ferini d\u00f6nd\u00fcr\u00fcr. Sonucu almak i\u00e7in bir mesaj kutusu kullanabilir veya bir h\u00fccreyi kullanabilirsiniz.<\/p><h2 class=\"wp-block-heading\"> Bir h\u00fccrenin bo\u015f olup olmad\u0131\u011f\u0131n\u0131 kontrol etmek i\u00e7in VBA&#8217;y\u0131 kullan\u0131n<\/h2><ol type=\"1\"><li> \u201cIsEmpty\u201d i\u015flev ad\u0131yla ba\u015flay\u0131n.<\/li><li> Kontrol etmek istedi\u011finiz h\u00fccreyi belirtin.<\/li><li> Sonu\u00e7 de\u011ferini almak i\u00e7in bir mesaj kutusu veya h\u00fccre kullan\u0131n.<\/li><li> Sonunda kodu \u00e7al\u0131\u015ft\u0131r\u0131n. <\/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=\"bir h\u00fccrenin bo\u015f olup olmad\u0131\u011f\u0131n\u0131 kontrol etmek i\u00e7in vba'y\u0131 kullan\u0131n\" width=\"584\" height=\"472\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Birden fazla h\u00fccrenin bo\u015f olup olmad\u0131\u011f\u0131n\u0131 kontrol edin<\/h2><p> Aral\u0131ktaki her h\u00fccre \u00fczerinde yineleme yapman\u0131z gerekti\u011finde, aral\u0131ktaki bo\u015f h\u00fccreleri kontrol etmek ve saymak istiyorsan\u0131z.<\/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> Yukar\u0131daki kod A1:A10 aral\u0131\u011f\u0131ndaki her h\u00fccreden ge\u00e7erek ISEMPTY fonksiyonunu kullanarak her h\u00fccrenin bo\u015f olup olmad\u0131\u011f\u0131n\u0131 tek tek kontrol eder.<\/p><p> Ve her bo\u015f h\u00fccre i\u00e7in bir say\u0131m al\u0131r ve sonunda toplam h\u00fccre say\u0131s\u0131n\u0131 ve bo\u015f h\u00fccreleri i\u00e7eren bir mesaj kutusu g\u00f6r\u00fcnt\u00fcler.<\/p><p> Bo\u015f h\u00fccreleri de vurgulamak istiyorsan\u0131z a\u015fa\u011f\u0131daki kodu kullan\u0131n.<\/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\/tr\/vba\/\">VBA nedir<\/a><h2 class=\"gb-headline gb-headline-665e5f6b gb-headline-text gb-headline-mt-heading\"> \u0130lgili e\u011fitimler <\/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\/tr\/satir-sayisi\/\">Excel&#8217;de VBA kullanarak sat\u0131rlar\u0131 sayma<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/karakter-yazi-tipi\/\">Excel VBA yaz\u0131 tipi (renk, boyut, t\u00fcr ve kal\u0131n)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/sutun-satirini-gosteri-gizle\/\">Excel VBA Bir s\u00fctunu veya sat\u0131r\u0131 gizleyin ve g\u00f6sterin<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/aralik-1\/\">Excel VBA Aral\u0131\u011f\u0131 \u2013 Aral\u0131k ve H\u00fccrelerle \u00c7al\u0131\u015fmak<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/sinirlar\/\">Excel&#8217;de VBA kullanarak h\u00fccreye kenarl\u0131klar uygulama<\/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-1550","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>VBA arac\u0131l\u0131\u011f\u0131yla bir h\u00fccrenin bo\u015f olup olmad\u0131\u011f\u0131 nas\u0131l kontrol edilir? (E\u011fitim 2023)<\/title>\n<meta name=\"description\" content=\"Bu e\u011fitimde, bir h\u00fccrenin veya aral\u0131\u011f\u0131n bo\u015f olup olmad\u0131\u011f\u0131n\u0131 veya i\u015flevin kullan\u0131lmad\u0131\u011f\u0131n\u0131 kontrol etmek i\u00e7in VBA&#039;y\u0131 nas\u0131l kullanaca\u011f\u0131n\u0131z g\u00f6sterilir.\" \/>\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\/tr\/bos-hucreyi-kontrol-et\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"VBA arac\u0131l\u0131\u011f\u0131yla bir h\u00fccrenin bo\u015f olup olmad\u0131\u011f\u0131 nas\u0131l kontrol edilir? (E\u011fitim 2023)\" \/>\n<meta property=\"og:description\" content=\"Bu e\u011fitimde, bir h\u00fccrenin veya aral\u0131\u011f\u0131n bo\u015f olup olmad\u0131\u011f\u0131n\u0131 veya i\u015flevin kullan\u0131lmad\u0131\u011f\u0131n\u0131 kontrol etmek i\u00e7in VBA&#039;y\u0131 nas\u0131l kullanaca\u011f\u0131n\u0131z g\u00f6sterilir.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/tr\/bos-hucreyi-kontrol-et\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T06:04:52+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=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/bos-hucreyi-kontrol-et\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/bos-hucreyi-kontrol-et\/\",\"name\":\"VBA arac\u0131l\u0131\u011f\u0131yla bir h\u00fccrenin bo\u015f olup olmad\u0131\u011f\u0131 nas\u0131l kontrol edilir? (E\u011fitim 2023)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/bos-hucreyi-kontrol-et\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/bos-hucreyi-kontrol-et\/#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-10T06:04:52+00:00\",\"description\":\"Bu e\u011fitimde, bir h\u00fccrenin veya aral\u0131\u011f\u0131n bo\u015f olup olmad\u0131\u011f\u0131n\u0131 veya i\u015flevin kullan\u0131lmad\u0131\u011f\u0131n\u0131 kontrol etmek i\u00e7in VBA&#39;y\u0131 nas\u0131l kullanaca\u011f\u0131n\u0131z g\u00f6sterilir.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/bos-hucreyi-kontrol-et\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/tr\/bos-hucreyi-kontrol-et\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/bos-hucreyi-kontrol-et\/#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\/tr\/bos-hucreyi-kontrol-et\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/exceladvisor.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Vba arac\u0131l\u0131\u011f\u0131yla bir h\u00fccrenin bo\u015f olup olmad\u0131\u011f\u0131 nas\u0131l kontrol edilir?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\",\"url\":\"https:\/\/exceladvisor.org\/tr\/\",\"name\":\"Excel Advisor\",\"description\":\"Veri hakimiyetine y\u00f6nelik nihai rehberiniz!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/tr\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"tr\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/tr\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"VBA arac\u0131l\u0131\u011f\u0131yla bir h\u00fccrenin bo\u015f olup olmad\u0131\u011f\u0131 nas\u0131l kontrol edilir? (E\u011fitim 2023)","description":"Bu e\u011fitimde, bir h\u00fccrenin veya aral\u0131\u011f\u0131n bo\u015f olup olmad\u0131\u011f\u0131n\u0131 veya i\u015flevin kullan\u0131lmad\u0131\u011f\u0131n\u0131 kontrol etmek i\u00e7in VBA&#39;y\u0131 nas\u0131l kullanaca\u011f\u0131n\u0131z g\u00f6sterilir.","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\/tr\/bos-hucreyi-kontrol-et\/","og_locale":"tr_TR","og_type":"article","og_title":"VBA arac\u0131l\u0131\u011f\u0131yla bir h\u00fccrenin bo\u015f olup olmad\u0131\u011f\u0131 nas\u0131l kontrol edilir? (E\u011fitim 2023)","og_description":"Bu e\u011fitimde, bir h\u00fccrenin veya aral\u0131\u011f\u0131n bo\u015f olup olmad\u0131\u011f\u0131n\u0131 veya i\u015flevin kullan\u0131lmad\u0131\u011f\u0131n\u0131 kontrol etmek i\u00e7in VBA&#39;y\u0131 nas\u0131l kullanaca\u011f\u0131n\u0131z g\u00f6sterilir.","og_url":"https:\/\/exceladvisor.org\/tr\/bos-hucreyi-kontrol-et\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T06:04:52+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":{"Tahmini okuma s\u00fcresi":"2 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/tr\/bos-hucreyi-kontrol-et\/","url":"https:\/\/exceladvisor.org\/tr\/bos-hucreyi-kontrol-et\/","name":"VBA arac\u0131l\u0131\u011f\u0131yla bir h\u00fccrenin bo\u015f olup olmad\u0131\u011f\u0131 nas\u0131l kontrol edilir? (E\u011fitim 2023)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/tr\/bos-hucreyi-kontrol-et\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/bos-hucreyi-kontrol-et\/#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-10T06:04:52+00:00","description":"Bu e\u011fitimde, bir h\u00fccrenin veya aral\u0131\u011f\u0131n bo\u015f olup olmad\u0131\u011f\u0131n\u0131 veya i\u015flevin kullan\u0131lmad\u0131\u011f\u0131n\u0131 kontrol etmek i\u00e7in VBA&#39;y\u0131 nas\u0131l kullanaca\u011f\u0131n\u0131z g\u00f6sterilir.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/tr\/bos-hucreyi-kontrol-et\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/tr\/bos-hucreyi-kontrol-et\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/bos-hucreyi-kontrol-et\/#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\/tr\/bos-hucreyi-kontrol-et\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/exceladvisor.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Vba arac\u0131l\u0131\u011f\u0131yla bir h\u00fccrenin bo\u015f olup olmad\u0131\u011f\u0131 nas\u0131l kontrol edilir?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/tr\/#website","url":"https:\/\/exceladvisor.org\/tr\/","name":"Excel Advisor","description":"Veri hakimiyetine y\u00f6nelik nihai rehberiniz!","publisher":{"@id":"https:\/\/exceladvisor.org\/tr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/tr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"tr"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/tr\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/tr\/","logo":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1550","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/comments?post=1550"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1550\/revisions"}],"predecessor-version":[{"id":2770,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1550\/revisions\/2770"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/media?parent=1550"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}