{"id":5888,"date":"2025-09-26T08:11:20","date_gmt":"2025-09-26T08:11:20","guid":{"rendered":"https:\/\/pt.repairmsexcel.com\/blog\/?p=5888"},"modified":"2025-09-26T08:11:20","modified_gmt":"2025-09-26T08:11:20","slug":"erro-de-compilacao-do-excel-argumento-nao-opcional","status":"publish","type":"post","link":"https:\/\/pt.repairmsexcel.com\/blog\/erro-de-compilacao-do-excel-argumento-nao-opcional","title":{"rendered":"Excel Compile Error Argument Not Optional CORRE\u00c7\u00c3O \u2013 Pare a falha!"},"content":{"rendered":"<div class=\"cb46ff181ce6eef70c33ac8d8c9c88c4\" data-index=\"1\" style=\"float: none; margin:0px 0 0px 0; text-align:center;\">\n<style>\r\n.leaderboard { width: 320px; height: 100px; }\r\n@media(min-width: 500px) { .leaderboard { width: 468px; height: 60px; } }\r\n@media(min-width: 800px) { .leaderboard { width: 728px; height: 90px; } }\r\n<\/style>\r\n<script async src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-8329139124199643\" crossorigin=\"anonymous\"><\/script>\r\n<ins class=\"adsbygoogle leaderboard\"\r\n     style=\"display:inline-block\"\r\n\t data-full-width-responsive=\"true\"\r\n     data-ad-client=\"ca-pub-8329139124199643\"\r\n     data-ad-slot=\"1972481166\"><\/ins>\r\n<script>\r\n     (adsbygoogle = window.adsbygoogle || []).push({});\r\n<\/script>\n<\/div>\n<p style=\"text-align: justify;\">Ao executar macros VBA no MS Excel, voc\u00ea pode receber a famosa mensagem de aviso \u201c<strong>Compile error: Argument not optional<\/strong>.\u201d Essa mensagem de aviso pode arruinar sua experi\u00eancia de trabalho. Portanto, neste artigo, discutirei os principais fatores e solu\u00e7\u00f5es r\u00e1pidas para corrigir esse erro rapidamente e com menos esfor\u00e7o.<!--more--><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5889\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2025\/09\/1.png\" alt=\"Excel Compile Error Argument Not Optional\" width=\"262\" height=\"187\" \/><\/p>\n<p style=\"text-align: justify;\">Tamb\u00e9m mencionarei uma ferramenta de reparo do Excel especializada para resolver esse erro, caso ele tenha ocorrido devido \u00e0 corrup\u00e7\u00e3o de um arquivo. Ent\u00e3o, vamos come\u00e7ar&#8230;<\/p>\n<center><div style='margin: 5px 15px 15px 0;'><a style='background: #3bc949; border-radius: 25px; color: #ffffff; cursor: pointer; display: inline-block; font-size: 20px; font-weight: 500; padding: 2px 20px; height: 40px; line-height: 40px; vertical-align: middle; white-space: nowrap; text-decoration: none; border: none;' href='https:\/\/pt.repairmsexcel.com\/blog\/livre-baixar-para-win' target='_blank'><span style='color: #ffffff;'><i class='fab fa-windows'><\/i><\/span> Baixar<\/a> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<a style='background: #FAB152; border-radius: 25px; color: #ffffff; cursor: pointer; display: inline-block; font-size: 20px; font-weight: 500; padding: 2px 20px; height: 40px; line-height: 40px; vertical-align: middle; white-space: nowrap; text-decoration: none; border: none;' href='https:\/\/pt.repairmsexcel.com\/blog\/compre-agora' target='_blank'><span style='color: #ffffff;'><i class='fas fa-cart-plus'><\/i><\/span> Compre Agora<\/a><\/div><div style='margin: 5px 0 10px 0; font-size: 13px;'><font color='red'>*<\/font> A vers\u00e3o gratuita do produto exibe apenas dados recuper\u00e1veis.<\/div><\/center>\n<h2 style=\"text-align: left;\"><strong>O que \u00e9 o erro &#8220;Argumento n\u00e3o opcional&#8221; no Excel?<\/strong><\/h2>\n<p style=\"text-align: justify;\">Esse erro significa simplesmente que h\u00e1 um argumento omitido no c\u00f3digo VBA que n\u00e3o \u00e9 opcional. Um argumento s\u00f3 pode ser extraviado na chamada de um procedimento definido pelo usu\u00e1rio se for declarado como opcional na declara\u00e7\u00e3o do procedimento.<\/p>\n<h3 style=\"text-align: left;\"><strong>Por que este erro de tempo de execu\u00e7\u00e3o 449 ocorre?<\/strong><\/h3>\n<p style=\"text-align: justify;\">Este erro de tempo de execu\u00e7\u00e3o pode ocorrer por v\u00e1rios motivos, incluindo:<\/p>\n<ul style=\"text-align: justify;\">\n<li>Sintaxe incorreta no c\u00f3digo VBA.<\/li>\n<li>Um par\u00e2metro ausente em uma chamada de fun\u00e7\u00e3o.<\/li>\n<li>Uso de argumentos opcionais sem tratamento adequado.<\/li>\n<li>Devido a uma pasta de trabalho do Excel danificada.<\/li>\n<li>Uso indevido de fun\u00e7\u00f5es ou f\u00f3rmulas integradas do Excel.<\/li>\n<\/ul>\n<p style=\"text-align: justify;\">Depois de conhecer as causas comuns, \u00e9 hora de verificar as poss\u00edveis solu\u00e7\u00f5es para o problema.<\/p>\n<h2 style=\"text-align: left;\"><strong>Solu\u00e7\u00f5es para corrigir o erro de compila\u00e7\u00e3o do Microsoft Excel &#8220;Argumento n\u00e3o opcional&#8221;<\/strong><\/h2>\n<p style=\"text-align: justify;\">Siga estas solu\u00e7\u00f5es para corrigir o erro de forma eficaz:<\/p>\n<div class=\"su-note\"  style=\"border-color:#dad9d9;border-radius:2px;-moz-border-radius:2px;-webkit-border-radius:2px;\"><div class=\"su-note-inner su-u-clearfix su-u-trim\" style=\"background-color:#f4f3f3;border-color:#ffffff;color:#333333;border-radius:2px;-moz-border-radius:2px;-webkit-border-radius:2px;\">\n<h3 style=\"text-align: left;\"><strong>Corre\u00e7\u00f5es r\u00e1pidas:<\/strong><\/h3>\n<ol style=\"text-align: justify;\">\n<li><strong><a href=\"#s1\">Verifique a sintaxe da fun\u00e7\u00e3o<\/a><\/strong><\/li>\n<li><strong><a href=\"#s2\">Use argumentos opcionais<\/a><\/strong><\/li>\n<li><strong><a href=\"#s3\">Use a ferramenta de abertura e reparo integrada do Excel<\/a><\/strong><\/li>\n<li><strong><a href=\"#s4\">Depure o c\u00f3digo VBA<\/a><\/strong><\/li>\n<li><strong><a href=\"#s5\">Repare o MS Office<\/a><\/strong><\/li>\n<li><strong><a href=\"#s6\">Solu\u00e7\u00e3o definitiva &#8211; Experimente o software de reparo do Excel<\/a><\/strong><\/li>\n<\/ol>\n<\/div><\/div>\n<a name=\"s1\"><\/a><\/p>\n<h3 style=\"text-align: left;\"><strong>M\u00e9todo 1 &#8211; Verifique a sintaxe da fun\u00e7\u00e3o<\/strong><\/h3>\n<p style=\"text-align: justify;\">Como o erro est\u00e1 associado ao par\u00e2metro em uma chamada de fun\u00e7\u00e3o e aos argumentos, \u00e9 importante verificar a sintaxe. Certifique-se de que todos os nomes e argumentos da fun\u00e7\u00e3o estejam impl\u00edcitos corretamente e na ordem precisa.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5890\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2025\/09\/2-2.png\" alt=\"Excel Compile Error Argument Not Optional\" width=\"630\" height=\"210\" \/><\/p>\n<p style=\"text-align: justify;\">Al\u00e9m disso, certifique-se de que os colchetes estejam colocados corretamente dentro da f\u00f3rmula.<\/p>\n<blockquote>\n<p style=\"text-align: left;\"><strong><span style=\"color: #ff0000;\">Leia tamb\u00e9m<\/span>: <a class=\"row-title\" href=\"https:\/\/pt.repairmsexcel.com\/blog\/erro-5-chamada-de-procedimento-ou-argumento-invalido\" target=\"_blank\" rel=\"noopener\" aria-label=\"\u201cComo corrigir o erro \u201cRun-Time Error 5 Invalid Procedure Call or Argument\u201d no Excel?\u201d (Edit)\">Como corrigir o erro \u201cRun-Time Error 5 Invalid Procedure Call or Argument\u201d no Excel?<\/a><\/strong><\/p>\n<\/blockquote>\n<p><a name=\"s2\"><\/a><\/p>\n<h3 style=\"text-align: left;\"><strong>M\u00e9todo 2 &#8211; Usar Argumentos Opcionais<\/strong><\/h3>\n<p style=\"text-align: justify;\">Outra solu\u00e7\u00e3o vi\u00e1vel que voc\u00ea pode tentar \u00e9 verificar se est\u00e1 usando argumentos opcionais corretamente. Caso n\u00e3o tenha certeza, consulte a documenta\u00e7\u00e3o do VBA do Excel para refer\u00eancia.<\/p>\n<p><a name=\"s3\"><\/a><\/p>\n<h3 style=\"text-align: left;\"><strong>M\u00e9todo 3 &#8211; Usar a Ferramenta Integrada de Abrir e Reparar do Excel<\/strong><\/h3>\n<p style=\"text-align: justify;\">Como j\u00e1 mencionado nas causas, o erro de compila\u00e7\u00e3o do Excel <strong>&#8220;argumento n\u00e3o opcional<\/strong>&#8221; tamb\u00e9m pode ser acionado devido \u00e0 corrup\u00e7\u00e3o de arquivos XLS\/XLSX. Portanto, se voc\u00ea suspeitar que a corrup\u00e7\u00e3o da pasta de trabalho seja o verdadeiro motivo, poder\u00e1 usar a ferramenta de abrir e reparar para corrigi-lo.<\/p>\n<p style=\"text-align: justify;\">Veja como usar esta ferramenta:<\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"text-align: left;\">Abra o <strong>Excel<\/strong> &gt;&gt; clique em <strong>Arquivo &gt;&gt; Abrir<\/strong>.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5891\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2025\/09\/3.png\" alt=\"Excel Compile Error Argument Not Optional\" width=\"163\" height=\"400\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"text-align: left;\">Navegue at\u00e9 a pasta onde o arquivo corrompido do Excel est\u00e1 armazenado.<\/li>\n<li style=\"text-align: left;\">Na caixa de di\u00e1logo Abrir, selecione a pasta de trabalho danificada.<\/li>\n<li style=\"text-align: left;\">Em seguida, clique na seta ao lado do bot\u00e3o <strong>Abrir<\/strong> &gt;&gt; <strong>Abrir e Reparar.<\/strong><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5892\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2025\/09\/4-2.png\" alt=\"Excel Compile Error Argument Not Optional\" width=\"668\" height=\"455\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"text-align: left;\">Se desejar recuperar o m\u00e1ximo de dados poss\u00edvel da pasta de trabalho, clique em <strong>Reparar<\/strong>.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5893\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2025\/09\/5.jpg\" alt=\"Excel Compile Error Argument Not Optional\" width=\"847\" height=\"174\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2025\/09\/5.jpg 847w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2025\/09\/5-768x158.jpg 768w\" sizes=\"auto, (max-width: 847px) 100vw, 847px\" \/><br \/>\n<a name=\"s4\"><\/a><\/p>\n<h3 style=\"text-align: left;\"><strong>M\u00e9todo 4 &#8211; Depurando o C\u00f3digo VBA<\/strong><\/h3>\n<p style=\"text-align: justify;\">Ao executar o c\u00f3digo VBA no editor VBA, voc\u00ea pode encontrar este erro no Excel. Basta usar a op\u00e7\u00e3o Depurar para <strong>resolver o erro de tempo de execu\u00e7\u00e3o 449 &#8220;argumento n\u00e3o opcional&#8221;.<\/strong> Percorra o c\u00f3digo linha por linha. Isso ajudar\u00e1 voc\u00ea a identificar qual linha est\u00e1 causando o problema.<\/p>\n<p><a name=\"s5\"><\/a><\/p>\n<h3 style=\"text-align: left;\"><strong>M\u00e9todo 5 &#8211; Corrija o erro de compila\u00e7\u00e3o do Excel &#8220;argumento n\u00e3o opcional&#8221; reparando o MS Office<\/strong><\/h3>\n<p style=\"text-align: justify;\">Se as corre\u00e7\u00f5es mencionadas acima n\u00e3o funcionarem para voc\u00ea, considere reparar o Microsoft Office. Muitos usu\u00e1rios relataram em sites da comunidade que corrigiram esse erro tentando este m\u00e9todo. Para ver as etapas completas, clique aqui.<\/p>\n<p><a name=\"s6\"><\/a><\/p>\n<h2 style=\"text-align: left;\"><strong>Solu\u00e7\u00e3o Definitiva &#8211; Experimente o Software de Reparo do Excel<\/strong><\/h2>\n<p style=\"text-align: justify;\">Caso a pasta de trabalho esteja gravemente corrompida, opte pela <a href=\"https:\/\/pt.repairmsexcel.com\/baixar-julgamento.php\" target=\"_blank\" rel=\"noopener\"><strong>Excel Reparo Ferramenta<\/strong><\/a> recomendada para reparar arquivos XLS ou XLSX danificados do Excel com 100% de integridade.<\/p>\n<p style=\"text-align: justify;\">Esta ferramenta pode solucionar todos os tipos de erros do Excel e recuperar todos os dados da pasta de trabalho, incluindo <strong>tabelas, gr\u00e1ficos, imagens, f\u00f3rmulas, classifica\u00e7\u00f5es de coment\u00e1rios de c\u00e9lulas e filtros.<\/strong><\/p>\n<p style=\"text-align: justify;\">Al\u00e9m disso, usando a vers\u00e3o demo gratuita deste software, voc\u00ea pode digitalizar e visualizar dados recuper\u00e1veis \u200b\u200bde um arquivo.<\/p>\n<center><div style='margin: 5px 15px 15px 0;'><a style='background: #3bc949; border-radius: 25px; color: #ffffff; cursor: pointer; display: inline-block; font-size: 20px; font-weight: 500; padding: 2px 20px; height: 40px; line-height: 40px; vertical-align: middle; white-space: nowrap; text-decoration: none; border: none;' href='https:\/\/pt.repairmsexcel.com\/blog\/livre-baixar-para-win' target='_blank'><span style='color: #ffffff;'><i class='fab fa-windows'><\/i><\/span> Baixar<\/a> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<a style='background: #FAB152; border-radius: 25px; color: #ffffff; cursor: pointer; display: inline-block; font-size: 20px; font-weight: 500; padding: 2px 20px; height: 40px; line-height: 40px; vertical-align: middle; white-space: nowrap; text-decoration: none; border: none;' href='https:\/\/pt.repairmsexcel.com\/blog\/compre-agora' target='_blank'><span style='color: #ffffff;'><i class='fas fa-cart-plus'><\/i><\/span> Compre Agora<\/a><\/div><div style='margin: 5px 0 10px 0; font-size: 13px;'><font color='red'>*<\/font> A vers\u00e3o gratuita do produto exibe apenas dados recuper\u00e1veis.<\/div><\/center>\n<blockquote>\n<p style=\"text-align: left;\"><strong><span style=\"color: #ff0000;\">Leia tamb\u00e9m<\/span>: <a class=\"row-title\" href=\"https:\/\/pt.repairmsexcel.com\/blog\/consertar-o-numero-nesta-celula-esta-formatado-como-texto\" target=\"_blank\" rel=\"noopener\" aria-label=\"\u201cComo corrigir a mensagem \u201cThe number in this cell is formatted as text or preceded by an apostrophe\u201d no Excel?\u201d (Edit)\">Como corrigir a mensagem \u201cThe number in this cell is formatted as text or preceded by an apostrophe\u201d no Excel?<\/a><\/strong><\/p>\n<\/blockquote>\n<h2 style=\"text-align: left;\"><strong>Perguntas frequentes relacionadas:<\/strong><\/h2>\n<h4 style=\"text-align: left;\"><strong>O que \u00e9 um erro de argumento no Excel?<\/strong><\/h4>\n<p style=\"text-align: justify;\">Um erro de argumento no Excel geralmente ocorre quando uma fun\u00e7\u00e3o\/f\u00f3rmula recebe argumentos adicionais do que pode suportar.<\/p>\n<h4 style=\"text-align: left;\"><strong>Onde fica a caixa de argumentos no Excel?<\/strong><\/h4>\n<p style=\"text-align: justify;\">A caixa de argumentos no Excel est\u00e1 localizada na guia F\u00f3rmulas da faixa de op\u00e7\u00f5es.<\/p>\n<h4 style=\"text-align: left;\"><strong>Como adicionar argumentos no Excel?<\/strong><\/h4>\n<p style=\"text-align: justify;\">Para inserir rapidamente os argumentos de uma fun\u00e7\u00e3o, voc\u00ea precisa abrir o Editor VBA e digitar =, o nome da fun\u00e7\u00e3o &gt;&gt; Ctrl + A. O Microsoft Excel abre a caixa de di\u00e1logo Argumentos da Fun\u00e7\u00e3o para adicionar os argumentos necess\u00e1rios.<\/p>\n<h4 style=\"text-align: left;\"><strong>Quais s\u00e3o os tr\u00eas argumentos de uma fun\u00e7\u00e3o de banco de dados do Excel?<\/strong><\/h4>\n<p style=\"text-align: justify;\">Os tr\u00eas argumentos de uma fun\u00e7\u00e3o de banco de dados do Excel s\u00e3o: banco de dados, campo e crit\u00e9rios.<\/p>\n<h4 style=\"text-align: left;\"><strong>Quantos argumentos de entrada s\u00e3o permitidos pela fun\u00e7\u00e3o &#8220;ou&#8221; no Excel?<\/strong><\/h4>\n<p style=\"text-align: justify;\">255 condi\u00e7\u00f5es e argumentos de entrada s\u00e3o permitidos pela fun\u00e7\u00e3o &#8220;ou&#8221; no Excel.<\/p>\n<h2 style=\"text-align: left;\"><strong>Conclus\u00e3o<\/strong><\/h2>\n<p style=\"text-align: justify;\">O erro &#8220;<strong>compilar: argumento n\u00e3o opcional ao chamar a fun\u00e7\u00e3o<\/strong>&#8221; pode incomod\u00e1-lo e dificultar seu trabalho. Mas voc\u00ea n\u00e3o precisa se preocupar, pois abordei as melhores solu\u00e7\u00f5es neste artigo para solucion\u00e1-lo.<\/p>\n<p style=\"text-align: justify;\">No entanto, se essa mensagem de aviso ocorrer devido \u00e0 corrup\u00e7\u00e3o de arquivo, voc\u00ea pode tentar o Software de Reparo do Excel para corrigir um documento corrompido do Excel. A melhor parte desta ferramenta \u00e9 que ela pode ser baixada para uma vers\u00e3o demo gratuita para verificar e visualizar os objetos da pasta de trabalho.<\/p>\n<p style=\"text-align: justify;\">Obrigado pela leitura\u2026!<\/p>\n<br><center><a href='https:\/\/pt.repairmsexcel.com\/blog\/livre-baixar-para-win' target='_blank'><img class='pt-cta-729' src='https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/08\/729x120-pt.png' \/><\/a><\/center><br>\n\n<div style=\"font-size: 0px; height: 0px; line-height: 0px; margin: 0; padding: 0; clear: both;\"><\/div>","protected":false},"excerpt":{"rendered":"<p>Ao executar macros VBA no MS Excel, voc\u00ea pode receber a famosa mensagem de aviso \u201cCompile error: Argument not optional.\u201d &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"Excel Compile Error Argument Not Optional CORRE\u00c7\u00c3O \u2013 Pare a falha!\" class=\"read-more button\" href=\"https:\/\/pt.repairmsexcel.com\/blog\/erro-de-compilacao-do-excel-argumento-nao-opcional#more-5888\" aria-label=\"Read more about Excel Compile Error Argument Not Optional CORRE\u00c7\u00c3O \u2013 Pare a falha!\">Read more<\/a><\/p>\n","protected":false},"author":2,"featured_media":5894,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[694],"tags":[1871],"class_list":["post-5888","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-erros","tag-erro-de-compilacao-argumento-nao-opcional","resize-featured-image"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Excel Compile Error Argument Not Optional CORRE\u00c7\u00c3O \u2013 Pare a falha!<\/title>\n<meta name=\"description\" content=\"Erro de compila\u00e7\u00e3o do Excel: Argumento n\u00e3o opcional pode ser frustrante, mas n\u00e3o se preocupe: neste blog, mostrarei exatamente como corrigir esse erro passo a passo.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/pt.repairmsexcel.com\/blog\/erro-de-compilacao-do-excel-argumento-nao-opcional\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel Compile Error Argument Not Optional CORRE\u00c7\u00c3O \u2013 Pare a falha!\" \/>\n<meta property=\"og:description\" content=\"Erro de compila\u00e7\u00e3o do Excel: Argumento n\u00e3o opcional pode ser frustrante, mas n\u00e3o se preocupe: neste blog, mostrarei exatamente como corrigir esse erro passo a passo.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/pt.repairmsexcel.com\/blog\/erro-de-compilacao-do-excel-argumento-nao-opcional\" \/>\n<meta property=\"og:site_name\" content=\"Excel Arquivo Reparar Blog\" \/>\n<meta property=\"article:published_time\" content=\"2025-09-26T08:11:20+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2025\/09\/Excel-Compile-Error-Argument-Not-Optional-FIX.png\" \/>\n\t<meta property=\"og:image:width\" content=\"550\" \/>\n\t<meta property=\"og:image:height\" content=\"310\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Margret\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@https:\/\/twitter.com\/margret1_arthur\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Margret\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/erro-de-compilacao-do-excel-argumento-nao-opcional#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/erro-de-compilacao-do-excel-argumento-nao-opcional\"},\"author\":{\"name\":\"Margret\",\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/#\\\/schema\\\/person\\\/86e315631c24121ea37981cd8f9753ca\"},\"headline\":\"Excel Compile Error Argument Not Optional CORRE\u00c7\u00c3O \u2013 Pare a falha!\",\"datePublished\":\"2025-09-26T08:11:20+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/erro-de-compilacao-do-excel-argumento-nao-opcional\"},\"wordCount\":1080,\"publisher\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/erro-de-compilacao-do-excel-argumento-nao-opcional#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2025\\\/09\\\/Excel-Compile-Error-Argument-Not-Optional-FIX.png\",\"keywords\":[\"Erro de compila\u00e7\u00e3o: Argumento n\u00e3o opcional\"],\"articleSection\":[\"Excel erros\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/erro-de-compilacao-do-excel-argumento-nao-opcional\",\"url\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/erro-de-compilacao-do-excel-argumento-nao-opcional\",\"name\":\"Excel Compile Error Argument Not Optional CORRE\u00c7\u00c3O \u2013 Pare a falha!\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/erro-de-compilacao-do-excel-argumento-nao-opcional#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/erro-de-compilacao-do-excel-argumento-nao-opcional#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2025\\\/09\\\/Excel-Compile-Error-Argument-Not-Optional-FIX.png\",\"datePublished\":\"2025-09-26T08:11:20+00:00\",\"description\":\"Erro de compila\u00e7\u00e3o do Excel: Argumento n\u00e3o opcional pode ser frustrante, mas n\u00e3o se preocupe: neste blog, mostrarei exatamente como corrigir esse erro passo a passo.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/erro-de-compilacao-do-excel-argumento-nao-opcional#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/erro-de-compilacao-do-excel-argumento-nao-opcional\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/erro-de-compilacao-do-excel-argumento-nao-opcional#primaryimage\",\"url\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2025\\\/09\\\/Excel-Compile-Error-Argument-Not-Optional-FIX.png\",\"contentUrl\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2025\\\/09\\\/Excel-Compile-Error-Argument-Not-Optional-FIX.png\",\"width\":550,\"height\":310},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/erro-de-compilacao-do-excel-argumento-nao-opcional#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel Compile Error Argument Not Optional CORRE\u00c7\u00c3O \u2013 Pare a falha!\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/\",\"name\":\"Excel Arquivo Reparar Blog\",\"description\":\"Obter Dicas, Truques e Corre\u00e7\u00f5es por MS Excel Problemas\",\"publisher\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/#organization\",\"name\":\"Excel Arquivo Reparar\",\"url\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/06\\\/repairmsexcel.com-logo.png\",\"contentUrl\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/06\\\/repairmsexcel.com-logo.png\",\"width\":350,\"height\":70,\"caption\":\"Excel Arquivo Reparar\"},\"image\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/#\\\/schema\\\/person\\\/86e315631c24121ea37981cd8f9753ca\",\"name\":\"Margret\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ea29aef135486ebd58839d5510cb4413e8e5d6bbad7d2e01f4c06666b206df19?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ea29aef135486ebd58839d5510cb4413e8e5d6bbad7d2e01f4c06666b206df19?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ea29aef135486ebd58839d5510cb4413e8e5d6bbad7d2e01f4c06666b206df19?s=96&d=mm&r=g\",\"caption\":\"Margret\"},\"description\":\"Margret Arthur \u00e9 um empreendedor e especialista em marketing de conte\u00fado. Ela escreve blogs t\u00e9cnicos e conhecimentos sobre MS Office, Excel e outros assuntos t\u00e9cnicos. Dela arte distinta de apresentar informa\u00e7\u00f5es t\u00e9cnicas em linguagem f\u00e1cil de entender \u00e9 muito impressionante. Quando n\u00e3o est\u00e1 escrevendo, ela adora viagens n\u00e3o planejadas.\",\"sameAs\":[\"https:\\\/\\\/www.linkedin.com\\\/in\\\/margret-arthur-2545b6195\\\/\",\"https:\\\/\\\/x.com\\\/https:\\\/\\\/twitter.com\\\/margret1_arthur\"],\"url\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/author\\\/margret\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel Compile Error Argument Not Optional CORRE\u00c7\u00c3O \u2013 Pare a falha!","description":"Erro de compila\u00e7\u00e3o do Excel: Argumento n\u00e3o opcional pode ser frustrante, mas n\u00e3o se preocupe: neste blog, mostrarei exatamente como corrigir esse erro passo a passo.","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:\/\/pt.repairmsexcel.com\/blog\/erro-de-compilacao-do-excel-argumento-nao-opcional","og_locale":"en_US","og_type":"article","og_title":"Excel Compile Error Argument Not Optional CORRE\u00c7\u00c3O \u2013 Pare a falha!","og_description":"Erro de compila\u00e7\u00e3o do Excel: Argumento n\u00e3o opcional pode ser frustrante, mas n\u00e3o se preocupe: neste blog, mostrarei exatamente como corrigir esse erro passo a passo.","og_url":"https:\/\/pt.repairmsexcel.com\/blog\/erro-de-compilacao-do-excel-argumento-nao-opcional","og_site_name":"Excel Arquivo Reparar Blog","article_published_time":"2025-09-26T08:11:20+00:00","og_image":[{"width":550,"height":310,"url":"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2025\/09\/Excel-Compile-Error-Argument-Not-Optional-FIX.png","type":"image\/png"}],"author":"Margret","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/twitter.com\/margret1_arthur","twitter_misc":{"Written by":"Margret","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/pt.repairmsexcel.com\/blog\/erro-de-compilacao-do-excel-argumento-nao-opcional#article","isPartOf":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/erro-de-compilacao-do-excel-argumento-nao-opcional"},"author":{"name":"Margret","@id":"https:\/\/pt.repairmsexcel.com\/blog\/#\/schema\/person\/86e315631c24121ea37981cd8f9753ca"},"headline":"Excel Compile Error Argument Not Optional CORRE\u00c7\u00c3O \u2013 Pare a falha!","datePublished":"2025-09-26T08:11:20+00:00","mainEntityOfPage":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/erro-de-compilacao-do-excel-argumento-nao-opcional"},"wordCount":1080,"publisher":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/#organization"},"image":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/erro-de-compilacao-do-excel-argumento-nao-opcional#primaryimage"},"thumbnailUrl":"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2025\/09\/Excel-Compile-Error-Argument-Not-Optional-FIX.png","keywords":["Erro de compila\u00e7\u00e3o: Argumento n\u00e3o opcional"],"articleSection":["Excel erros"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/pt.repairmsexcel.com\/blog\/erro-de-compilacao-do-excel-argumento-nao-opcional","url":"https:\/\/pt.repairmsexcel.com\/blog\/erro-de-compilacao-do-excel-argumento-nao-opcional","name":"Excel Compile Error Argument Not Optional CORRE\u00c7\u00c3O \u2013 Pare a falha!","isPartOf":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/erro-de-compilacao-do-excel-argumento-nao-opcional#primaryimage"},"image":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/erro-de-compilacao-do-excel-argumento-nao-opcional#primaryimage"},"thumbnailUrl":"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2025\/09\/Excel-Compile-Error-Argument-Not-Optional-FIX.png","datePublished":"2025-09-26T08:11:20+00:00","description":"Erro de compila\u00e7\u00e3o do Excel: Argumento n\u00e3o opcional pode ser frustrante, mas n\u00e3o se preocupe: neste blog, mostrarei exatamente como corrigir esse erro passo a passo.","breadcrumb":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/erro-de-compilacao-do-excel-argumento-nao-opcional#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/pt.repairmsexcel.com\/blog\/erro-de-compilacao-do-excel-argumento-nao-opcional"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/pt.repairmsexcel.com\/blog\/erro-de-compilacao-do-excel-argumento-nao-opcional#primaryimage","url":"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2025\/09\/Excel-Compile-Error-Argument-Not-Optional-FIX.png","contentUrl":"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2025\/09\/Excel-Compile-Error-Argument-Not-Optional-FIX.png","width":550,"height":310},{"@type":"BreadcrumbList","@id":"https:\/\/pt.repairmsexcel.com\/blog\/erro-de-compilacao-do-excel-argumento-nao-opcional#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/pt.repairmsexcel.com\/blog"},{"@type":"ListItem","position":2,"name":"Excel Compile Error Argument Not Optional CORRE\u00c7\u00c3O \u2013 Pare a falha!"}]},{"@type":"WebSite","@id":"https:\/\/pt.repairmsexcel.com\/blog\/#website","url":"https:\/\/pt.repairmsexcel.com\/blog\/","name":"Excel Arquivo Reparar Blog","description":"Obter Dicas, Truques e Corre\u00e7\u00f5es por MS Excel Problemas","publisher":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/pt.repairmsexcel.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/pt.repairmsexcel.com\/blog\/#organization","name":"Excel Arquivo Reparar","url":"https:\/\/pt.repairmsexcel.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/pt.repairmsexcel.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/06\/repairmsexcel.com-logo.png","contentUrl":"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/06\/repairmsexcel.com-logo.png","width":350,"height":70,"caption":"Excel Arquivo Reparar"},"image":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/pt.repairmsexcel.com\/blog\/#\/schema\/person\/86e315631c24121ea37981cd8f9753ca","name":"Margret","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/ea29aef135486ebd58839d5510cb4413e8e5d6bbad7d2e01f4c06666b206df19?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/ea29aef135486ebd58839d5510cb4413e8e5d6bbad7d2e01f4c06666b206df19?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ea29aef135486ebd58839d5510cb4413e8e5d6bbad7d2e01f4c06666b206df19?s=96&d=mm&r=g","caption":"Margret"},"description":"Margret Arthur \u00e9 um empreendedor e especialista em marketing de conte\u00fado. Ela escreve blogs t\u00e9cnicos e conhecimentos sobre MS Office, Excel e outros assuntos t\u00e9cnicos. Dela arte distinta de apresentar informa\u00e7\u00f5es t\u00e9cnicas em linguagem f\u00e1cil de entender \u00e9 muito impressionante. Quando n\u00e3o est\u00e1 escrevendo, ela adora viagens n\u00e3o planejadas.","sameAs":["https:\/\/www.linkedin.com\/in\/margret-arthur-2545b6195\/","https:\/\/x.com\/https:\/\/twitter.com\/margret1_arthur"],"url":"https:\/\/pt.repairmsexcel.com\/blog\/author\/margret"}]}},"_links":{"self":[{"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts\/5888","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/comments?post=5888"}],"version-history":[{"count":1,"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts\/5888\/revisions"}],"predecessor-version":[{"id":5895,"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts\/5888\/revisions\/5895"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/media\/5894"}],"wp:attachment":[{"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/media?parent=5888"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/categories?post=5888"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/tags?post=5888"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}