{"id":1520,"date":"2023-11-18T02:08:34","date_gmt":"2023-11-18T02:08:34","guid":{"rendered":"https:\/\/exceladvisor.org\/tr\/hata-yonetimi\/"},"modified":"2023-12-10T06:05:44","modified_gmt":"2023-12-10T06:05:44","slug":"hata-yonetimi","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/tr\/hata-yonetimi\/","title":{"rendered":"Vba hatas\u0131 t\u00fcrleri: hata ay\u0131klama ve \u00e7\u00f6z\u00fcm"},"content":{"rendered":"<div class=\"excel-icerikten-once\" id=\"excel-2362725434\"><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\u011fer programlama dilleri gibi, VBA da hatalar s\u00f6z konusu oldu\u011funda \u015fanss\u0131zd\u0131r ve ne olursa olsun onlarla u\u011fra\u015fman\u0131z gerekir. K\u00f6t\u00fc kodlama, imkans\u0131z i\u015flemler (s\u0131f\u0131ra b\u00f6lmek gibi) veya beklenmeyen hatalar gibi farkl\u0131 kaynaklardan gelebilirler.<\/p><p> Bunu halletmenin en iyi yolu, kodla elde edebilece\u011finiz t\u00fcm olas\u0131 sonu\u00e7lar\u0131 iyi anlamakt\u0131r. Se\u00e7ilen h\u00fccredeki de\u011feri kullanarak say\u0131n\u0131n karek\u00f6k\u00fcn\u00fc hesaplayan bir VBA kodumuzun bulundu\u011fu a\u015fa\u011f\u0131daki \u00f6rne\u011fe bak\u0131n.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub Square_Root() ActiveCell. <strong>Value<\/strong> = ActiveCell. <strong>Value<\/strong> ^ (1 \/ 2) <strong>End<\/strong> Sub<\/code><\/pre><p> Ancak aktif h\u00fccrenin say\u0131 d\u0131\u015f\u0131nda bir de\u011feri varsa a\u015fa\u011f\u0131daki gibi \u00e7al\u0131\u015fma zaman\u0131 hatas\u0131 al\u0131rs\u0131n\u0131z. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-58225\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/01-erreur-dexecution.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u00e7al\u0131\u015fma hatas\u0131\" width=\"531\" height=\"361\"><\/figure><\/div><h2 class=\"wp-block-heading\"> VBA&#8217;da Hata Parametreleri (Hata Yakalama)<\/h2><p> VBA se\u00e7ene\u011finde, kodlar\u0131 yazmaya ba\u015flamadan \u00f6nce hatalar\u0131 i\u015fleyecek \u015fekilde ayar\u0131 yap\u0131land\u0131rabilirsiniz. VBA ayarlar\u0131n\u0131 a\u00e7mak i\u00e7in Ara\u00e7lar \u27a4 Se\u00e7enekler \u27a4 Genel \u27a4 Hata Yakalama&#8217;ya gidin. Burada kullanabilece\u011finiz \u00fc\u00e7 se\u00e7ene\u011finiz var. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-58226\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/02-parametres-derreur-dans-vba.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"532\" height=\"336\"><\/figure><\/div><ul><li> <strong>T\u00fcm hatalarda durdur<\/strong> : Bu se\u00e7ene\u011fi etkinle\u015ftirdiyseniz, her t\u00fcrl\u00fc hata i\u015fleme tekni\u011fini kullanm\u0131\u015f olsan\u0131z bile VBA, kodu her t\u00fcrl\u00fc hata i\u00e7in durduracakt\u0131r.<\/li><li> <strong>Kurcalama S\u0131n\u0131f\u0131 Mod\u00fcl\u00fc<\/strong> : Bu se\u00e7enekle VBA, herhangi bir teknikle ele al\u0131nmayan t\u00fcm kodlar\u0131n\u0131z\u0131 durduracakt\u0131r. Ve e\u011fer Userforms gibi nesneler kullan\u0131rsan\u0131z, bu nesneler de k\u0131r\u0131lacak ve hatan\u0131n oldu\u011fu sat\u0131r\u0131 tam olarak vurgulayacakt\u0131r.<\/li><li> <strong>\u0130\u015flenmeyen Hatalarda Ara<\/strong> : Bu, herhangi bir hata i\u015fleme tekni\u011fi kullanmad\u0131\u011f\u0131n\u0131z t\u00fcm hatalar hakk\u0131nda bilgi sahibi olman\u0131za yard\u0131mc\u0131 olan ve i\u015flenmeyen t\u00fcm hatalar i\u00e7in kodu durduran varsay\u0131lan ayard\u0131r. (Ancak, Userforms gibi nesneler kullan\u0131rsan\u0131z, bu, nesnede hataya neden olan sat\u0131r\u0131 vurgulamaz, yaln\u0131zca o nesneye referans veren sat\u0131r\u0131 vurgular).<\/li><\/ul><h2 class=\"wp-block-heading\"> VBA Hata T\u00fcrleri<\/h2><p> VBA hatalar\u0131n\u0131 anlamak i\u00e7in bunlar\u0131 d\u00f6rt kategoriye ay\u0131rabilirsiniz; a\u015fa\u011f\u0131da bu t\u00fcr hatalar\u0131n a\u00e7\u0131klamas\u0131 bulunmaktad\u0131r.<\/p><h3 class=\"wp-block-heading\"> 1. S\u00f6zdizimi hatalar\u0131<\/h3><p> VBA kodunu yazarken belirli bir s\u00f6z dizimini takip etmeniz gerekiyor ve bunu g\u00f6rmezden geldi\u011finizde veya olmas\u0131 gerekti\u011fi gibi yazmad\u0131\u011f\u0131n\u0131zda S\u00d6ZD\u0130Z\u0130M\u0130 hatas\u0131yla (dil hatas\u0131 olarak da bilinir) kar\u015f\u0131la\u015fabilirsiniz. Kodlar\u0131n\u0131z\u0131 yazarken yapt\u0131\u011f\u0131n\u0131z yaz\u0131m hatalar\u0131 gibidir.<\/p><p> VBA, bir hata mesaj\u0131 g\u00f6r\u00fcnt\u00fcleyerek bu hatalar\u0131 bildirerek size yard\u0131mc\u0131 olur. VB d\u00fczenleyicinizde \u201cOtomatik S\u00f6zdizimi Denetimi\u201dnin etkinle\u015ftirildi\u011finden emin olman\u0131z yeterlidir.<\/p><p> Ara\u00e7 \u27a4 Se\u00e7enekler&#8217;e gidin ve \u201cOtomatik s\u00f6zdizimi denetimi\u201d kutusunu i\u015faretledi\u011finizden emin olun. Bununla, bir S\u00d6ZD\u0130Z\u0130M\u0130 hatas\u0131 yapt\u0131\u011f\u0131n\u0131zda, VBA bir hata mesaj\u0131 g\u00f6r\u00fcnt\u00fcler. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-58227\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/03-erreur-de-syntaxe.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"533\" height=\"336\"><\/figure><\/div><p> Ancak &#8220;Otomatik S\u00f6zdizimi Denetimi&#8221; devre d\u0131\u015f\u0131 b\u0131rak\u0131l\u0131rsa, VBA yine de hata i\u00e7eren kod sat\u0131r\u0131n\u0131 vurgular ancak hata mesaj\u0131n\u0131 g\u00f6r\u00fcnt\u00fclemez.<\/p><h3 class=\"wp-block-heading\"> 2. Derleme hatalar\u0131<\/h3><p> Bu, bir etkinli\u011fi ger\u00e7ekle\u015ftirmek i\u00e7in kod yazd\u0131\u011f\u0131n\u0131zda, ancak bu etkinlik ge\u00e7ersiz oldu\u011funda veya VBA taraf\u0131ndan ger\u00e7ekle\u015ftirilemedi\u011finde meydana gelir. Bunun en iyi \u00f6rne\u011fi, IF deyimini kullanan baz\u0131 kodlar\u0131n\u0131z oldu\u011fu, ancak deyimin sonuna END IF eklemeyi ka\u00e7\u0131rd\u0131\u011f\u0131n\u0131z ve \u015fimdi bu VBA&#8217;y\u0131 \u00e7al\u0131\u015ft\u0131rd\u0131\u011f\u0131n\u0131zda bir derleme hatas\u0131 mesaj\u0131 g\u00f6sterdi\u011finiz durumdur. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-58228\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/04-erreur-de-compilation.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"500\" height=\"251\"><\/figure><\/div><p> Bunun d\u0131\u015f\u0131nda derleme hatalar\u0131n\u0131n ba\u015fka \u00f6rnekleri de vard\u0131r:<\/p><ul><li> Sonraki olmadan For&#8217;u kullanma ( <a href=\"https:\/\/exceladvisor.org\/tr\/dongu-icin\/\">Sonraki i\u00e7in<\/a> ).<\/li><li> Sonu se\u00e7meden se\u00e7in ( B\u00fcy\u00fck <a href=\"https:\/\/exceladvisor.org\/tr\/davayi-sec\/\">\/k\u00fc\u00e7\u00fck harf se\u00e7in<\/a> ).<\/li><li> \u201c <a href=\"https:\/\/exceladvisor.org\/tr\/acik-secenek-2\/\">A\u00e7\u0131k Se\u00e7enek<\/a> \u201di etkinle\u015ftirdi\u011finizde bir de\u011fi\u015fken bildirmeyin.<\/li><li> Var olmayan bir alt\/i\u015flev \u00e7a\u011fr\u0131l\u0131yor.<\/li><\/ul><h3 class=\"wp-block-heading\"> 3. \u00c7al\u0131\u015fma Zaman\u0131 Hatalar\u0131<\/h3><p> Kod y\u00fcr\u00fct\u00fcld\u00fc\u011f\u00fcnde bir \u00e7al\u0131\u015fma zaman\u0131 hatas\u0131 olu\u015fur. Kodun bir say\u0131n\u0131n karek\u00f6k\u00fcn\u00fc hesaplad\u0131\u011f\u0131 yukar\u0131da sizinle payla\u015ft\u0131\u011f\u0131m \u00f6rne\u011fi hat\u0131rlay\u0131n. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-58229\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/05-erreur-dexecution-lors-de-lexecution-du-code.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"547\" height=\"372\"><\/figure><\/div><p> Kodu \u00e7al\u0131\u015ft\u0131r\u0131rken bir \u00e7al\u0131\u015fma zaman\u0131 hatas\u0131 olu\u015ftu\u011funda, kodu durdurur ve size hata ileti\u015fim kutusunu g\u00f6sterir ve bu hata kutusu, kar\u015f\u0131la\u015ft\u0131\u011f\u0131n\u0131z hatan\u0131n do\u011fas\u0131ndan bahseder. <a href=\"https:\/\/exceladvisor.org\/tr\/acik-dosya-dolabi\/\">Bir \u00e7al\u0131\u015fma kitab\u0131n\u0131 belirtti\u011finiz konumdan a\u00e7an bir<\/a> kod yazd\u0131\u011f\u0131n\u0131z\u0131, ancak bu \u00e7al\u0131\u015fma kitab\u0131n\u0131n art\u0131k birisi taraf\u0131ndan ta\u015f\u0131nd\u0131\u011f\u0131n\u0131 veya silindi\u011fini varsayal\u0131m. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-58178\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-vba-affiche-une-erreur-dexecution.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"452\" height=\"149\"><\/figure><\/div><p> Yani kodu \u00e7al\u0131\u015ft\u0131rd\u0131\u011f\u0131n\u0131zda VBA bu dosyay\u0131 bu konumda bulamad\u0131\u011f\u0131ndan size bir \u00e7al\u0131\u015fma zaman\u0131 hatas\u0131 g\u00f6sterecektir. Bir \u00e7al\u0131\u015fma zaman\u0131 hatas\u0131nda ald\u0131\u011f\u0131n\u0131z mesaj, hatan\u0131n nedenini anlaman\u0131za yard\u0131mc\u0131 olacak nedeni a\u00e7\u0131klar. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-58179\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-erreur-dexecution-1004.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"381\" height=\"215\"><\/figure><\/div><p> Ve bir \u00e7al\u0131\u015fma zaman\u0131 hatas\u0131 olu\u015ftu\u011funda kodun y\u00fcr\u00fct\u00fclmesi durdurulur. \u201cDebug\u201d butonuna t\u0131klad\u0131\u011f\u0131n\u0131zda bu hatay\u0131 i\u00e7eren kod sat\u0131r\u0131n\u0131 sar\u0131 renkle vurgulayarak size g\u00f6sterir. Veya kod y\u00fcr\u00fctmeyi durdurmak ve hata mesaj\u0131n\u0131 kapatmak i\u00e7in \u201cSonland\u0131r\u201d d\u00fc\u011fmesine t\u0131klayabilirsiniz.<\/p><h3 class=\"wp-block-heading\"> 4. Mant\u0131ksal hata<\/h3><p> Bu bir hata de\u011fil, kod yazarken olu\u015fan bir hatad\u0131r. Bu t\u00fcr hatalar bazen bulma ve d\u00fczeltme konusunda size zorluk \u00e7\u0131karabilir.<\/p><p> Diyelim ki bir kod yaz\u0131yorsunuz ve bir de\u011fi\u015fken bildirirken yanl\u0131\u015f <a href=\"https:\/\/exceladvisor.org\/tr\/degiskenler\/\">veri tipini<\/a> veya yanl\u0131\u015f hesaplama ad\u0131mlar\u0131n\u0131 kulland\u0131n\u0131z. Bu durumda kodunuz d\u00fczg\u00fcn \u00e7al\u0131\u015facak ve bu hatay\u0131 kolayca bulamazs\u0131n\u0131z. Bu t\u00fcr problemlerle ba\u015f etmenin en iyi yolu her kod sat\u0131r\u0131n\u0131 tek tek \u00e7al\u0131\u015ft\u0131rmakt\u0131r.<\/p><h2 class=\"wp-block-heading\"> VBA&#8217;da Hata Ay\u0131klama Ara\u00e7lar\u0131n\u0131 Kullanma<\/h2><p> VBA, kodunuzda hata ay\u0131klamak ve kodlar\u0131n\u0131zdaki hatalar\u0131 kald\u0131rmak i\u00e7in size bir dizi ara\u00e7 sa\u011flar.<\/p><h3 class=\"wp-block-heading\"> 1. VBA projesini derleyin<\/h3><p> Visual Basic Editor&#8217;da kodunuzu bitirdikten hemen sonra kullanabilece\u011finiz bir se\u00e7enek bulunmaktad\u0131r. Bu derleme se\u00e7enekleri kodunuzun her sat\u0131r\u0131n\u0131 analiz eder ve kodunuzda bir hata varsa bir mesaj kutusu g\u00f6r\u00fcnt\u00fcler.<\/p><p class=\"qt-tip\"> <strong>Not:<\/strong> VBA&#8217;y\u0131 Derle se\u00e7ene\u011fi, \u00e7al\u0131\u015fma zaman\u0131 hatalar\u0131n\u0131 de\u011fil yaln\u0131zca s\u00f6zdizimi ve derleme hatalar\u0131n\u0131 izler \u00e7\u00fcnk\u00fc bu hatalar yaln\u0131zca bir kod \u00e7al\u0131\u015f\u0131rken ortaya \u00e7\u0131kar. VBA Projesini Derleme&#8217;yi kullanmak i\u00e7in \u27a4 Hata Ay\u0131kla \u27a4 VBA Projesini Derle&#8217;ye gidin. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-58232\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/08-compiler-le-projet-vba.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"366\" height=\"352\"><\/figure><\/div><p> \u201cVBA Projesini Derle\u201dyi \u00e7al\u0131\u015ft\u0131rd\u0131\u011f\u0131n\u0131zda ve kodunuzda hi\u00e7bir hata kalmad\u0131\u011f\u0131nda se\u00e7enekler gri renkte olacakt\u0131r.<\/p><h3 class=\"wp-block-heading\"> 2. Her kod sat\u0131r\u0131n\u0131 tek tek \u00e7al\u0131\u015ft\u0131r\u0131n<\/h3><p> Ben bu \u015fekilde yap\u0131yorum. Bir kodu tamamlad\u0131\u011f\u0131mda, hata olup olmad\u0131\u011f\u0131n\u0131 kontrol etmek i\u00e7in onu sat\u0131r sat\u0131r \u00e7al\u0131\u015ft\u0131r\u0131r\u0131m. Bu zaman alabilir ancak t\u00fcm hatalar\u0131 (s\u00f6zdizimi, derleme ve y\u00fcr\u00fctme) \u00e7\u00f6zmenize yard\u0131mc\u0131 olur.<\/p><p> &#8220;Hata Ay\u0131klama Ara\u00e7 \u00c7ubu\u011fu&#8221;nda, kodu sat\u0131r sat\u0131r \u00e7al\u0131\u015ft\u0131rmak i\u00e7in kullanabilece\u011finiz bir &#8220;Ad\u0131m Gir&#8221; d\u00fc\u011fmesi vard\u0131r veya tek bir sat\u0131r\u0131 \u00e7al\u0131\u015ft\u0131rmak i\u00e7in F8 tu\u015funa basabilir ve ard\u0131ndan koddaki bir sonraki sat\u0131r\u0131 \u00e7al\u0131\u015ft\u0131rmak i\u00e7in tekrar basabilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-58233\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/09-executer-chaque-ligne-de-code.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"338\" height=\"387\"><\/figure><\/div><h2 class=\"wp-block-heading\"> VBA Hatalar\u0131n\u0131 \u0130\u015flemek i\u00e7in &#8220;On ERROR&#8221; \u0130fadesini Kullanma<\/h2><p> Kodlar\u0131n\u0131z\u0131 kontrol etmeniz ve mevcut t\u00fcm hata ay\u0131klama y\u00f6ntemlerindeki olas\u0131 hatalar\u0131 bulman\u0131z \u00f6nemlidir. Ancak en iyi ve en etkili yol, bir hatay\u0131 ele alabilecek ve kodunuzu \u00e7al\u0131\u015ft\u0131r\u0131ld\u0131\u011f\u0131nda kusursuz hale getirebilecek hata i\u015fleme talimatlar\u0131 olu\u015fturmakt\u0131r. Bu ifadeleri inceleyelim. VBA kodunda bir hata olu\u015ftu\u011funda, bu hatay\u0131 gidermenin en iyi yollar\u0131 \u015funlar olabilir:<\/p><ul><li> VBA&#8217;n\u0131n hatay\u0131 g\u00f6rmezden gelmesine ve kodu \u00e7al\u0131\u015ft\u0131rmas\u0131na izin verin<\/li><li> Bir hata olu\u015ftu\u011funda \u00f6zel bir dizi talimat\u0131n y\u00fcr\u00fct\u00fclmesine izin verin.<\/li><\/ul><p> Her iki \u00e7\u00f6z\u00fcmde de &#8220;Hata Durumunda&#8221; ifadelerini kullanabilirsiniz. A\u015fa\u011f\u0131da kullanabilece\u011finiz d\u00f6rt \u201cHata Durumunda\u201d ifadesi bulunmaktad\u0131r. \u015eimdi her ifadeye tek tek bakal\u0131m.<\/p><h3 class=\"wp-block-heading\"> 1. Hata yaparsan\u0131z yeniden ba\u015flay\u0131n<\/h3><p> Bu basit kod sat\u0131r\u0131, bir hata olu\u015fmas\u0131na ra\u011fmen VBA&#8217;n\u0131n kodu \u00e7al\u0131\u015ft\u0131rmaya devam etmesini sa\u011flar. <strong>F\u0130K\u0130R basit:<\/strong> y\u00fcr\u00fctme s\u0131ras\u0131nda herhangi bir yerde bir hata tespit edilirse bir sonraki kod sat\u0131r\u0131na ge\u00e7in.<\/p><p> A\u015fa\u011f\u0131daki kodda iki sat\u0131rl\u0131k kod var:<\/p><ul><li> \u0130lk sat\u0131r, A1 h\u00fccresindeki de\u011ferin 25 b\u00f6l\u00fc 0 oldu\u011funu g\u00f6sterir<\/li><li> \u0130kinci sat\u0131rda ise A2 h\u00fccre de\u011ferinin 10 b\u00f6l\u00fc 5 oldu\u011fu yaz\u0131yor<\/li><\/ul><p> Art\u0131k \u00e7evrimi\u00e7i oldu\u011funuz kodda bir sorun var. Bildi\u011finiz gibi herhangi bir \u015feyi 0&#8217;a b\u00f6lerseniz sonu\u00e7 hata olur. Dolay\u0131s\u0131yla, bu kodu \u00e7al\u0131\u015ft\u0131rd\u0131\u011f\u0131n\u0131zda VBA, <strong>&#8220;\u00c7al\u0131\u015fma zaman\u0131 hatas\u0131 &#8217;11&#8217; S\u0131f\u0131ra b\u00f6l&#8221;<\/strong> hata mesaj\u0131n\u0131 g\u00f6r\u00fcnt\u00fcler ve y\u00fcr\u00fctmeyi durdurur.<\/p><p> Ancak kodun en ba\u015f\u0131na &#8220;Hata Durumunda Devam Ettir&#8221; se\u00e7ene\u011fini ekleyip kodu \u00e7al\u0131\u015ft\u0131rd\u0131\u011f\u0131n\u0131zda, VBA, hatan\u0131n olu\u015ftu\u011fu kod sat\u0131r\u0131n\u0131 yok sayar ve ikinci sat\u0131rla devam eder ve bu de\u011feri A2 h\u00fccresine ekler.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub myDivide() <strong>On<\/strong> Error Resume <strong>Next<\/strong> <strong>Range<\/strong> (\"A1\"). <strong>Value<\/strong> = 25 \/ 0 <strong>Range<\/strong> (\"A2\"). <strong>Value<\/strong> = 10 \/ 5 <strong>End<\/strong> Sub<\/code><\/pre><p> Bu nedenle, herhangi bir yerde meydana gelen bir hataya ra\u011fmen kodunuzun \u00e7al\u0131\u015fmas\u0131n\u0131 istedi\u011finizde, kodunuzdaki \u201cHata Durumunda Devam Ettir\u201d ifadesini kullanman\u0131z yeterlidir.<\/p><p> <strong>Ancak dikkat etmeniz gereken bir \u015fey daha var:<\/strong> yaln\u0131zca daha sonra meydana gelen hatalar\u0131 g\u00f6z ard\u0131 edecektir.<\/p><p> Diyelim ki 5. sat\u0131rda bir hata olu\u015ftu ve 8. sat\u0131ra &#8220;Hata Sonra Devam Et&#8221; se\u00e7ene\u011fini eklediniz, bu hatay\u0131 atlamayacakt\u0131r. Bu nedenle en iyi yol, onu prosed\u00fcrdeki ilk kod sat\u0131r\u0131 olarak eklemektir.<\/p><h3 class=\"wp-block-heading\"> 2. GoTo 0 hatas\u0131 durumunda<\/h3><p> Bu, bir hata olu\u015ftu\u011funda kod y\u00fcr\u00fctmeyi durduran VBA&#8217;n\u0131n varsay\u0131lan davran\u0131\u015f\u0131d\u0131r.<\/p><p> Peki, \u201cHata Durumunda 0&#8217;a Git\u201d se\u00e7ene\u011fini kullanmak kodunuzda hi\u00e7bir fark yaratmaz. VBA, kodu durduracak ve hatan\u0131n a\u00e7\u0131klamas\u0131n\u0131 i\u00e7eren bir mesaj g\u00f6r\u00fcnt\u00fcleyecektir. Peki neden onu kullanmakla u\u011fra\u015fay\u0131m ki? Ak\u0131ll\u0131 soru. Yukar\u0131da &#8221; <strong>Hata Durumunda Devam Ettirme<\/strong> &#8221; b\u00f6l\u00fcm\u00fcnde kulland\u0131\u011f\u0131n\u0131z \u00f6rne\u011fi kullanal\u0131m.<\/p><p> Bu kodda herhangi bir hata olu\u015ftu\u011funda VBA bir sonraki kod sat\u0131r\u0131n\u0131 al\u0131r ve \u00e7al\u0131\u015ft\u0131r\u0131r ve herhangi bir hata mesaj\u0131 g\u00f6rmezsiniz. Ancak diyelim ki kodunuzda daha fazla sat\u0131r var ve kodda hata varsa bu sat\u0131rlar\u0131 a\u015fmak istemiyorsunuz.<\/p><p> Dolay\u0131s\u0131yla, ikinci kod sat\u0131r\u0131ndan sonra <strong>&#8220;Hata Durumunda 0&#8221;<\/strong> yazarsan\u0131z, VBA&#8217;n\u0131n, bir hata olu\u015ftu\u011funda hata mesajlar\u0131 g\u00f6r\u00fcnt\u00fcleyen varsay\u0131lan hata i\u015fleyicisi geri y\u00fcklenir.<\/p><h3 class=\"wp-block-heading\"> 3. Git hatas\u0131 durumunda [Etiket]<\/h3><p> Acil durumda gidebilece\u011finiz bir binada bir yer d\u00fc\u015f\u00fcn\u00fcn. Benzer \u015fekilde, &#8220;On Error GoTo [Label]&#8221; se\u00e7ene\u011fini kullanarak, bir hatay\u0131 i\u015flemek i\u00e7in ana kodunuzda ayr\u0131 bir kod blo\u011fu olu\u015fturabilirsiniz.<\/p><p> Asl\u0131nda, &#8220;Hata Durumunda [Etiket]&#8217;e Git&#8221;, hatalar\u0131 ele alman\u0131n \u00e7ok daha iyi ve daha kullan\u0131\u015fl\u0131 bir yoludur. A\u015fa\u011f\u0131daki kodda &#8220;On Error GoTo Oh!&#8221; Bu sat\u0131r bildiriminde \u015fimdi &#8220;Hata&#8221; kelimesi, &#8220;Oh!&#8221; Hata\u201d etiketidir.<\/p><p> Kodun sonuna bakarsan\u0131z, etiket ad\u0131 ile belirli bir ba\u015flang\u0131c\u0131n\u0131z ve ard\u0131ndan kodun \u00fczerinde bir mesaj bulunan bir mesaj kutusu i\u00e7in bir kod g\u00f6r\u00fcrs\u00fcn\u00fcz.<\/p><p> \u015eimdi bir hata olu\u015fursa ne olur, VBA &#8220;Oh! Error\u201d komutunu verir ve bu etiketten sonra sahip oldu\u011funuz kod blo\u011funu \u00e7al\u0131\u015ft\u0131r\u0131r.<\/p><p> <strong>Ancak dikkat etmeniz gereken bir \u015fey var:<\/strong> E\u011fer bir hata olu\u015fmazsa kodunuzdaki etiket \u00e7al\u0131\u015ft\u0131r\u0131lacakt\u0131r. Yapman\u0131z gereken iki \u015fey var:<\/p><ul><li> \u00d6ncelikle hata etiketinizi kodun sonuna ekledi\u011finizden emin olun.<\/li><li> \u0130kinci olarak, hata etiketinin \u00f6n\u00fcne bir &#8220;Alt \u00c7\u0131k\u0131\u015f&#8221; ekleyin.<\/li><\/ul><p> Bununla her iki durumda da fayda sa\u011flayacaks\u0131n\u0131z. Diyelim ki bir hata olu\u015fursa ve VBA belirtti\u011finiz etikete ge\u00e7erse yaln\u0131zca etiketin kendisinden koda kod olacakt\u0131r. Ve e\u011fer bir hata olu\u015fmazsa, etiketten \u00f6nce sahip oldu\u011funuz &#8220;Exit Sub&#8221; ifadesi, hata etiketini \u00e7al\u0131\u015ft\u0131rmadan prosed\u00fcrden \u00e7\u0131kacakt\u0131r.<\/p><h3 class=\"wp-block-heading\"> 4. Git hatas\u0131 -1 durumunda<\/h3><p> Bu konuya girmeden \u00f6nce sizinle bir \u015fey payla\u015fay\u0131m. Bir kodda bir hata olu\u015ftu\u011funda, VBA bu hata g\u00fcnl\u00fc\u011f\u00fcn\u00fc belle\u011finde saklar ve yaln\u0131zca rutin tamamland\u0131\u011f\u0131nda temizler.<\/p><p> <strong>Ey VBA! \u015eimdiki zamanda ya\u015fa<\/strong><\/p><p> VBA kodundaki ikinci hatay\u0131 i\u015flemek i\u00e7in ilk hatay\u0131 VBA&#8217;n\u0131n belle\u011finden temizlemeniz gerekir. A\u015fa\u011f\u0131daki kodda, iki farkl\u0131 kod blo\u011fundan gelen hatalar\u0131 i\u015fleyen iki &#8220;On Error GoTo [Label]&#8221; ifadesine sahipsiniz.<\/p><p> Ancak bu kodu \u00e7al\u0131\u015ft\u0131r\u0131rsan\u0131z, ikinci hatada VBA ayarlad\u0131\u011f\u0131n\u0131z etikete atlamayacak ve bunun yerine &#8220;Type Mismatch&#8221; hata mesaj\u0131n\u0131 g\u00f6sterecektir.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub Square_Root() <strong>On<\/strong> Error GoTo myError1 <strong>Range<\/strong> (\"A1\"). <strong>Value<\/strong> = <strong>Range<\/strong> (\"A1\"). <strong>Value<\/strong> ^ (1 \/ 2) myError1: MsgBox \"There's some problem with the value you have in the cell A1.\" <strong>On<\/strong> Error GoTo myError2 <strong>Range<\/strong> (\"A2\"). <strong>Value<\/strong> = <strong>Range<\/strong> (\"A2\"). <strong>Value<\/strong> ^ (1 \/ 2) myError2: MsgBox \"There's some problem with the value you have in the cell A2.\" <strong>End<\/strong> Sub<\/code><\/pre><p> Bu sorunu \u00e7\u00f6zmek i\u00e7in VBA&#8217;n\u0131n mevcut hatay\u0131 deposundan kald\u0131rmas\u0131na olanak tan\u0131yan &#8220;On Error GoTo -1&#8221; se\u00e7ene\u011fini kullanabilirsiniz.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub Square_Root() On Error GoTo myError1 Range(\"A1\").Value = Range(\"A1\").Value ^ (1 \/ 2) myError1: MsgBox \"There's some problem with the value you have in the cell A1.\" On Error GoTo -1 On Error GoTo myError2 Range(\"A2\").Value = Range(\"A2\").Value ^ (1 \/ 2) myError2: MsgBox \"There's some problem with the value you have in the cell A2.\" End Sub<\/code><\/pre><p> Art\u0131k bu kodu \u00e7al\u0131\u015ft\u0131rd\u0131\u011f\u0131n\u0131zda, &#8220;On Error GoTo -1&#8221;, hatay\u0131 bellekten kald\u0131r\u0131r ve VBA, ikinci ifadedeki hatay\u0131 istendi\u011fi gibi i\u015fler.<\/p><h2 class=\"wp-block-heading\"> VBA&#8217;daki hatalar\u0131 ele almak i\u00e7in ba\u015fka neleri bilmem gerekiyor?<\/h2><p> Hata i\u015fleme tekniklerini kullanman\u0131n yan\u0131 s\u0131ra, hatalar\u0131 daha iyi ele almak i\u00e7in kullanabilece\u011finiz birka\u00e7 \u015fey daha vard\u0131r.<\/p><h3 class=\"wp-block-heading\"> Nesne hatas\u0131<\/h3><p> Kodu \u00e7al\u0131\u015ft\u0131r\u0131rken bir hata olu\u015ftu\u011funda, hatayla ilgili ayr\u0131nt\u0131lar\u0131 almak i\u00e7in Err nesnesini kullanabilirsiniz. Err nesnesiyle kullanabilece\u011finiz birka\u00e7 \u00f6zellik ve y\u00f6ntem vard\u0131r. Bunlar\u0131 birer birer \u00f6\u011frenelim.<\/p><h4 class=\"wp-block-heading\"> <strong>\u00d6zellikler<\/strong><\/h4><p> Err nesnesiyle kullanabilece\u011finiz \u00f6zellikler \u015funlard\u0131r:<\/p><ul><li> <strong>Err.Number<\/strong> : Bir hata olu\u015ftu\u011funda Err nesnesine bir say\u0131 kaydedilir. A\u015fa\u011f\u0131daki kodda, bu durum olu\u015ftu\u011funda mesaj kutusunda hata numaras\u0131 g\u00f6r\u00fcnt\u00fclenir.<\/li><li> <strong>Err.A\u00e7\u0131klama<\/strong> : Bu \u00f6zellik, hatan\u0131n nedenini anlaman\u0131za yard\u0131mc\u0131 olabilecek hata a\u00e7\u0131klamas\u0131n\u0131 g\u00f6r\u00fcnt\u00fcler.<\/li><li> <strong>Err.Source:<\/strong> Bu \u00f6zellik size hatan\u0131n hangi projede olu\u015ftu\u011funu bildirir.<\/li><li> <strong>Err.HelpContext:<\/strong> Bu \u00f6zellik, yard\u0131m dosyas\u0131ndaki hatan\u0131n yard\u0131m ba\u011flam\u0131 kimli\u011fini d\u00f6nd\u00fcr\u00fcr.<\/li><li> <strong>Err.HelpContext:<\/strong> Bu, yard\u0131m dosyas\u0131n\u0131n konumu i\u00e7in bir dize de\u011feridir.<\/li><\/ul><p> Normalde hata i\u015fleme tekniklerini kullanarak hatalarla u\u011fra\u015f\u0131rken kodlar\u0131n\u0131zda Err nesnesini pek kullanmazs\u0131n\u0131z. Ancak a\u015fa\u011f\u0131da bunu kullanmak i\u00e7in basit bir \u00f6rnek verilmi\u015ftir.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\"><strong>Sub<\/strong> Square_Root() <strong>On<\/strong> <strong>Error<\/strong> <strong>GoTo<\/strong> myError1    Range(\"A1\").Value = Sqr(Range(\"A1\").Value) <strong>Exit<\/strong> <strong>Sub<\/strong> myError1:    MsgBox \"There's some problem with the value you have in the cell A1.\" &amp; vbCrLf &amp; _                \"Error Number: \" &amp; Err.Number  &amp; vbCrLf &amp; _                \"Error Description: \" &amp; Err.Description <strong>End<\/strong> <strong>Sub<\/strong><\/code><\/pre><p> Yukar\u0131daki kodu \u00e7al\u0131\u015ft\u0131rd\u0131\u011f\u0131n\u0131zda, e\u011fer bir hata olu\u015fmu\u015fsa, hata numaras\u0131n\u0131 ve hata a\u00e7\u0131klamas\u0131n\u0131 i\u00e7eren bir mesaj kutusu g\u00f6r\u00fcnt\u00fcleyecektir.<\/p><h4 class=\"wp-block-heading\"> <strong>Y\u00f6ntemler<\/strong><\/h4><p> Err Object ile iki y\u00f6ntemi de kullanabilirsiniz.<\/p><ul><li> <strong>Err.Clear:<\/strong> Bu y\u00f6ntem, hata numaras\u0131n\u0131 ve hata a\u00e7\u0131klamas\u0131n\u0131 VBA belle\u011finden temizler (bu, hatay\u0131 tamamen s\u0131f\u0131rlamad\u0131\u011f\u0131ndan &#8220;On Error GoTo -1&#8221; y\u00f6nteminden farkl\u0131d\u0131r).<\/li><li> <strong>Err.Raise:<\/strong> Bu y\u00f6ntemle kodunuzda <a href=\"https:\/\/docs.microsoft.com\/en-us\/office\/vba\/language\/reference\/user-interface-help\/raise-method\" target=\"_blank\" rel=\"noreferrer noopener\">kas\u0131tl\u0131 olarak bir \u00e7al\u0131\u015fma zaman\u0131 hatas\u0131 olu\u015fturabilirsiniz<\/a> ve izlenecek s\u00f6zdizimi a\u015fa\u011f\u0131da verilmi\u015ftir:<\/li><\/ul><p> <strong>Err<\/strong> .Raise [say\u0131], [kaynak], [a\u00e7\u0131klama], [yard\u0131m dosyas\u0131], [yard\u0131m i\u00e7eri\u011fi]<\/p><h2 class=\"wp-block-heading\"> Hata \u0130\u015flemeyle \u0130lgili H\u0131zl\u0131 \u0130pu\u00e7lar\u0131<\/h2><p> VBA hatalar\u0131n\u0131 daha iyi ele almak i\u00e7in kullanabilece\u011finiz baz\u0131 h\u0131zl\u0131 ipu\u00e7lar\u0131n\u0131 burada bulabilirsiniz.<\/p><ul><li> &#8220;Hata Durumunda Devam Ettir&#8221; se\u00e7ene\u011fini yaln\u0131zca bir hatan\u0131n olu\u015ftu\u011fundan emin oldu\u011funuzda ve hatal\u0131 kod sat\u0131r\u0131n\u0131 atlaman\u0131n kabul edilebilir oldu\u011funu ve bir sonraki sat\u0131ra ge\u00e7menin g\u00fcvenli oldu\u011funu bildi\u011finiz zaman kullan\u0131n.<\/li><li> \u00c7al\u0131\u015fma zaman\u0131 hatalar\u0131yla ba\u015fa \u00e7\u0131kman\u0131n en iyi yolu, &#8220;Hata \u0130\u015fleyicisi&#8221;ni &#8220;On Error GoTo [Label]&#8221; ile birlikte kullanmakt\u0131r. Bu, hata olu\u015ftu\u011funda size bilgi verilmesini sa\u011flar, ancak o k\u00f6t\u00fc hata mesaj\u0131n\u0131 g\u00f6r\u00fcnt\u00fclemez.<\/li><li> Hata i\u015fleyicisini her kulland\u0131\u011f\u0131n\u0131zda, \u00f6nce &#8220;Alttan \u00c7\u0131k\u0131\u015f&#8221;\u0131 kulland\u0131\u011f\u0131n\u0131zdan emin olun.<\/li><\/ul><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><div class=\"gb-grid-column gb-grid-column-50067b57\"><div class=\"gb-container gb-container-50067b57\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/tr\/tasma-hatasi-6\/\">VBA ta\u015fma hatas\u0131 (Hata 6)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/yurutme-hatasi-1004\/\">VBA \u00c7al\u0131\u015fma Zaman\u0131 Hatas\u0131 (Hata 1004)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/dizin-hatasi-9-araliginin-disinda\/\">VBA Dizini Y\u00fcr\u00fctme Hatas\u0131 Aral\u0131k D\u0131\u015f\u0131nda (Hata 9)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/uyumsuzluk-hatasi-turu-13\/\">VBA t\u00fcr\u00fc uyumsuzluk hatas\u0131 (Hata 13)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/yetersiz-bellek-hatasi-7\/\">VBA Bellek Yetersiz Hatas\u0131 (Hata 7)<\/a><\/li><\/ul><\/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-1520","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 Hata T\u00fcrleri: Hata Ay\u0131klama ve \u00c7\u00f6z\u00fcm 2023 - Excel Dan\u0131\u015fman\u0131<\/title>\n<meta name=\"description\" content=\"Di\u011fer programlama dilleri gibi, VBA da hatalar s\u00f6z konusu oldu\u011funda \u015fanss\u0131zd\u0131r ve ne olursa olsun onlarla u\u011fra\u015fmak zorundas\u0131n\u0131z...\" \/>\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\/hata-yonetimi\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"VBA Hata T\u00fcrleri: Hata Ay\u0131klama ve \u00c7\u00f6z\u00fcm 2023 - Excel Dan\u0131\u015fman\u0131\" \/>\n<meta property=\"og:description\" content=\"Di\u011fer programlama dilleri gibi, VBA da hatalar s\u00f6z konusu oldu\u011funda \u015fanss\u0131zd\u0131r ve ne olursa olsun onlarla u\u011fra\u015fmak zorundas\u0131n\u0131z...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/tr\/hata-yonetimi\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T06:05:44+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/01-erreur-dexecution.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=\"14 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/hata-yonetimi\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/hata-yonetimi\/\",\"name\":\"VBA Hata T\u00fcrleri: Hata Ay\u0131klama ve \u00c7\u00f6z\u00fcm 2023 - Excel Dan\u0131\u015fman\u0131\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/hata-yonetimi\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/hata-yonetimi\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/01-erreur-dexecution.png\",\"datePublished\":\"2023-11-18T02:08:34+00:00\",\"dateModified\":\"2023-12-10T06:05:44+00:00\",\"description\":\"Di\u011fer programlama dilleri gibi, VBA da hatalar s\u00f6z konusu oldu\u011funda \u015fanss\u0131zd\u0131r ve ne olursa olsun onlarla u\u011fra\u015fmak zorundas\u0131n\u0131z...\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/hata-yonetimi\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/tr\/hata-yonetimi\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/hata-yonetimi\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/01-erreur-dexecution.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/01-erreur-dexecution.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/hata-yonetimi\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/exceladvisor.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Vba hatas\u0131 t\u00fcrleri: hata ay\u0131klama ve \u00e7\u00f6z\u00fcm\"}]},{\"@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 Hata T\u00fcrleri: Hata Ay\u0131klama ve \u00c7\u00f6z\u00fcm 2023 - Excel Dan\u0131\u015fman\u0131","description":"Di\u011fer programlama dilleri gibi, VBA da hatalar s\u00f6z konusu oldu\u011funda \u015fanss\u0131zd\u0131r ve ne olursa olsun onlarla u\u011fra\u015fmak zorundas\u0131n\u0131z...","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\/hata-yonetimi\/","og_locale":"tr_TR","og_type":"article","og_title":"VBA Hata T\u00fcrleri: Hata Ay\u0131klama ve \u00c7\u00f6z\u00fcm 2023 - Excel Dan\u0131\u015fman\u0131","og_description":"Di\u011fer programlama dilleri gibi, VBA da hatalar s\u00f6z konusu oldu\u011funda \u015fanss\u0131zd\u0131r ve ne olursa olsun onlarla u\u011fra\u015fmak zorundas\u0131n\u0131z...","og_url":"https:\/\/exceladvisor.org\/tr\/hata-yonetimi\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T06:05:44+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/01-erreur-dexecution.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tahmini okuma s\u00fcresi":"14 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/tr\/hata-yonetimi\/","url":"https:\/\/exceladvisor.org\/tr\/hata-yonetimi\/","name":"VBA Hata T\u00fcrleri: Hata Ay\u0131klama ve \u00c7\u00f6z\u00fcm 2023 - Excel Dan\u0131\u015fman\u0131","isPartOf":{"@id":"https:\/\/exceladvisor.org\/tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/tr\/hata-yonetimi\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/hata-yonetimi\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/01-erreur-dexecution.png","datePublished":"2023-11-18T02:08:34+00:00","dateModified":"2023-12-10T06:05:44+00:00","description":"Di\u011fer programlama dilleri gibi, VBA da hatalar s\u00f6z konusu oldu\u011funda \u015fanss\u0131zd\u0131r ve ne olursa olsun onlarla u\u011fra\u015fmak zorundas\u0131n\u0131z...","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/tr\/hata-yonetimi\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/tr\/hata-yonetimi\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/hata-yonetimi\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/01-erreur-dexecution.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/01-erreur-dexecution.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/tr\/hata-yonetimi\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/exceladvisor.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Vba hatas\u0131 t\u00fcrleri: hata ay\u0131klama ve \u00e7\u00f6z\u00fcm"}]},{"@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\/1520","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=1520"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1520\/revisions"}],"predecessor-version":[{"id":2829,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1520\/revisions\/2829"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/media?parent=1520"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}