{"id":1182,"date":"2023-11-11T23:53:59","date_gmt":"2023-11-11T23:53:59","guid":{"rendered":"https:\/\/saibam.com.br\/excel\/?p=1182"},"modified":"2023-11-11T23:55:38","modified_gmt":"2023-11-11T23:55:38","slug":"switch-alternar","status":"publish","type":"post","link":"https:\/\/saibam.com.br\/excel\/switch-alternar\/","title":{"rendered":"Switch &#8211; Alternar"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"1182\" class=\"elementor elementor-1182\">\n\t\t\t\t<div class=\"elementor-element elementor-element-0a99f6f e-flex e-con-boxed e-con e-parent\" data-id=\"0a99f6f\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-45ab332 elementor-icon-list--layout-inline elementor-align-center elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"45ab332\" data-element_type=\"widget\" data-widget_type=\"icon-list.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<ul class=\"elementor-icon-list-items elementor-inline-items\">\n\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item elementor-inline-item\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/saibam.com.br\/\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-home\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">Home<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item elementor-inline-item\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/saibam.com.br\/excel\/blog\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-blog\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">Blog<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item elementor-inline-item\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/saibam.com.br\/excel\/contato\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fab fa-contao\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">Contato<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item elementor-inline-item\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/saibam.com.br\/excel\/sobre\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"far fa-laugh\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">Sobre<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item elementor-inline-item\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/saibam.com.br\/excel\/pesquisar-no-site\/\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-search\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">Pesquisar<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t<\/ul>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-f9e9804 e-flex e-con-boxed e-con e-child\" data-id=\"f9e9804\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-2dfaff3 elementor-widget elementor-widget-heading\" data-id=\"2dfaff3\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Fun\u00e7\u00e3o Switch em VBA<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-2f51315 e-flex e-con-boxed e-con e-parent\" data-id=\"2f51315\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-7f4fa0a elementor-widget elementor-widget-text-editor\" data-id=\"7f4fa0a\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><br \/><br \/><br \/><br \/><br \/><br \/><\/p><h1>Descri\u00e7\u00e3o<\/h1><p>A fun\u00e7\u00e3o <code>Switch<\/code> em VBA \u00e9 usada para simplificar express\u00f5es condicionais que envolvem m\u00faltiplas op\u00e7\u00f5es. Ela permite avaliar uma s\u00e9rie de condi\u00e7\u00f5es e retornar um valor com base na primeira condi\u00e7\u00e3o verdadeira encontrada.<\/p><h2>Exemplos de Uso:<\/h2><pre><code>\n    Function ClassificarNota(nota As Integer) As String\n        ClassificarNota = Switch(nota &gt;= 90, \"A\", nota &gt;= 80, \"B\", nota &gt;= 70, \"C\", nota &gt;= 60, \"D\", True, \"F\")\n    End Function\n    <\/code><\/pre><pre><code>\n    Function CalcularDesconto(total As Double) As Double\n        CalcularDesconto = total * Switch(total &gt;= 1000, 0.1, total &gt;= 500, 0.05, True, 0)\n    End Function\n    <\/code><\/pre><pre><code>\n    Sub Saudacao(periodo As String)\n        Dim mensagem As String\n        mensagem = Switch(periodo = \"manh\u00e3\", \"Bom dia!\", periodo = \"tarde\", \"Boa tarde!\", periodo = \"noite\", \"Boa noite!\")\n        MsgBox mensagem\n    End Sub\n    <\/code><\/pre><pre><code>\n    Sub VerificarDiaSemana(dia As String)\n        Dim mensagem As String\n        mensagem = Switch(dia = \"segunda\", \"In\u00edcio da semana\", dia = \"sexta\", \"Fim de semana\", True, \"Dia comum\")\n        MsgBox mensagem\n    End Sub\n    <\/code><\/pre><pre><code>\n    Function ValidarIdade(idade As Integer) As String\n        ValidarIdade = Switch(idade &lt; 0, \"Idade inv\u00e1lida\", idade &gt;= 18, \"Maior de idade\", idade &lt; 18, \"Menor de idade\")\n    End Function\n    <\/code><\/pre><h2>Descri\u00e7\u00e3o Detalhada:<\/h2><p>A fun\u00e7\u00e3o <code>Switch<\/code> em VBA \u00e9 uma ferramenta valiosa para simplificar express\u00f5es condicionais em que m\u00faltiplas op\u00e7\u00f5es devem ser avaliadas. Ela permite que voc\u00ea especifique uma s\u00e9rie de condi\u00e7\u00f5es e seus valores correspondentes, retornando o valor da primeira condi\u00e7\u00e3o verdadeira encontrada. Isso torna o c\u00f3digo mais conciso e leg\u00edvel, reduzindo a necessidade de aninhar v\u00e1rias estruturas condicionais. Os exemplos apresentados demonstram como utilizar a fun\u00e7\u00e3o <code>Switch<\/code> em situa\u00e7\u00f5es diversas, como classifica\u00e7\u00e3o de notas, c\u00e1lculo de descontos, sauda\u00e7\u00f5es com base no per\u00edodo do dia, verifica\u00e7\u00e3o do dia da semana e valida\u00e7\u00e3o de idade. Compreender e aplicar a fun\u00e7\u00e3o <code>Switch<\/code> no VBA aprimorar\u00e1 sua capacidade de criar c\u00f3digo eficiente e claro em suas macros e automa\u00e7\u00f5es.<\/p><p>\u00a0<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-731515c e-flex e-con-boxed e-con e-parent\" data-id=\"731515c\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-c340885 elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"c340885\" data-element_type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-b147a58 e-flex e-con-boxed e-con e-parent\" data-id=\"b147a58\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t<div class=\"elementor-element elementor-element-cf166ea e-con-full e-flex e-con e-child\" data-id=\"cf166ea\" data-element_type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-8a0667e elementor-icon-list--layout-traditional elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"8a0667e\" data-element_type=\"widget\" data-widget_type=\"icon-list.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<ul class=\"elementor-icon-list-items\">\n\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/saibam.com.br\/excel\/funcao-curdir-em-vba\/\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-check\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">Fun\u00e7\u00e3o CurDir em VBA <\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/saibam.com.br\/excel\/funcao-replace-em-vba\/\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fab fa-creative-commons-nd\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">Fun\u00e7\u00e3o Replace em VBA - Substituir<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/saibam.com.br\/excel\/funcao-formatdatetime-em-vba\/\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-globe-americas\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">Fun\u00e7\u00e3o FormatDateTime em VBA<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t<\/ul>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-57117f8 e-con-full e-flex e-con e-child\" data-id=\"57117f8\" data-element_type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-6305c7b elementor-icon-list--layout-traditional elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"6305c7b\" data-element_type=\"widget\" data-widget_type=\"icon-list.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<ul class=\"elementor-icon-list-items\">\n\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/saibam.com.br\/excel\/funcao-comand-em-vba\/\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-globe-africa\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">Fun\u00e7\u00e3o Comand em VBA - Comando<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/saibam.com.br\/excel\/funcao-hora-em-vba\/\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fab fa-wpforms\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">Fun\u00e7\u00e3o Hora VBA<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/saibam.com.br\/excel\/funcao-error-em-vba\/\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-hand-point-right\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">Fun\u00e7\u00e3o Error em VBA<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t<\/ul>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-b178054 e-flex e-con-boxed e-con e-parent\" data-id=\"b178054\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-3b2791f elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"3b2791f\" data-element_type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Home Blog Contato Sobre Pesquisar Fun\u00e7\u00e3o Switch em VBA Descri\u00e7\u00e3o A fun\u00e7\u00e3o Switch em VBA \u00e9 usada para simplificar express\u00f5es condicionais que envolvem m\u00faltiplas op\u00e7\u00f5es. Ela permite avaliar uma s\u00e9rie de condi\u00e7\u00f5es e retornar um valor com base na primeira condi\u00e7\u00e3o verdadeira encontrada. Exemplos de Uso: Function ClassificarNota(nota As Integer) As String ClassificarNota = Switch(nota &hellip; <a href=\"https:\/\/saibam.com.br\/excel\/switch-alternar\/\" class=\"more-link\">Continue reading <span class=\"screen-reader-text\">Switch &#8211; Alternar<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"tpgb_global_settings":"","footnotes":""},"categories":[5],"tags":[75,77,27,78,30,31,32,34,35,36,38,39,40,41,79,42,43,44,46,37,29,47,48,49,50,51,52,53,54,55,80,56,58,60,61,62,63,64,65,66,67,68,69,70,81,71,86,87,88,89,90,91,92,95,96,98,100,82,101,73,72,102,103,83,104,105,106,107,84,108,109,110,111,112,85,57,74,28,7,11,97,94],"class_list":["post-1182","post","type-post","status-publish","format-standard","hentry","category-funcoes","tag-abs","tag-atn","tag-conversao-de-texto-para-numero","tag-cos","tag-curdir","tag-data","tag-dateadd","tag-datediff","tag-datepart","tag-dateserial","tag-day","tag-doevents","tag-eof","tag-error","tag-exp","tag-fileattr","tag-filedatetime","tag-filelen","tag-freefile","tag-funcao-day","tag-funcao-val","tag-getattr","tag-getobject","tag-getsetting","tag-hora","tag-iif","tag-input","tag-inputbox","tag-instr","tag-instrrev","tag-int","tag-ipmt","tag-isarray","tag-isdate","tag-isempty","tag-ismissing","tag-isnull","tag-isobject","tag-join","tag-lbound","tag-lcase","tag-left","tag-loc","tag-lof","tag-log","tag-ltrim","tag-mid","tag-minute","tag-month","tag-monthname","tag-msgbox","tag-now","tag-nper","tag-pmt","tag-ppmt","tag-qbcolor","tag-right","tag-rnd","tag-round","tag-rtrim","tag-rtrim-e-trim","tag-second","tag-seek","tag-sgn","tag-shell","tag-space","tag-spc","tag-split","tag-sqr","tag-strcomp","tag-strconv","tag-string","tag-strreverse","tag-switch","tag-tan","tag-tir","tag-trim","tag-val","tag-vba","tag-visual-basic-for-applications","tag-vp","tag-vpl"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Switch - Alternar - Saibam<\/title>\n<meta name=\"description\" content=\"A fun\u00e7\u00e3o String em VBA \u00e9 extremamente \u00fatil para gerar strings que consistem em um \u00fanico caractere repetido v\u00e1rias vezes. \u00c9 frequentemente utilizada em formata\u00e7\u00e3o de texto, preenchimento de espa\u00e7os ou na cria\u00e7\u00e3o de padr\u00f5es de teste. Os exemplos providenciados acima demonstram a flexibilidade da fun\u00e7\u00e3o, desde a cria\u00e7\u00e3o de simples sequ\u00eancias de caracteres at\u00e9 seu uso em express\u00f5es mais complexas. A tabela fornece um resumo r\u00e1pido para refer\u00eancia futura. Aprender a utilizar a fun\u00e7\u00e3o String \u00e9 um passo importante para dominar a programa\u00e7\u00e3o em 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:\/\/saibam.com.br\/excel\/switch-alternar\/\" \/>\n<meta property=\"og:locale\" content=\"pt_PT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Switch - Alternar - Saibam\" \/>\n<meta property=\"og:description\" content=\"A fun\u00e7\u00e3o String em VBA \u00e9 extremamente \u00fatil para gerar strings que consistem em um \u00fanico caractere repetido v\u00e1rias vezes. \u00c9 frequentemente utilizada em formata\u00e7\u00e3o de texto, preenchimento de espa\u00e7os ou na cria\u00e7\u00e3o de padr\u00f5es de teste. Os exemplos providenciados acima demonstram a flexibilidade da fun\u00e7\u00e3o, desde a cria\u00e7\u00e3o de simples sequ\u00eancias de caracteres at\u00e9 seu uso em express\u00f5es mais complexas. A tabela fornece um resumo r\u00e1pido para refer\u00eancia futura. Aprender a utilizar a fun\u00e7\u00e3o String \u00e9 um passo importante para dominar a programa\u00e7\u00e3o em VBA\" \/>\n<meta property=\"og:url\" content=\"https:\/\/saibam.com.br\/excel\/switch-alternar\/\" \/>\n<meta property=\"og:site_name\" content=\"Saibam\" \/>\n<meta property=\"article:published_time\" content=\"2023-11-11T23:53:59+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-11T23:55:38+00:00\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tempo estimado de leitura\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/saibam.com.br\/excel\/switch-alternar\/\",\"url\":\"https:\/\/saibam.com.br\/excel\/switch-alternar\/\",\"name\":\"Switch - Alternar - Saibam\",\"isPartOf\":{\"@id\":\"https:\/\/saibam.com.br\/excel\/#website\"},\"datePublished\":\"2023-11-11T23:53:59+00:00\",\"dateModified\":\"2023-11-11T23:55:38+00:00\",\"author\":{\"@id\":\"https:\/\/saibam.com.br\/excel\/#\/schema\/person\/2833a41987f995bb8cbf7e711bdd7712\"},\"description\":\"A fun\u00e7\u00e3o String em VBA \u00e9 extremamente \u00fatil para gerar strings que consistem em um \u00fanico caractere repetido v\u00e1rias vezes. \u00c9 frequentemente utilizada em formata\u00e7\u00e3o de texto, preenchimento de espa\u00e7os ou na cria\u00e7\u00e3o de padr\u00f5es de teste. Os exemplos providenciados acima demonstram a flexibilidade da fun\u00e7\u00e3o, desde a cria\u00e7\u00e3o de simples sequ\u00eancias de caracteres at\u00e9 seu uso em express\u00f5es mais complexas. A tabela fornece um resumo r\u00e1pido para refer\u00eancia futura. Aprender a utilizar a fun\u00e7\u00e3o String \u00e9 um passo importante para dominar a programa\u00e7\u00e3o em VBA\",\"breadcrumb\":{\"@id\":\"https:\/\/saibam.com.br\/excel\/switch-alternar\/#breadcrumb\"},\"inLanguage\":\"pt-PT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/saibam.com.br\/excel\/switch-alternar\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/saibam.com.br\/excel\/switch-alternar\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"In\u00edcio\",\"item\":\"https:\/\/saibam.com.br\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Switch &#8211; Alternar\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/saibam.com.br\/excel\/#website\",\"url\":\"https:\/\/saibam.com.br\/excel\/\",\"name\":\"Saibam\",\"description\":\"Excel Macros VBA\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/saibam.com.br\/excel\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"pt-PT\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/saibam.com.br\/excel\/#\/schema\/person\/2833a41987f995bb8cbf7e711bdd7712\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@id\":\"https:\/\/saibam.com.br\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/814c3f56d09b0c5755ac3b2c200ae705288694cfce205a77aaa6142979dfe4aa?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/814c3f56d09b0c5755ac3b2c200ae705288694cfce205a77aaa6142979dfe4aa?s=96&d=mm&r=g\",\"caption\":\"admin\"},\"sameAs\":[\"https:\/\/saibam.com.br\/excel\"],\"url\":\"https:\/\/saibam.com.br\/excel\/author\/admin-2\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Switch - Alternar - Saibam","description":"A fun\u00e7\u00e3o String em VBA \u00e9 extremamente \u00fatil para gerar strings que consistem em um \u00fanico caractere repetido v\u00e1rias vezes. \u00c9 frequentemente utilizada em formata\u00e7\u00e3o de texto, preenchimento de espa\u00e7os ou na cria\u00e7\u00e3o de padr\u00f5es de teste. Os exemplos providenciados acima demonstram a flexibilidade da fun\u00e7\u00e3o, desde a cria\u00e7\u00e3o de simples sequ\u00eancias de caracteres at\u00e9 seu uso em express\u00f5es mais complexas. A tabela fornece um resumo r\u00e1pido para refer\u00eancia futura. Aprender a utilizar a fun\u00e7\u00e3o String \u00e9 um passo importante para dominar a programa\u00e7\u00e3o em 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:\/\/saibam.com.br\/excel\/switch-alternar\/","og_locale":"pt_PT","og_type":"article","og_title":"Switch - Alternar - Saibam","og_description":"A fun\u00e7\u00e3o String em VBA \u00e9 extremamente \u00fatil para gerar strings que consistem em um \u00fanico caractere repetido v\u00e1rias vezes. \u00c9 frequentemente utilizada em formata\u00e7\u00e3o de texto, preenchimento de espa\u00e7os ou na cria\u00e7\u00e3o de padr\u00f5es de teste. Os exemplos providenciados acima demonstram a flexibilidade da fun\u00e7\u00e3o, desde a cria\u00e7\u00e3o de simples sequ\u00eancias de caracteres at\u00e9 seu uso em express\u00f5es mais complexas. A tabela fornece um resumo r\u00e1pido para refer\u00eancia futura. Aprender a utilizar a fun\u00e7\u00e3o String \u00e9 um passo importante para dominar a programa\u00e7\u00e3o em VBA","og_url":"https:\/\/saibam.com.br\/excel\/switch-alternar\/","og_site_name":"Saibam","article_published_time":"2023-11-11T23:53:59+00:00","article_modified_time":"2023-11-11T23:55:38+00:00","author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"admin","Tempo estimado de leitura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/saibam.com.br\/excel\/switch-alternar\/","url":"https:\/\/saibam.com.br\/excel\/switch-alternar\/","name":"Switch - Alternar - Saibam","isPartOf":{"@id":"https:\/\/saibam.com.br\/excel\/#website"},"datePublished":"2023-11-11T23:53:59+00:00","dateModified":"2023-11-11T23:55:38+00:00","author":{"@id":"https:\/\/saibam.com.br\/excel\/#\/schema\/person\/2833a41987f995bb8cbf7e711bdd7712"},"description":"A fun\u00e7\u00e3o String em VBA \u00e9 extremamente \u00fatil para gerar strings que consistem em um \u00fanico caractere repetido v\u00e1rias vezes. \u00c9 frequentemente utilizada em formata\u00e7\u00e3o de texto, preenchimento de espa\u00e7os ou na cria\u00e7\u00e3o de padr\u00f5es de teste. Os exemplos providenciados acima demonstram a flexibilidade da fun\u00e7\u00e3o, desde a cria\u00e7\u00e3o de simples sequ\u00eancias de caracteres at\u00e9 seu uso em express\u00f5es mais complexas. A tabela fornece um resumo r\u00e1pido para refer\u00eancia futura. Aprender a utilizar a fun\u00e7\u00e3o String \u00e9 um passo importante para dominar a programa\u00e7\u00e3o em VBA","breadcrumb":{"@id":"https:\/\/saibam.com.br\/excel\/switch-alternar\/#breadcrumb"},"inLanguage":"pt-PT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/saibam.com.br\/excel\/switch-alternar\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/saibam.com.br\/excel\/switch-alternar\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"In\u00edcio","item":"https:\/\/saibam.com.br\/excel\/"},{"@type":"ListItem","position":2,"name":"Switch &#8211; Alternar"}]},{"@type":"WebSite","@id":"https:\/\/saibam.com.br\/excel\/#website","url":"https:\/\/saibam.com.br\/excel\/","name":"Saibam","description":"Excel Macros VBA","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/saibam.com.br\/excel\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"pt-PT"},{"@type":"Person","@id":"https:\/\/saibam.com.br\/excel\/#\/schema\/person\/2833a41987f995bb8cbf7e711bdd7712","name":"admin","image":{"@type":"ImageObject","inLanguage":"pt-PT","@id":"https:\/\/saibam.com.br\/excel\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/814c3f56d09b0c5755ac3b2c200ae705288694cfce205a77aaa6142979dfe4aa?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/814c3f56d09b0c5755ac3b2c200ae705288694cfce205a77aaa6142979dfe4aa?s=96&d=mm&r=g","caption":"admin"},"sameAs":["https:\/\/saibam.com.br\/excel"],"url":"https:\/\/saibam.com.br\/excel\/author\/admin-2\/"}]}},"tpgb_featured_images":null,"tpgb_post_meta_info":{"get_date":"Novembro 11, 2023","get_modified_date":"Novembro 11, 2023","category_list":{"category":[{"term_id":5,"name":"Fun\u00e7\u00f5es","slug":"funcoes","term_group":0,"term_taxonomy_id":5,"taxonomy":"category","description":"","parent":0,"count":59,"filter":"raw"}],"post_tag":[{"term_id":75,"name":"Abs","slug":"abs","term_group":0,"term_taxonomy_id":75,"taxonomy":"post_tag","description":"","parent":0,"count":71,"filter":"raw"},{"term_id":77,"name":"Atn","slug":"atn","term_group":0,"term_taxonomy_id":77,"taxonomy":"post_tag","description":"","parent":0,"count":70,"filter":"raw"},{"term_id":27,"name":"Convers\u00e3o de Texto para N\u00famero","slug":"conversao-de-texto-para-numero","term_group":0,"term_taxonomy_id":27,"taxonomy":"post_tag","description":"","parent":0,"count":123,"filter":"raw"},{"term_id":78,"name":"Cos","slug":"cos","term_group":0,"term_taxonomy_id":78,"taxonomy":"post_tag","description":"","parent":0,"count":69,"filter":"raw"},{"term_id":30,"name":"CurDir","slug":"curdir","term_group":0,"term_taxonomy_id":30,"taxonomy":"post_tag","description":"","parent":0,"count":122,"filter":"raw"},{"term_id":31,"name":"data","slug":"data","term_group":0,"term_taxonomy_id":31,"taxonomy":"post_tag","description":"","parent":0,"count":121,"filter":"raw"},{"term_id":32,"name":"dateadd","slug":"dateadd","term_group":0,"term_taxonomy_id":32,"taxonomy":"post_tag","description":"","parent":0,"count":120,"filter":"raw"},{"term_id":34,"name":"datediff","slug":"datediff","term_group":0,"term_taxonomy_id":34,"taxonomy":"post_tag","description":"","parent":0,"count":119,"filter":"raw"},{"term_id":35,"name":"DatePart","slug":"datepart","term_group":0,"term_taxonomy_id":35,"taxonomy":"post_tag","description":"","parent":0,"count":118,"filter":"raw"},{"term_id":36,"name":"dateserial","slug":"dateserial","term_group":0,"term_taxonomy_id":36,"taxonomy":"post_tag","description":"","parent":0,"count":117,"filter":"raw"},{"term_id":38,"name":"day","slug":"day","term_group":0,"term_taxonomy_id":38,"taxonomy":"post_tag","description":"","parent":0,"count":115,"filter":"raw"},{"term_id":39,"name":"doevents","slug":"doevents","term_group":0,"term_taxonomy_id":39,"taxonomy":"post_tag","description":"","parent":0,"count":113,"filter":"raw"},{"term_id":40,"name":"EOF","slug":"eof","term_group":0,"term_taxonomy_id":40,"taxonomy":"post_tag","description":"","parent":0,"count":111,"filter":"raw"},{"term_id":41,"name":"error","slug":"error","term_group":0,"term_taxonomy_id":41,"taxonomy":"post_tag","description":"","parent":0,"count":110,"filter":"raw"},{"term_id":79,"name":"Exp","slug":"exp","term_group":0,"term_taxonomy_id":79,"taxonomy":"post_tag","description":"","parent":0,"count":68,"filter":"raw"},{"term_id":42,"name":"FileAttr","slug":"fileattr","term_group":0,"term_taxonomy_id":42,"taxonomy":"post_tag","description":"","parent":0,"count":109,"filter":"raw"},{"term_id":43,"name":"FileDateTime","slug":"filedatetime","term_group":0,"term_taxonomy_id":43,"taxonomy":"post_tag","description":"","parent":0,"count":108,"filter":"raw"},{"term_id":44,"name":"FileLen","slug":"filelen","term_group":0,"term_taxonomy_id":44,"taxonomy":"post_tag","description":"","parent":0,"count":107,"filter":"raw"},{"term_id":46,"name":"freefile","slug":"freefile","term_group":0,"term_taxonomy_id":46,"taxonomy":"post_tag","description":"","parent":0,"count":102,"filter":"raw"},{"term_id":37,"name":"fun\u00e7\u00e3o day","slug":"funcao-day","term_group":0,"term_taxonomy_id":37,"taxonomy":"post_tag","description":"","parent":0,"count":115,"filter":"raw"},{"term_id":29,"name":"Fun\u00e7\u00e3o Val","slug":"funcao-val","term_group":0,"term_taxonomy_id":29,"taxonomy":"post_tag","description":"","parent":0,"count":123,"filter":"raw"},{"term_id":47,"name":"GetAttr","slug":"getattr","term_group":0,"term_taxonomy_id":47,"taxonomy":"post_tag","description":"","parent":0,"count":99,"filter":"raw"},{"term_id":48,"name":"GetObject","slug":"getobject","term_group":0,"term_taxonomy_id":48,"taxonomy":"post_tag","description":"","parent":0,"count":98,"filter":"raw"},{"term_id":49,"name":"GetSetting","slug":"getsetting","term_group":0,"term_taxonomy_id":49,"taxonomy":"post_tag","description":"","parent":0,"count":97,"filter":"raw"},{"term_id":50,"name":"hora","slug":"hora","term_group":0,"term_taxonomy_id":50,"taxonomy":"post_tag","description":"","parent":0,"count":96,"filter":"raw"},{"term_id":51,"name":"iif","slug":"iif","term_group":0,"term_taxonomy_id":51,"taxonomy":"post_tag","description":"","parent":0,"count":95,"filter":"raw"},{"term_id":52,"name":"Input","slug":"input","term_group":0,"term_taxonomy_id":52,"taxonomy":"post_tag","description":"","parent":0,"count":94,"filter":"raw"},{"term_id":53,"name":"InputBox","slug":"inputbox","term_group":0,"term_taxonomy_id":53,"taxonomy":"post_tag","description":"","parent":0,"count":93,"filter":"raw"},{"term_id":54,"name":"InStr","slug":"instr","term_group":0,"term_taxonomy_id":54,"taxonomy":"post_tag","description":"","parent":0,"count":92,"filter":"raw"},{"term_id":55,"name":"InStrRev","slug":"instrrev","term_group":0,"term_taxonomy_id":55,"taxonomy":"post_tag","description":"","parent":0,"count":91,"filter":"raw"},{"term_id":80,"name":"Int","slug":"int","term_group":0,"term_taxonomy_id":80,"taxonomy":"post_tag","description":"","parent":0,"count":67,"filter":"raw"},{"term_id":56,"name":"IPmt","slug":"ipmt","term_group":0,"term_taxonomy_id":56,"taxonomy":"post_tag","description":"","parent":0,"count":90,"filter":"raw"},{"term_id":58,"name":"IsArray","slug":"isarray","term_group":0,"term_taxonomy_id":58,"taxonomy":"post_tag","description":"","parent":0,"count":88,"filter":"raw"},{"term_id":60,"name":"IsDate","slug":"isdate","term_group":0,"term_taxonomy_id":60,"taxonomy":"post_tag","description":"","parent":0,"count":87,"filter":"raw"},{"term_id":61,"name":"IsEmpty","slug":"isempty","term_group":0,"term_taxonomy_id":61,"taxonomy":"post_tag","description":"","parent":0,"count":86,"filter":"raw"},{"term_id":62,"name":"IsMissing","slug":"ismissing","term_group":0,"term_taxonomy_id":62,"taxonomy":"post_tag","description":"","parent":0,"count":84,"filter":"raw"},{"term_id":63,"name":"IsNull","slug":"isnull","term_group":0,"term_taxonomy_id":63,"taxonomy":"post_tag","description":"","parent":0,"count":83,"filter":"raw"},{"term_id":64,"name":"IsObject","slug":"isobject","term_group":0,"term_taxonomy_id":64,"taxonomy":"post_tag","description":"","parent":0,"count":81,"filter":"raw"},{"term_id":65,"name":"Join","slug":"join","term_group":0,"term_taxonomy_id":65,"taxonomy":"post_tag","description":"","parent":0,"count":80,"filter":"raw"},{"term_id":66,"name":"LBound","slug":"lbound","term_group":0,"term_taxonomy_id":66,"taxonomy":"post_tag","description":"","parent":0,"count":79,"filter":"raw"},{"term_id":67,"name":"LCase","slug":"lcase","term_group":0,"term_taxonomy_id":67,"taxonomy":"post_tag","description":"","parent":0,"count":78,"filter":"raw"},{"term_id":68,"name":"Left","slug":"left","term_group":0,"term_taxonomy_id":68,"taxonomy":"post_tag","description":"","parent":0,"count":77,"filter":"raw"},{"term_id":69,"name":"LOC","slug":"loc","term_group":0,"term_taxonomy_id":69,"taxonomy":"post_tag","description":"","parent":0,"count":76,"filter":"raw"},{"term_id":70,"name":"LOF","slug":"lof","term_group":0,"term_taxonomy_id":70,"taxonomy":"post_tag","description":"","parent":0,"count":75,"filter":"raw"},{"term_id":81,"name":"Log","slug":"log","term_group":0,"term_taxonomy_id":81,"taxonomy":"post_tag","description":"","parent":0,"count":65,"filter":"raw"},{"term_id":71,"name":"LTrim","slug":"ltrim","term_group":0,"term_taxonomy_id":71,"taxonomy":"post_tag","description":"","parent":0,"count":74,"filter":"raw"},{"term_id":86,"name":"MID","slug":"mid","term_group":0,"term_taxonomy_id":86,"taxonomy":"post_tag","description":"","parent":0,"count":59,"filter":"raw"},{"term_id":87,"name":"Minute","slug":"minute","term_group":0,"term_taxonomy_id":87,"taxonomy":"post_tag","description":"","parent":0,"count":58,"filter":"raw"},{"term_id":88,"name":"Month","slug":"month","term_group":0,"term_taxonomy_id":88,"taxonomy":"post_tag","description":"","parent":0,"count":56,"filter":"raw"},{"term_id":89,"name":"MonthName","slug":"monthname","term_group":0,"term_taxonomy_id":89,"taxonomy":"post_tag","description":"","parent":0,"count":55,"filter":"raw"},{"term_id":90,"name":"MsgBox","slug":"msgbox","term_group":0,"term_taxonomy_id":90,"taxonomy":"post_tag","description":"","parent":0,"count":54,"filter":"raw"},{"term_id":91,"name":"Now","slug":"now","term_group":0,"term_taxonomy_id":91,"taxonomy":"post_tag","description":"","parent":0,"count":53,"filter":"raw"},{"term_id":92,"name":"NPer","slug":"nper","term_group":0,"term_taxonomy_id":92,"taxonomy":"post_tag","description":"","parent":0,"count":52,"filter":"raw"},{"term_id":95,"name":"Pmt","slug":"pmt","term_group":0,"term_taxonomy_id":95,"taxonomy":"post_tag","description":"","parent":0,"count":50,"filter":"raw"},{"term_id":96,"name":"PPmt","slug":"ppmt","term_group":0,"term_taxonomy_id":96,"taxonomy":"post_tag","description":"","parent":0,"count":49,"filter":"raw"},{"term_id":98,"name":"QBColor","slug":"qbcolor","term_group":0,"term_taxonomy_id":98,"taxonomy":"post_tag","description":"","parent":0,"count":47,"filter":"raw"},{"term_id":100,"name":"Right","slug":"right","term_group":0,"term_taxonomy_id":100,"taxonomy":"post_tag","description":"","parent":0,"count":44,"filter":"raw"},{"term_id":82,"name":"Rnd","slug":"rnd","term_group":0,"term_taxonomy_id":82,"taxonomy":"post_tag","description":"","parent":0,"count":64,"filter":"raw"},{"term_id":101,"name":"Round","slug":"round","term_group":0,"term_taxonomy_id":101,"taxonomy":"post_tag","description":"","parent":0,"count":43,"filter":"raw"},{"term_id":73,"name":"rtrim","slug":"rtrim","term_group":0,"term_taxonomy_id":73,"taxonomy":"post_tag","description":"","parent":0,"count":74,"filter":"raw"},{"term_id":72,"name":"RTrim e Trim","slug":"rtrim-e-trim","term_group":0,"term_taxonomy_id":72,"taxonomy":"post_tag","description":"","parent":0,"count":74,"filter":"raw"},{"term_id":102,"name":"Second","slug":"second","term_group":0,"term_taxonomy_id":102,"taxonomy":"post_tag","description":"","parent":0,"count":42,"filter":"raw"},{"term_id":103,"name":"Seek","slug":"seek","term_group":0,"term_taxonomy_id":103,"taxonomy":"post_tag","description":"","parent":0,"count":41,"filter":"raw"},{"term_id":83,"name":"Sgn","slug":"sgn","term_group":0,"term_taxonomy_id":83,"taxonomy":"post_tag","description":"","parent":0,"count":63,"filter":"raw"},{"term_id":104,"name":"Shell","slug":"shell","term_group":0,"term_taxonomy_id":104,"taxonomy":"post_tag","description":"","parent":0,"count":40,"filter":"raw"},{"term_id":105,"name":"Space","slug":"space","term_group":0,"term_taxonomy_id":105,"taxonomy":"post_tag","description":"","parent":0,"count":39,"filter":"raw"},{"term_id":106,"name":"Spc","slug":"spc","term_group":0,"term_taxonomy_id":106,"taxonomy":"post_tag","description":"","parent":0,"count":38,"filter":"raw"},{"term_id":107,"name":"Split","slug":"split","term_group":0,"term_taxonomy_id":107,"taxonomy":"post_tag","description":"","parent":0,"count":37,"filter":"raw"},{"term_id":84,"name":"Sqr","slug":"sqr","term_group":0,"term_taxonomy_id":84,"taxonomy":"post_tag","description":"","parent":0,"count":61,"filter":"raw"},{"term_id":108,"name":"StrComp","slug":"strcomp","term_group":0,"term_taxonomy_id":108,"taxonomy":"post_tag","description":"","parent":0,"count":36,"filter":"raw"},{"term_id":109,"name":"StrConv","slug":"strconv","term_group":0,"term_taxonomy_id":109,"taxonomy":"post_tag","description":"","parent":0,"count":35,"filter":"raw"},{"term_id":110,"name":"String","slug":"string","term_group":0,"term_taxonomy_id":110,"taxonomy":"post_tag","description":"","parent":0,"count":34,"filter":"raw"},{"term_id":111,"name":"StrReverse","slug":"strreverse","term_group":0,"term_taxonomy_id":111,"taxonomy":"post_tag","description":"","parent":0,"count":33,"filter":"raw"},{"term_id":112,"name":"Switch","slug":"switch","term_group":0,"term_taxonomy_id":112,"taxonomy":"post_tag","description":"","parent":0,"count":32,"filter":"raw"},{"term_id":85,"name":"Tan","slug":"tan","term_group":0,"term_taxonomy_id":85,"taxonomy":"post_tag","description":"","parent":0,"count":60,"filter":"raw"},{"term_id":57,"name":"TIR","slug":"tir","term_group":0,"term_taxonomy_id":57,"taxonomy":"post_tag","description":"","parent":0,"count":89,"filter":"raw"},{"term_id":74,"name":"trim","slug":"trim","term_group":0,"term_taxonomy_id":74,"taxonomy":"post_tag","description":"","parent":0,"count":74,"filter":"raw"},{"term_id":28,"name":"Val","slug":"val","term_group":0,"term_taxonomy_id":28,"taxonomy":"post_tag","description":"","parent":0,"count":123,"filter":"raw"},{"term_id":7,"name":"VBA","slug":"vba","term_group":0,"term_taxonomy_id":7,"taxonomy":"post_tag","description":"","parent":0,"count":129,"filter":"raw"},{"term_id":11,"name":"Visual Basic for Applications","slug":"visual-basic-for-applications","term_group":0,"term_taxonomy_id":11,"taxonomy":"post_tag","description":"","parent":0,"count":129,"filter":"raw"},{"term_id":97,"name":"VP","slug":"vp","term_group":0,"term_taxonomy_id":97,"taxonomy":"post_tag","description":"","parent":0,"count":48,"filter":"raw"},{"term_id":94,"name":"VPL","slug":"vpl","term_group":0,"term_taxonomy_id":94,"taxonomy":"post_tag","description":"","parent":0,"count":51,"filter":"raw"}],"post_format":false},"author_name":"admin","author_url":"https:\/\/saibam.com.br\/excel\/author\/admin-2\/","author_email":"admin@saibam.com.br","author_website":"https:\/\/saibam.com.br\/excel","author_description":"","author_facebook":"","author_twitter":"","author_instagram":"","author_role":["administrator"],"author_firstname":"","author_lastname":"","user_login":"Pizza","author_avatar":"<img alt='' src='https:\/\/secure.gravatar.com\/avatar\/814c3f56d09b0c5755ac3b2c200ae705288694cfce205a77aaa6142979dfe4aa?s=200&#038;d=mm&#038;r=g' srcset='https:\/\/secure.gravatar.com\/avatar\/814c3f56d09b0c5755ac3b2c200ae705288694cfce205a77aaa6142979dfe4aa?s=400&#038;d=mm&#038;r=g 2x' class='avatar avatar-200 photo' height='200' width='200' decoding='async'\/>","author_avatar_url":"https:\/\/secure.gravatar.com\/avatar\/814c3f56d09b0c5755ac3b2c200ae705288694cfce205a77aaa6142979dfe4aa?s=96&d=mm&r=g","comment_count":0,"post_likes":0,"post_views":0},"tpgb_post_category":{"category":"<a href=\"https:\/\/saibam.com.br\/excel\/category\/funcoes\/\" alt=\"Fun\u00e7\u00f5es\" class=\"category-funcoes\">Fun\u00e7\u00f5es<\/a> ","post_tag":"<a href=\"https:\/\/saibam.com.br\/excel\/tag\/abs\/\" alt=\"Abs\" class=\"post_tag-abs\">Abs<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/atn\/\" alt=\"Atn\" class=\"post_tag-atn\">Atn<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/conversao-de-texto-para-numero\/\" alt=\"Convers\u00e3o de Texto para N\u00famero\" class=\"post_tag-conversao-de-texto-para-numero\">Convers\u00e3o de Texto para N\u00famero<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/cos\/\" alt=\"Cos\" class=\"post_tag-cos\">Cos<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/curdir\/\" alt=\"CurDir\" class=\"post_tag-curdir\">CurDir<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/data\/\" alt=\"data\" class=\"post_tag-data\">data<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/dateadd\/\" alt=\"dateadd\" class=\"post_tag-dateadd\">dateadd<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/datediff\/\" alt=\"datediff\" class=\"post_tag-datediff\">datediff<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/datepart\/\" alt=\"DatePart\" class=\"post_tag-datepart\">DatePart<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/dateserial\/\" alt=\"dateserial\" class=\"post_tag-dateserial\">dateserial<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/day\/\" alt=\"day\" class=\"post_tag-day\">day<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/doevents\/\" alt=\"doevents\" class=\"post_tag-doevents\">doevents<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/eof\/\" alt=\"EOF\" class=\"post_tag-eof\">EOF<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/error\/\" alt=\"error\" class=\"post_tag-error\">error<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/exp\/\" alt=\"Exp\" class=\"post_tag-exp\">Exp<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/fileattr\/\" alt=\"FileAttr\" class=\"post_tag-fileattr\">FileAttr<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/filedatetime\/\" alt=\"FileDateTime\" class=\"post_tag-filedatetime\">FileDateTime<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/filelen\/\" alt=\"FileLen\" class=\"post_tag-filelen\">FileLen<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/freefile\/\" alt=\"freefile\" class=\"post_tag-freefile\">freefile<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/funcao-day\/\" alt=\"fun\u00e7\u00e3o day\" class=\"post_tag-funcao-day\">fun\u00e7\u00e3o day<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/funcao-val\/\" alt=\"Fun\u00e7\u00e3o Val\" class=\"post_tag-funcao-val\">Fun\u00e7\u00e3o Val<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/getattr\/\" alt=\"GetAttr\" class=\"post_tag-getattr\">GetAttr<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/getobject\/\" alt=\"GetObject\" class=\"post_tag-getobject\">GetObject<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/getsetting\/\" alt=\"GetSetting\" class=\"post_tag-getsetting\">GetSetting<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/hora\/\" alt=\"hora\" class=\"post_tag-hora\">hora<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/iif\/\" alt=\"iif\" class=\"post_tag-iif\">iif<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/input\/\" alt=\"Input\" class=\"post_tag-input\">Input<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/inputbox\/\" alt=\"InputBox\" class=\"post_tag-inputbox\">InputBox<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/instr\/\" alt=\"InStr\" class=\"post_tag-instr\">InStr<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/instrrev\/\" alt=\"InStrRev\" class=\"post_tag-instrrev\">InStrRev<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/int\/\" alt=\"Int\" class=\"post_tag-int\">Int<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/ipmt\/\" alt=\"IPmt\" class=\"post_tag-ipmt\">IPmt<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/isarray\/\" alt=\"IsArray\" class=\"post_tag-isarray\">IsArray<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/isdate\/\" alt=\"IsDate\" class=\"post_tag-isdate\">IsDate<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/isempty\/\" alt=\"IsEmpty\" class=\"post_tag-isempty\">IsEmpty<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/ismissing\/\" alt=\"IsMissing\" class=\"post_tag-ismissing\">IsMissing<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/isnull\/\" alt=\"IsNull\" class=\"post_tag-isnull\">IsNull<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/isobject\/\" alt=\"IsObject\" class=\"post_tag-isobject\">IsObject<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/join\/\" alt=\"Join\" class=\"post_tag-join\">Join<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/lbound\/\" alt=\"LBound\" class=\"post_tag-lbound\">LBound<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/lcase\/\" alt=\"LCase\" class=\"post_tag-lcase\">LCase<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/left\/\" alt=\"Left\" class=\"post_tag-left\">Left<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/loc\/\" alt=\"LOC\" class=\"post_tag-loc\">LOC<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/lof\/\" alt=\"LOF\" class=\"post_tag-lof\">LOF<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/log\/\" alt=\"Log\" class=\"post_tag-log\">Log<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/ltrim\/\" alt=\"LTrim\" class=\"post_tag-ltrim\">LTrim<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/mid\/\" alt=\"MID\" class=\"post_tag-mid\">MID<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/minute\/\" alt=\"Minute\" class=\"post_tag-minute\">Minute<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/month\/\" alt=\"Month\" class=\"post_tag-month\">Month<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/monthname\/\" alt=\"MonthName\" class=\"post_tag-monthname\">MonthName<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/msgbox\/\" alt=\"MsgBox\" class=\"post_tag-msgbox\">MsgBox<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/now\/\" alt=\"Now\" class=\"post_tag-now\">Now<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/nper\/\" alt=\"NPer\" class=\"post_tag-nper\">NPer<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/pmt\/\" alt=\"Pmt\" class=\"post_tag-pmt\">Pmt<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/ppmt\/\" alt=\"PPmt\" class=\"post_tag-ppmt\">PPmt<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/qbcolor\/\" alt=\"QBColor\" class=\"post_tag-qbcolor\">QBColor<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/right\/\" alt=\"Right\" class=\"post_tag-right\">Right<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/rnd\/\" alt=\"Rnd\" class=\"post_tag-rnd\">Rnd<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/round\/\" alt=\"Round\" class=\"post_tag-round\">Round<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/rtrim\/\" alt=\"rtrim\" class=\"post_tag-rtrim\">rtrim<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/rtrim-e-trim\/\" alt=\"RTrim e Trim\" class=\"post_tag-rtrim-e-trim\">RTrim e Trim<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/second\/\" alt=\"Second\" class=\"post_tag-second\">Second<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/seek\/\" alt=\"Seek\" class=\"post_tag-seek\">Seek<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/sgn\/\" alt=\"Sgn\" class=\"post_tag-sgn\">Sgn<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/shell\/\" alt=\"Shell\" class=\"post_tag-shell\">Shell<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/space\/\" alt=\"Space\" class=\"post_tag-space\">Space<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/spc\/\" alt=\"Spc\" class=\"post_tag-spc\">Spc<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/split\/\" alt=\"Split\" class=\"post_tag-split\">Split<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/sqr\/\" alt=\"Sqr\" class=\"post_tag-sqr\">Sqr<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/strcomp\/\" alt=\"StrComp\" class=\"post_tag-strcomp\">StrComp<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/strconv\/\" alt=\"StrConv\" class=\"post_tag-strconv\">StrConv<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/string\/\" alt=\"String\" class=\"post_tag-string\">String<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/strreverse\/\" alt=\"StrReverse\" class=\"post_tag-strreverse\">StrReverse<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/switch\/\" alt=\"Switch\" class=\"post_tag-switch\">Switch<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/tan\/\" alt=\"Tan\" class=\"post_tag-tan\">Tan<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/tir\/\" alt=\"TIR\" class=\"post_tag-tir\">TIR<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/trim\/\" alt=\"trim\" class=\"post_tag-trim\">trim<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/val\/\" alt=\"Val\" class=\"post_tag-val\">Val<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/vba\/\" alt=\"VBA\" class=\"post_tag-vba\">VBA<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/visual-basic-for-applications\/\" alt=\"Visual Basic for Applications\" class=\"post_tag-visual-basic-for-applications\">Visual Basic for Applications<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/vp\/\" alt=\"VP\" class=\"post_tag-vp\">VP<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/vpl\/\" alt=\"VPL\" class=\"post_tag-vpl\">VPL<\/a> "},"_links":{"self":[{"href":"https:\/\/saibam.com.br\/excel\/wp-json\/wp\/v2\/posts\/1182","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/saibam.com.br\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/saibam.com.br\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/saibam.com.br\/excel\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/saibam.com.br\/excel\/wp-json\/wp\/v2\/comments?post=1182"}],"version-history":[{"count":7,"href":"https:\/\/saibam.com.br\/excel\/wp-json\/wp\/v2\/posts\/1182\/revisions"}],"predecessor-version":[{"id":1189,"href":"https:\/\/saibam.com.br\/excel\/wp-json\/wp\/v2\/posts\/1182\/revisions\/1189"}],"wp:attachment":[{"href":"https:\/\/saibam.com.br\/excel\/wp-json\/wp\/v2\/media?parent=1182"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/saibam.com.br\/excel\/wp-json\/wp\/v2\/categories?post=1182"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/saibam.com.br\/excel\/wp-json\/wp\/v2\/tags?post=1182"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}