{"id":2125,"date":"2023-09-30T05:31:59","date_gmt":"2023-09-30T05:31:59","guid":{"rendered":"https:\/\/exceladvisor.org\/tr\/tasma-hatasi-6\/"},"modified":"2023-12-10T06:07:13","modified_gmt":"2023-12-10T06:07:13","slug":"tasma-hatasi-6","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/tr\/tasma-hatasi-6\/","title":{"rendered":"Vba ta\u015fma hatas\u0131 (hata 6) nas\u0131l d\u00fczeltilir?"},"content":{"rendered":"<div class=\"excel-icerikten-once\" id=\"excel-2018294287\"><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>VBA&#8217;da Ta\u015fma (Hata 6), de\u011fi\u015fkene bu veri t\u00fcr\u00fcn\u00fcn alabilece\u011fi say\u0131 aral\u0131\u011f\u0131n\u0131n d\u0131\u015f\u0131nda bir say\u0131 belirtti\u011finizde olu\u015fan bir \u00e7al\u0131\u015fma zaman\u0131 hatas\u0131d\u0131r. Basit\u00e7e s\u00f6ylemek gerekirse, bu hata, bir de\u011fi\u015fkenin t\u00fcr\u00fc i\u00e7in aral\u0131\u011f\u0131n d\u0131\u015f\u0131na \u00e7\u0131kt\u0131\u011f\u0131n\u0131zda ortaya \u00e7\u0131kar.<\/p><p> Diyelim ki -32768 ile 32767 aras\u0131nda de\u011fer alabilen Integer veri tipini kullan\u0131yorsunuz. Yani bu aral\u0131\u011f\u0131n d\u0131\u015f\u0131nda bir de\u011fer belirtti\u011finizde Overflow \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-57085\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-erreur-de-debordement-vba.png\" sizes=\"auto, \" srcset=\"\" alt=\"vba-ta\u015fma-hatas\u0131\" width=\"679\" height=\"315\"><\/figure><\/div><p> Yukar\u0131daki \u00f6rnekte iNum de\u011fi\u015fkeni i\u00e7in tamsay\u0131 veri tipini kulland\u0131\u011f\u0131m\u0131z\u0131 ancak de\u011feri belirtirken aral\u0131\u011f\u0131n \u00e7ok \u00fczerinde olan &#8220;10000000&#8221; kulland\u0131\u011f\u0131m\u0131z\u0131 ve \u00e7al\u0131\u015ft\u0131rd\u0131\u011f\u0131n\u0131zda Runtime error overflow kodunun olu\u015ftu\u011funu g\u00f6rebilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-57086\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-erreur-de-type-dexecution-de-debordement.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"841\" height=\"231\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub myMacro() Dim iNum As Integer iNum = 10000000 End Sub<\/code><\/pre><h2 class=\"wp-block-heading\"> <strong>Ta\u015fma nas\u0131l ele al\u0131n\u0131r (VBA hatas\u0131 6)<\/strong><\/h2><p> Bu hatayla ba\u015fa \u00e7\u0131kman\u0131n yolu, de\u011fi\u015fken bildirirken kullanman\u0131z gereken VBA veri t\u00fcrlerini tam olarak anlamakt\u0131r. De\u011fi\u015fkende say\u0131sal bir de\u011fer depolamak i\u00e7in bir veri t\u00fcr\u00fc kulland\u0131\u011f\u0131n\u0131zda, bir de\u011fer aral\u0131\u011f\u0131n\u0131 i\u015flemeniz gerekir. Bu nedenle de\u011fi\u015fkende saklamak istedi\u011finiz sonucun aral\u0131\u011f\u0131na bakman\u0131z gerekir.<\/p><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\/hata-400\/\">VBA hatas\u0131 400<\/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><\/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-2125","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>\u25b7 VBA ta\u015fma hatas\u0131 (Hata 6) nas\u0131l d\u00fczeltilir?<\/title>\n<meta name=\"description\" content=\"Bu e\u011fitimde ta\u015fman\u0131n (hata 6) 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\/tasma-hatasi-6\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 VBA ta\u015fma hatas\u0131 (Hata 6) nas\u0131l d\u00fczeltilir?\" \/>\n<meta property=\"og:description\" content=\"Bu e\u011fitimde ta\u015fman\u0131n (hata 6) 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\/tasma-hatasi-6\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T06:07:13+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-erreur-de-debordement-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=\"1 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/tasma-hatasi-6\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/tasma-hatasi-6\/\",\"name\":\"\u25b7 VBA ta\u015fma hatas\u0131 (Hata 6) nas\u0131l d\u00fczeltilir?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/tasma-hatasi-6\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/tasma-hatasi-6\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-erreur-de-debordement-vba.png\",\"datePublished\":\"2023-09-30T05:31:59+00:00\",\"dateModified\":\"2023-12-10T06:07:13+00:00\",\"description\":\"Bu e\u011fitimde ta\u015fman\u0131n (hata 6) 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\/tasma-hatasi-6\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/tr\/tasma-hatasi-6\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/tasma-hatasi-6\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-erreur-de-debordement-vba.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-erreur-de-debordement-vba.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/tasma-hatasi-6\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/exceladvisor.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Vba ta\u015fma hatas\u0131 (hata 6) 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":"\u25b7 VBA ta\u015fma hatas\u0131 (Hata 6) nas\u0131l d\u00fczeltilir?","description":"Bu e\u011fitimde ta\u015fman\u0131n (hata 6) 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\/tasma-hatasi-6\/","og_locale":"tr_TR","og_type":"article","og_title":"\u25b7 VBA ta\u015fma hatas\u0131 (Hata 6) nas\u0131l d\u00fczeltilir?","og_description":"Bu e\u011fitimde ta\u015fman\u0131n (hata 6) 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\/tasma-hatasi-6\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T06:07:13+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-erreur-de-debordement-vba.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tahmini okuma s\u00fcresi":"1 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/tr\/tasma-hatasi-6\/","url":"https:\/\/exceladvisor.org\/tr\/tasma-hatasi-6\/","name":"\u25b7 VBA ta\u015fma hatas\u0131 (Hata 6) nas\u0131l d\u00fczeltilir?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/tr\/tasma-hatasi-6\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/tasma-hatasi-6\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-erreur-de-debordement-vba.png","datePublished":"2023-09-30T05:31:59+00:00","dateModified":"2023-12-10T06:07:13+00:00","description":"Bu e\u011fitimde ta\u015fman\u0131n (hata 6) 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\/tasma-hatasi-6\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/tr\/tasma-hatasi-6\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/tasma-hatasi-6\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-erreur-de-debordement-vba.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-erreur-de-debordement-vba.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/tr\/tasma-hatasi-6\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/exceladvisor.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Vba ta\u015fma hatas\u0131 (hata 6) 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\/2125","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=2125"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/2125\/revisions"}],"predecessor-version":[{"id":2917,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/2125\/revisions\/2917"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/media?parent=2125"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}