{"id":653,"date":"2023-09-30T05:31:59","date_gmt":"2023-09-30T05:31:59","guid":{"rendered":"https:\/\/exceladvisor.org\/pt\/erro-de-estouro-6\/"},"modified":"2023-12-06T11:36:30","modified_gmt":"2023-12-06T11:36:30","slug":"erro-de-estouro-6","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/pt\/erro-de-estouro-6\/","title":{"rendered":"Como corrigir erro de estouro de vba (erro 6)?"},"content":{"rendered":"<div class=\"excel-before-content-2\" id=\"excel-567070289\"><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><div class=\"excel-before-content\" id=\"excel-77276378\"><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>No VBA, Overflow (Erro 6) \u00e9 um erro de tempo de execu\u00e7\u00e3o que ocorre quando voc\u00ea especifica um n\u00famero para a vari\u00e1vel que est\u00e1 fora do intervalo de n\u00fameros que esse tipo de dados pode assumir. Simplificando, esse erro ocorre quando voc\u00ea sai do intervalo do tipo de vari\u00e1vel.<\/p><p> Suponha que voc\u00ea esteja usando o tipo de dados Integer, que pode assumir valores entre -32768 e 32767. Portanto, ao especificar um valor fora desse intervalo, voc\u00ea obter\u00e1 o erro de tempo de execu\u00e7\u00e3o Overflow. <\/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=\"erro vba-overflow\" width=\"679\" height=\"315\"><\/figure><\/div><p> No exemplo acima, voc\u00ea pode ver que usamos o tipo de dados inteiro para a vari\u00e1vel iNum, mas ao especificar o valor, usamos &#8220;10000000&#8221;, que \u00e9 muito maior que o intervalo, e quando voc\u00ea executa o c\u00f3digo de estouro de erro de tempo de execu\u00e7\u00e3o ocorre. <\/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>Como lidar com o estouro (erro VBA 6)<\/strong><\/h2><p> A maneira de lidar com esse erro \u00e9 ter um entendimento completo dos tipos de dados VBA que voc\u00ea deve usar ao declarar uma vari\u00e1vel. Voc\u00ea deve lidar com um intervalo de valores ao usar um tipo de dados para armazenar um valor num\u00e9rico na vari\u00e1vel. Portanto, voc\u00ea precisa observar o intervalo do resultado que deseja armazenar na vari\u00e1vel.<\/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\/pt\/vba\/\">O que \u00e9 VBA<\/a><h2 class=\"gb-headline gb-headline-665e5f6b gb-headline-text gb-headline-mt-heading\"> Tutoriais relacionados <\/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\/pt\/manipulacao-de-erros\/\">Tratamento de erros VBA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/pt\/erro-de-automacao-440\/\">Erro de automa\u00e7\u00e3o VBA (Erro 440)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/pt\/erro-400\/\">Erro VBA 400<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/pt\/chamada-de-procedimento-invalida-ou-erro-de-argumento-5\/\">Chamada de procedimento VBA inv\u00e1lida ou erro de argumento (Erro 5)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/pt\/objeto-nao-suporta-esta-propriedade-ou-metodo-erro-438\/\">O objeto VBA n\u00e3o suporta esta propriedade ou erro de m\u00e9todo (Erro 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-653","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 Como corrigir erro de estouro de VBA (Erro 6)?<\/title>\n<meta name=\"description\" content=\"Neste tutorial, voc\u00ea aprender\u00e1 por que ocorre o estouro (erro 6) e como lidar com isso ao escrever o c\u00f3digo VBA.\" \/>\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\/pt\/erro-de-estouro-6\/\" \/>\n<meta property=\"og:locale\" content=\"pt_PT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 Como corrigir erro de estouro de VBA (Erro 6)?\" \/>\n<meta property=\"og:description\" content=\"Neste tutorial, voc\u00ea aprender\u00e1 por que ocorre o estouro (erro 6) e como lidar com isso ao escrever o c\u00f3digo VBA.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/pt\/erro-de-estouro-6\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T11:36:30+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=\"Tempo estimado de leitura\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minuto\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/erro-de-estouro-6\/\",\"url\":\"https:\/\/exceladvisor.org\/pt\/erro-de-estouro-6\/\",\"name\":\"\u25b7 Como corrigir erro de estouro de VBA (Erro 6)?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/erro-de-estouro-6\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/erro-de-estouro-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-06T11:36:30+00:00\",\"description\":\"Neste tutorial, voc\u00ea aprender\u00e1 por que ocorre o estouro (erro 6) e como lidar com isso ao escrever o c\u00f3digo VBA.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/erro-de-estouro-6\/#breadcrumb\"},\"inLanguage\":\"pt-PT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/pt\/erro-de-estouro-6\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/erro-de-estouro-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\/pt\/erro-de-estouro-6\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Lar\",\"item\":\"https:\/\/exceladvisor.org\/pt\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Como corrigir erro de estouro de vba (erro 6)?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/#website\",\"url\":\"https:\/\/exceladvisor.org\/pt\/\",\"name\":\"Excel Advisor\",\"description\":\"O seu guia definitivo para dominar os dados!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/pt\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"pt-PT\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/pt\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/pt\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/pt\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u25b7 Como corrigir erro de estouro de VBA (Erro 6)?","description":"Neste tutorial, voc\u00ea aprender\u00e1 por que ocorre o estouro (erro 6) e como lidar com isso ao escrever o c\u00f3digo VBA.","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\/pt\/erro-de-estouro-6\/","og_locale":"pt_PT","og_type":"article","og_title":"\u25b7 Como corrigir erro de estouro de VBA (Erro 6)?","og_description":"Neste tutorial, voc\u00ea aprender\u00e1 por que ocorre o estouro (erro 6) e como lidar com isso ao escrever o c\u00f3digo VBA.","og_url":"https:\/\/exceladvisor.org\/pt\/erro-de-estouro-6\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T11:36:30+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":{"Tempo estimado de leitura":"1 minuto"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/pt\/erro-de-estouro-6\/","url":"https:\/\/exceladvisor.org\/pt\/erro-de-estouro-6\/","name":"\u25b7 Como corrigir erro de estouro de VBA (Erro 6)?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/pt\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/pt\/erro-de-estouro-6\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/pt\/erro-de-estouro-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-06T11:36:30+00:00","description":"Neste tutorial, voc\u00ea aprender\u00e1 por que ocorre o estouro (erro 6) e como lidar com isso ao escrever o c\u00f3digo VBA.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/pt\/erro-de-estouro-6\/#breadcrumb"},"inLanguage":"pt-PT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/pt\/erro-de-estouro-6\/"]}]},{"@type":"ImageObject","inLanguage":"pt-PT","@id":"https:\/\/exceladvisor.org\/pt\/erro-de-estouro-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\/pt\/erro-de-estouro-6\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Lar","item":"https:\/\/exceladvisor.org\/pt\/"},{"@type":"ListItem","position":2,"name":"Como corrigir erro de estouro de vba (erro 6)?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/pt\/#website","url":"https:\/\/exceladvisor.org\/pt\/","name":"Excel Advisor","description":"O seu guia definitivo para dominar os dados!","publisher":{"@id":"https:\/\/exceladvisor.org\/pt\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/pt\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"pt-PT"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/pt\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/pt\/","logo":{"@type":"ImageObject","inLanguage":"pt-PT","@id":"https:\/\/exceladvisor.org\/pt\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/pt\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/pt\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/pt\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/pages\/653","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/comments?post=653"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/pages\/653\/revisions"}],"predecessor-version":[{"id":962,"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/pages\/653\/revisions\/962"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/media?parent=653"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}