{"id":2157,"date":"2023-09-28T15:20:02","date_gmt":"2023-09-28T15:20:02","guid":{"rendered":"https:\/\/exceladvisor.org\/tr\/yurutme-hatasi-1004\/"},"modified":"2023-12-10T06:05:02","modified_gmt":"2023-12-10T06:05:02","slug":"yurutme-hatasi-1004","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/tr\/yurutme-hatasi-1004\/","title":{"rendered":"Vba \u00e7al\u0131\u015fma zaman\u0131 hatas\u0131 1004 nas\u0131l d\u00fczeltilir?"},"content":{"rendered":"<div class=\"excel-icerikten-once\" id=\"excel-2282871867\"><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>Excel&#8217;de bir makro \u00e7al\u0131\u015ft\u0131r\u0131l\u0131rken VBA \u00e7al\u0131\u015fma zaman\u0131 hatas\u0131 1004 olu\u015fuyor. Bu, \u00e7e\u015fitli nedenlerle olu\u015fabilecek bir hatad\u0131r. A\u015fa\u011f\u0131daki \u00f6rnekte g\u00f6rebilece\u011finiz gibi kodu \u00e7al\u0131\u015ft\u0131rd\u0131\u011f\u0131mda \u00e7al\u0131\u015fma zaman\u0131 hatas\u0131 &#8216;1004&#8217; g\u00f6steriyor. Basit bir ifadeyle, nesne veya uygulama ile bir aktivite ger\u00e7ekle\u015ftiremedi\u011finizde de bu durumun meydana geldi\u011fini s\u00f6yleyebilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-57091\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-erreur-dexecution-vba.png\" sizes=\"auto, \" srcset=\"\" alt=\"vba-\u00e7al\u0131\u015fma zaman\u0131 hatas\u0131\" width=\"702\" height=\"471\"><\/figure><\/div><p> Bu derste, bu \u00e7al\u0131\u015fma zaman\u0131 hatas\u0131 1004&#8217;\u00fcn di\u011fer birka\u00e7 nedenini anlayaca\u011f\u0131z.<\/p><h2 class=\"wp-block-heading\"> Hata1: VBA \u00e7al\u0131\u015fma zaman\u0131 hatas\u0131 1004: Bu ad zaten al\u0131nm\u0131\u015f. Ba\u015fka bir tane dene:<\/h2><p> Yukar\u0131da payla\u015ft\u0131\u011f\u0131m gibi \u00e7al\u0131\u015fma kitab\u0131nda zaten bulunan isme sahip bir sayfay\u0131 VBA kodu kullanarak eklemeye \u00e7al\u0131\u015ft\u0131\u011f\u0131n\u0131zda VBA size 1004 kodlu \u00e7al\u0131\u015fma zaman\u0131 hatas\u0131 g\u00f6steriyor.<\/p><p> <a href=\"https:\/\/exceladvisor.org\/tr\/sayfayi-yeniden-adlandir\/\">Bir \u00e7al\u0131\u015fma sayfas\u0131n\u0131 yeniden adland\u0131rmaya<\/a> \u00e7al\u0131\u015ft\u0131\u011f\u0131n\u0131zda bile VBA&#8217;dan ayn\u0131 hatay\u0131 al\u0131yorsunuz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-57092\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-renommer-une-feuille-de-calcul.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"594\" height=\"570\"><\/figure><\/div><p> Yukar\u0131daki kodda &#8220;Sayfa2&#8221; sayfas\u0131n\u0131 &#8220;Sayfa1&#8221; ad\u0131yla yeniden adland\u0131rmaya \u00e7al\u0131\u015ft\u0131m, ancak g\u00f6rebilece\u011finiz gibi \u00e7al\u0131\u015fma kitab\u0131nda zaten &#8220;Sayfa1&#8221; var; VBA bana 1004 hata kodunu g\u00f6sterdi.<\/p><p> Bu sorunu \u00e7\u00f6zmek i\u00e7in \u00e7al\u0131\u015fma kitab\u0131nda bir sayfan\u0131n mevcut olup olmad\u0131\u011f\u0131n\u0131 kontrol etmeniz gerekir.<\/p><h2 class=\"wp-block-heading\"> Hata 2: VBA \u00c7al\u0131\u015fma Zaman\u0131 Hatas\u0131 1004: &#8216;_Global&#8217; nesnesinin &#8216;Aral\u0131k&#8217; y\u00f6ntemi ba\u015far\u0131s\u0131z oldu:<\/h2><p> Bildi\u011finiz gibi Excel&#8217;de adland\u0131r\u0131lm\u0131\u015f bir aral\u0131k olu\u015fturabilirsiniz, ancak VBA kodunu kullanarak bu adland\u0131r\u0131lm\u0131\u015f aral\u0131\u011fa ba\u015fvurmaya \u00e7al\u0131\u015ft\u0131\u011f\u0131n\u0131zda ve ad\u0131n\u0131 yanl\u0131\u015f yazd\u0131\u011f\u0131n\u0131zda, 1004 Object &#8216;Range&#8217; method &#8216;_Global&#8217; \u00e7al\u0131\u015fma zaman\u0131 hatas\u0131 ba\u015far\u0131s\u0131z olabilir.<\/p><p> A\u015fa\u011f\u0131daki \u00f6rnekte, &#8220;myRange&#8221; ad\u0131nda bir adland\u0131r\u0131lm\u0131\u015f aral\u0131\u011f\u0131m var, ancak makroyu yazarken, bu bir yaz\u0131m hatas\u0131 olmas\u0131na ra\u011fmen onu &#8220;myRang&#8221; olarak yanl\u0131\u015f yazd\u0131m; VBA bu hatay\u0131 tan\u0131mlayacak ve do\u011fru adland\u0131r\u0131lm\u0131\u015f aral\u0131\u011fa ba\u015fvuracak kadar ak\u0131ll\u0131 de\u011fil. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-57093\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-methode-gamme-dobjet.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"667\" height=\"555\"><\/figure><\/div><p> Bahsetti\u011fim isimde adland\u0131r\u0131lm\u0131\u015f bir aral\u0131k yok ve bu y\u00fczden bana \u00e7al\u0131\u015fma zaman\u0131 hatas\u0131 1004&#8217;\u00fc g\u00f6sterdi.<\/p><h2 class=\"wp-block-heading\"> Hata 3: VBA \u00e7al\u0131\u015fma zaman\u0131 hatas\u0131 1004: S\u0131n\u0131f Aral\u0131\u011f\u0131 y\u00f6ntemi se\u00e7ilemedi:<\/h2><p> Etkin \u00e7al\u0131\u015fma sayfas\u0131nda olmayan bir aral\u0131\u011f\u0131 se\u00e7mek i\u00e7in VBA kodunu kulland\u0131\u011f\u0131n\u0131zda, VBA size \u00e7al\u0131\u015fma zaman\u0131 hatas\u0131 1004&#8217;\u00fc g\u00f6sterir. \u00c7\u00fcnk\u00fc, bir sayfa hesaplamas\u0131 i\u00e7in bir h\u00fccre veya h\u00fccre aral\u0131\u011f\u0131 se\u00e7mek istiyorsan\u0131z, o anda etkin olmas\u0131 gerekir. .<\/p><p> Sayfa2 \u015fu anda etkinse, sayfa1&#8217;deki bir h\u00fccreyi se\u00e7emezsiniz.<\/p><p> A\u015fa\u011f\u0131daki \u00f6rnekte g\u00f6rd\u00fc\u011f\u00fcn\u00fcz gibi ilk sayfan\u0131n A1 h\u00fccresine ba\u015fvururken ayn\u0131 hatay\u0131 yapt\u0131m ancak sayfa 2 aktif. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-57094\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-Echec-de-la-methode-de-selection-de-la-classe-de-plage.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"575\" height=\"445\"><\/figure><\/div><p> Bu hatay\u0131 gidermenin en iyi yolu, \u00f6nce sayfay\u0131 etkinle\u015ftirmek ve ard\u0131ndan o sayfan\u0131n bir h\u00fccresini veya aral\u0131\u011f\u0131n\u0131 se\u00e7en bir kod sat\u0131r\u0131 yazmakt\u0131r. Ayr\u0131ca bir sayfan\u0131n etkin olup olmad\u0131\u011f\u0131n\u0131 kontrol edebilir, ard\u0131ndan o sayfan\u0131n h\u00fccresini se\u00e7ebilir ve e\u011fer o sayfa bir \u015fekilde etkin de\u011filse kullan\u0131c\u0131ya \u00f6nce bu sayfay\u0131 etkinle\u015ftirmesi i\u00e7in bir mesaj g\u00f6sterebilirsiniz.<\/p><h2 class=\"wp-block-heading\"> Error4: VBA \u00e7al\u0131\u015fma zaman\u0131 hatas\u0131 1004 Y\u00f6ntem aral\u0131\u011f\u0131 s\u0131n\u0131f\u0131 etkinle\u015ftirilemedi:<\/h2><p> Yukar\u0131daki nedende oldu\u011fu gibi, \u015fu anda aktif olmayan belirli bir \u00e7al\u0131\u015fma sayfas\u0131ndan bir h\u00fccreyi veya h\u00fccre aral\u0131\u011f\u0131n\u0131 etkinle\u015ftirmeye \u00e7al\u0131\u015ft\u0131\u011f\u0131n\u0131zda, size 1004 \u00e7al\u0131\u015fma zaman\u0131 hatas\u0131 (Failed to active method range class \ud83d\ude42 g\u00f6sterece\u011fiz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-57095\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-echec-de-lactivation-de-la-classe-de-plage-de-methodes.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"591\" height=\"464\"><\/figure><\/div><p> Sayfa1&#8217;de A1 h\u00fccresini etkinle\u015ftirmeye \u00e7al\u0131\u015ft\u0131\u011f\u0131m \u00f6rnekte bana 1004 \u00e7al\u0131\u015fma zaman\u0131 hatas\u0131 verdi, etkin sayfa sayfa2&#8217;ydi.<\/p><p> Bu hatayla tekrar ba\u015fa \u00e7\u0131kmak i\u00e7in bahsetti\u011finiz \u00e7al\u0131\u015fma sayfas\u0131n\u0131n aktif olup olmad\u0131\u011f\u0131n\u0131 kontrol etmeniz gerekmektedir. Veya bu sayfan\u0131n \u00e7al\u0131\u015fma kitab\u0131nda mevcut olup olmad\u0131\u011f\u0131n\u0131 da kontrol edebilirsiniz.<\/p><h2 class=\"wp-block-heading\"> Hata5: VBA \u00c7al\u0131\u015fma Zaman\u0131 Y\u00f6ntemi Hatas\u0131 1004 \u00dczg\u00fcn\u00fcz, bulamad\u0131k:<\/h2><p> Bir yolu kullanarak bir Excel dosyas\u0131n\u0131 a\u00e7maya \u00e7al\u0131\u015f\u0131rsan\u0131z ancak bu \u00e7al\u0131\u015fma kitab\u0131 orada de\u011filse, ta\u015f\u0131nm\u0131\u015f, silinmi\u015f veya yeniden adland\u0131r\u0131lm\u0131\u015f olabilir. Bu durumda VBA size tekrar 1004 \u00e7al\u0131\u015fma zaman\u0131 hatas\u0131n\u0131 g\u00f6sterecektir.<\/p><p> Dosyay\u0131 masa\u00fcst\u00fc yolumla a\u00e7maya \u00e7al\u0131\u015ft\u0131\u011f\u0131m a\u015fa\u011f\u0131daki \u00f6rnekte olan \u015fey buydu, ancak bu dosya orada de\u011fildi ve bana bir hata g\u00f6sterdi. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-57096\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-methode-desole-nous-navons-pas-pu-trouver.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"690\" height=\"399\"><\/figure><\/div><p> Bu durumla ba\u015fa \u00e7\u0131kmak i\u00e7in, bahsetti\u011finiz dosyan\u0131n klas\u00f6rde mevcut olup olmad\u0131\u011f\u0131n\u0131 kontrol etmek i\u00e7in baz\u0131 VBA kodlar\u0131n\u0131 kullanabilirsiniz.<\/p><h2 class=\"wp-block-heading\"> Hata 6: Object Binders VBA \u00c7al\u0131\u015fma Zaman\u0131 Hatas\u0131 1004 y\u00f6ntemi a\u00e7\u0131lamad\u0131:<\/h2><p> Bu hata ayn\u0131 zamanda \u00e7al\u0131\u015fma kitab\u0131yla da ilgilidir. Dolay\u0131s\u0131yla, bir kitab\u0131n zaten mevcut oldu\u011fu ve \u015fu anda a\u00e7\u0131k oldu\u011fu ada sahip bir \u00e7al\u0131\u015fma kitab\u0131n\u0131 a\u00e7maya \u00e7al\u0131\u015ft\u0131\u011f\u0131n\u0131zda, VBA size \u00e7al\u0131\u015fma zaman\u0131 hatas\u0131 1004&#8217;\u00fc (Nesne \u00e7al\u0131\u015fma kitaplar\u0131n\u0131 a\u00e7ma y\u00f6ntemi ba\u015far\u0131s\u0131z oldu) g\u00f6sterecektir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-57097\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-methode-douverture-des-classeurs-dobjets-a-echoue.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"646\" height=\"474\"><\/figure><\/div><p> Zaten a\u00e7\u0131k olan bir \u00e7al\u0131\u015fma kitab\u0131n\u0131 a\u00e7maya \u00e7al\u0131\u015ft\u0131\u011f\u0131m yukar\u0131daki \u00f6rnekte de ayn\u0131 \u015fey oldu ve VBA bana bir \u00e7al\u0131\u015fma zaman\u0131 hatas\u0131 (1004) g\u00f6sterdi.<\/p><h2 class=\"wp-block-heading\"> VBA Y\u00fcr\u00fctme S\u00fcresi Nas\u0131l Onar\u0131l\u0131r (Hata 1004)<\/h2><p> Hata 1004, VBA kodunu \u00e7al\u0131\u015ft\u0131r\u0131rken olu\u015fan bir \u00e7al\u0131\u015fma zaman\u0131 hatas\u0131d\u0131r. Ve yukar\u0131da tart\u0131\u015ft\u0131\u011f\u0131m\u0131z t\u00fcm hatalar, \u00e7al\u0131\u015fma zaman\u0131 hatas\u0131 1004&#8217;\u00fc \u00f6nlemek i\u00e7in kullanabilece\u011finiz noktalar\u0131 takip ederek kodu yazarken insan hatalar\u0131ndan kaynaklanmaktad\u0131r.<\/p><ol type=\"1\"><li> Hatan\u0131n hangi sat\u0131rda olu\u015ftu\u011funu g\u00f6rmek i\u00e7in ad\u0131m ad\u0131m kod y\u00fcr\u00fctme ger\u00e7ekle\u015ftirin.<\/li><li> Bahsetti\u011finiz \u00e7al\u0131\u015fma kitaplar\u0131n\u0131n t\u00fcm adlar\u0131n\u0131 kontrol etti\u011finizden emin olun.<\/li><li> Bir \u00e7al\u0131\u015fma kitab\u0131n\u0131n zaten a\u00e7\u0131k olup olmad\u0131\u011f\u0131n\u0131 kontrol etmek i\u00e7in VBA kodunu da kullanabilirsiniz.<\/li><li> Ve bir h\u00fccreye veya h\u00fccre aral\u0131\u011f\u0131na ba\u015fvurmadan \u00f6nce bir \u00e7al\u0131\u015fma sayfas\u0131n\u0131 etkinle\u015ftirmek i\u00e7in etkinle\u015ftirme y\u00f6ntemini kullan\u0131n.<\/li><\/ol><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\/hata-yonetimi\/\">VBA hata i\u015fleme<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/otomasyon-hatasi-440\/\">VBA otomasyon hatas\u0131 (Hata 440)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/gecersiz-prosedur-cagrisi-veya-bagimsiz-degisken-hatasi-5\/\">Ge\u00e7ersiz VBA prosed\u00fcr\u00fc \u00e7a\u011fr\u0131s\u0131 veya ba\u011f\u0131ms\u0131z de\u011fi\u015fken hatas\u0131 (Hata 5)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/nesne-bu-ozelligi-veya-yontemi-desteklemiyor-hatasi-438\/\">VBA nesnesi bu \u00f6zelli\u011fi veya y\u00f6ntem hatas\u0131n\u0131 desteklemiyor (Hata 438)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/nesne-gerekli-hata-424\/\">VBA Nesnesi Gerekli Hatas\u0131 (Hata 424)<\/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-2157","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 \u00c7al\u0131\u015fma Zaman\u0131 Hatas\u0131 (Hata 1004) Nas\u0131l D\u00fczeltilir?<\/title>\n<meta name=\"description\" content=\"Bu e\u011fitimde, \u00c7al\u0131\u015fma Zaman\u0131&#039;n\u0131n (Hata 1004) neden olu\u015ftu\u011funu ve VBA kodu yazarken bunun nas\u0131l ele al\u0131naca\u011f\u0131n\u0131 \u00f6\u011freneceksiniz.\" \/>\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\/yurutme-hatasi-1004\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"VBA \u00c7al\u0131\u015fma Zaman\u0131 Hatas\u0131 (Hata 1004) Nas\u0131l D\u00fczeltilir?\" \/>\n<meta property=\"og:description\" content=\"Bu e\u011fitimde, \u00c7al\u0131\u015fma Zaman\u0131&#039;n\u0131n (Hata 1004) neden olu\u015ftu\u011funu ve VBA kodu yazarken bunun nas\u0131l ele al\u0131naca\u011f\u0131n\u0131 \u00f6\u011freneceksiniz.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/tr\/yurutme-hatasi-1004\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T06:05:02+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-erreur-dexecution-vba.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=\"5 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/yurutme-hatasi-1004\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/yurutme-hatasi-1004\/\",\"name\":\"VBA \u00c7al\u0131\u015fma Zaman\u0131 Hatas\u0131 (Hata 1004) Nas\u0131l D\u00fczeltilir?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/yurutme-hatasi-1004\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/yurutme-hatasi-1004\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-erreur-dexecution-vba.png\",\"datePublished\":\"2023-09-28T15:20:02+00:00\",\"dateModified\":\"2023-12-10T06:05:02+00:00\",\"description\":\"Bu e\u011fitimde, \u00c7al\u0131\u015fma Zaman\u0131&#39;n\u0131n (Hata 1004) neden olu\u015ftu\u011funu ve VBA kodu yazarken bunun nas\u0131l ele al\u0131naca\u011f\u0131n\u0131 \u00f6\u011freneceksiniz.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/yurutme-hatasi-1004\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/tr\/yurutme-hatasi-1004\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/yurutme-hatasi-1004\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-erreur-dexecution-vba.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-erreur-dexecution-vba.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/yurutme-hatasi-1004\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/exceladvisor.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Vba \u00e7al\u0131\u015fma zaman\u0131 hatas\u0131 1004 nas\u0131l d\u00fczeltilir?\"}]},{\"@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 \u00c7al\u0131\u015fma Zaman\u0131 Hatas\u0131 (Hata 1004) Nas\u0131l D\u00fczeltilir?","description":"Bu e\u011fitimde, \u00c7al\u0131\u015fma Zaman\u0131&#39;n\u0131n (Hata 1004) neden olu\u015ftu\u011funu ve VBA kodu yazarken bunun nas\u0131l ele al\u0131naca\u011f\u0131n\u0131 \u00f6\u011freneceksiniz.","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\/yurutme-hatasi-1004\/","og_locale":"tr_TR","og_type":"article","og_title":"VBA \u00c7al\u0131\u015fma Zaman\u0131 Hatas\u0131 (Hata 1004) Nas\u0131l D\u00fczeltilir?","og_description":"Bu e\u011fitimde, \u00c7al\u0131\u015fma Zaman\u0131&#39;n\u0131n (Hata 1004) neden olu\u015ftu\u011funu ve VBA kodu yazarken bunun nas\u0131l ele al\u0131naca\u011f\u0131n\u0131 \u00f6\u011freneceksiniz.","og_url":"https:\/\/exceladvisor.org\/tr\/yurutme-hatasi-1004\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T06:05:02+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-erreur-dexecution-vba.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tahmini okuma s\u00fcresi":"5 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/tr\/yurutme-hatasi-1004\/","url":"https:\/\/exceladvisor.org\/tr\/yurutme-hatasi-1004\/","name":"VBA \u00c7al\u0131\u015fma Zaman\u0131 Hatas\u0131 (Hata 1004) Nas\u0131l D\u00fczeltilir?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/tr\/yurutme-hatasi-1004\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/yurutme-hatasi-1004\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-erreur-dexecution-vba.png","datePublished":"2023-09-28T15:20:02+00:00","dateModified":"2023-12-10T06:05:02+00:00","description":"Bu e\u011fitimde, \u00c7al\u0131\u015fma Zaman\u0131&#39;n\u0131n (Hata 1004) neden olu\u015ftu\u011funu ve VBA kodu yazarken bunun nas\u0131l ele al\u0131naca\u011f\u0131n\u0131 \u00f6\u011freneceksiniz.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/tr\/yurutme-hatasi-1004\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/tr\/yurutme-hatasi-1004\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/yurutme-hatasi-1004\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-erreur-dexecution-vba.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-erreur-dexecution-vba.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/tr\/yurutme-hatasi-1004\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/exceladvisor.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Vba \u00e7al\u0131\u015fma zaman\u0131 hatas\u0131 1004 nas\u0131l d\u00fczeltilir?"}]},{"@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\/2157","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=2157"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/2157\/revisions"}],"predecessor-version":[{"id":2787,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/2157\/revisions\/2787"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/media?parent=2157"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}