<?xml version='1.0' encoding='UTF-8'?><?xml-stylesheet href="http://www.blogger.com/styles/atom.css" type="text/css"?><feed xmlns='http://www.w3.org/2005/Atom' xmlns:openSearch='http://a9.com/-/spec/opensearch/1.1/' xmlns:georss='http://www.georss.org/georss' xmlns:thr='http://purl.org/syndication/thread/1.0' xmlns:gd='http://schemas.google.com/g/2005' gd:etag='W/&quot;D0YGRnY_eip7ImA9Wx5VFEQ.&quot;'><id>tag:blogger.com,1999:blog-4986120378873341104</id><updated>2010-10-07T20:45:27.842-03:00</updated><title>Blog sobre macros, planilhas, excel, tabelas dinâmicas, vba e afins</title><subtitle type='html'></subtitle><link rel='http://schemas.google.com/g/2005#feed' type='application/atom+xml' href='http://giovanedesouza.blogspot.com/feeds/posts/default'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/4986120378873341104/posts/default?redirect=false&amp;v=2'/><link rel='alternate' type='text/html' href='http://giovanedesouza.blogspot.com/'/><link rel='hub' href='http://pubsubhubbub.appspot.com/'/><author><name>Giovane</name><uri>http://www.blogger.com/profile/12175115829217489022</uri><email>giovanedsouza@yahoo.com.br</email></author><generator version='7.00' uri='http://www.blogger.com'>Blogger</generator><openSearch:totalResults>8</openSearch:totalResults><openSearch:startIndex>1</openSearch:startIndex><openSearch:itemsPerPage>25</openSearch:itemsPerPage><entry gd:etag='W/&quot;C08ERX0-eCp7ImA9Wx5VEk4.&quot;'><id>tag:blogger.com,1999:blog-4986120378873341104.post-5750282064939188889</id><published>2010-10-04T19:36:00.000-03:00</published><updated>2010-10-04T19:36:44.350-03:00</updated><app:edited xmlns:app='http://www.w3.org/2007/app'>2010-10-04T19:36:44.350-03:00</app:edited><category scheme='http://www.blogger.com/atom/ns#' term='cell counter'/><category scheme='http://www.blogger.com/atom/ns#' term='excel'/><category scheme='http://www.blogger.com/atom/ns#' term='contador de célula'/><category scheme='http://www.blogger.com/atom/ns#' term='planilha'/><category scheme='http://www.blogger.com/atom/ns#' term='macros'/><title>Contador de Células preenchidas</title><content type='html'>Olá Pessoal&lt;br /&gt;
&lt;br /&gt;
As &amp;nbsp;vezes precisamos de um contador simples pra ver quantas células estão preenchidas em uma coluna.&lt;br /&gt;
Se a coluna não tiver nenhuma célula vazia no meio dos dados esse contador funcionará perfeitamente.&lt;br /&gt;
&lt;br /&gt;
Vamos a ele:&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;span class="Apple-style-span" style="color: blue;"&gt;Sub contador()&lt;/span&gt;&lt;br /&gt;
&lt;span class="Apple-style-span" style="color: blue;"&gt;&lt;br /&gt;
&lt;/span&gt;&lt;br /&gt;
&lt;span class="Apple-style-span" style="color: blue;"&gt;Dim a As Integer 'integer só vai até 32767&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&amp;nbsp;&lt;span class="Apple-style-span" style="color: blue;"&gt;a = 1&lt;/span&gt; ' atribuir 1 para a variável para que possa ser iniciado&lt;br /&gt;
&lt;br /&gt;
&lt;span class="Apple-style-span" style="color: blue;"&gt;&amp;nbsp;&amp;nbsp;While Cells(1, a).Value &amp;lt;&amp;gt; ""&lt;/span&gt; ' esse código diz: enquando a célula x for diferente de vazia&lt;br /&gt;
&lt;span class="Apple-style-span" style="color: blue;"&gt;&amp;nbsp;&amp;nbsp; a = a + 1&lt;/span&gt; ' soma mais um na varíável que armazena o número de linhas(células)&lt;br /&gt;
&amp;nbsp;&lt;span class="Apple-style-span" style="color: blue;"&gt;&amp;nbsp;Wend&lt;/span&gt; ' final da instrução while&lt;br /&gt;
&amp;nbsp;&amp;nbsp; &lt;span class="Apple-style-span" style="color: blue;"&gt;a = a - 1&lt;/span&gt; ' pra descontar o primeiro valor acima&lt;br /&gt;
&lt;br /&gt;
&lt;span class="Apple-style-span" style="color: blue;"&gt;End Sub&lt;/span&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/4986120378873341104-5750282064939188889?l=giovanedesouza.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://giovanedesouza.blogspot.com/feeds/5750282064939188889/comments/default' title='Postar comentários'/><link rel='replies' type='text/html' href='http://giovanedesouza.blogspot.com/2010/10/contador-de-celulas-preenchidas.html#comment-form' title='0 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/4986120378873341104/posts/default/5750282064939188889?v=2'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/4986120378873341104/posts/default/5750282064939188889?v=2'/><link rel='alternate' type='text/html' href='http://giovanedesouza.blogspot.com/2010/10/contador-de-celulas-preenchidas.html' title='Contador de Células preenchidas'/><author><name>Giovane</name><uri>http://www.blogger.com/profile/12175115829217489022</uri><email>giovanedsouza@yahoo.com.br</email><gd:extendedProperty name='OpenSocialUserId' value='12409833617791306958'/></author><thr:total>0</thr:total></entry><entry gd:etag='W/&quot;C0YAQH44eCp7ImA9Wx5VEk4.&quot;'><id>tag:blogger.com,1999:blog-4986120378873341104.post-7799174944484356359</id><published>2010-10-04T19:25:00.000-03:00</published><updated>2010-10-04T19:25:41.030-03:00</updated><app:edited xmlns:app='http://www.w3.org/2007/app'>2010-10-04T19:25:41.030-03:00</app:edited><category scheme='http://www.blogger.com/atom/ns#' term='matriz'/><category scheme='http://www.blogger.com/atom/ns#' term='excel'/><category scheme='http://www.blogger.com/atom/ns#' term='planilha'/><category scheme='http://www.blogger.com/atom/ns#' term='macros'/><title>Matriz Simples</title><content type='html'>Olá&lt;br /&gt;
&lt;br /&gt;
Como havia comentado estou postando um código simples com o preenchimento de uma pequena matriz.&lt;br /&gt;
Isso serve para infinitas rotinas de trabalho em escritórios que manipulam muitas informações em excel ou mesmo em access.&lt;br /&gt;
&lt;br /&gt;
Vamos ao código:&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Sub Matriz()&lt;br /&gt;
&lt;br /&gt;
&lt;span class="Apple-style-span" style="color: blue;"&gt;Dim dados(2, 5) As Variant&lt;/span&gt; ' declarando a matriz com 2 colunas e 5 linhas(ou 10 posições 2x5)&lt;br /&gt;
&lt;span class="Apple-style-span" style="color: blue;"&gt;Dim a, b As Integer&lt;/span&gt; 'declarando as variáveis para o for&lt;br /&gt;
&lt;span class="Apple-style-span" style="color: blue;"&gt;Dim valor As Variant&amp;nbsp;&lt;/span&gt;' também pode ser string&lt;br /&gt;
&lt;br /&gt;
'usando este método primeiro as linhas são percorridas&lt;br /&gt;
'ou seja na primeira coluna ele varre todas as linhas e&lt;br /&gt;
'depois da 5ª célula ele passa para a segunda coluna&lt;br /&gt;
&lt;br /&gt;
&amp;nbsp;&lt;span class="Apple-style-span" style="color: blue;"&gt;For a = 1 To 2&lt;/span&gt; 'percorre as colunas&lt;br /&gt;
&amp;nbsp;&amp;nbsp;&lt;span class="Apple-style-span" style="color: blue;"&gt;For b = 1 To 5&lt;/span&gt; 'percorre as linhas&lt;br /&gt;
&amp;nbsp;&amp;nbsp; &lt;span class="Apple-style-span" style="color: blue;"&gt;valor = Cells(a, b).Value&lt;/span&gt; ' variável que armazena o resultado da célula&lt;br /&gt;
&amp;nbsp;&amp;nbsp; &amp;nbsp;&lt;span class="Apple-style-span" style="color: blue;"&gt;dados(a, b) = valor&amp;nbsp;&lt;/span&gt;' preenchendo a matriz com o valor da célula&lt;br /&gt;
&amp;nbsp;&lt;span class="Apple-style-span" style="color: blue;"&gt;&amp;nbsp;Next&lt;/span&gt;&lt;br /&gt;
&lt;span class="Apple-style-span" style="color: blue;"&gt;&amp;nbsp;Next&lt;/span&gt;&lt;br /&gt;
&lt;span class="Apple-style-span" style="color: blue;"&gt;End Sub&lt;/span&gt;&lt;br /&gt;
&lt;div&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div&gt;e Pronto. As variáveis são apenas exemplos que podem ser substituídas no código pela variável de sua preferência.&lt;/div&gt;&lt;div&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/4986120378873341104-7799174944484356359?l=giovanedesouza.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://giovanedesouza.blogspot.com/feeds/7799174944484356359/comments/default' title='Postar comentários'/><link rel='replies' type='text/html' href='http://giovanedesouza.blogspot.com/2010/10/matriz-simples.html#comment-form' title='0 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/4986120378873341104/posts/default/7799174944484356359?v=2'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/4986120378873341104/posts/default/7799174944484356359?v=2'/><link rel='alternate' type='text/html' href='http://giovanedesouza.blogspot.com/2010/10/matriz-simples.html' title='Matriz Simples'/><author><name>Giovane</name><uri>http://www.blogger.com/profile/12175115829217489022</uri><email>giovanedsouza@yahoo.com.br</email><gd:extendedProperty name='OpenSocialUserId' value='12409833617791306958'/></author><thr:total>0</thr:total></entry><entry gd:etag='W/&quot;CE8HSH49eSp7ImA9Wx5VEUg.&quot;'><id>tag:blogger.com,1999:blog-4986120378873341104.post-3526593758827985204</id><published>2010-10-03T21:40:00.000-03:00</published><updated>2010-10-03T21:40:39.061-03:00</updated><app:edited xmlns:app='http://www.w3.org/2007/app'>2010-10-03T21:40:39.061-03:00</app:edited><category scheme='http://www.blogger.com/atom/ns#' term='matriz'/><category scheme='http://www.blogger.com/atom/ns#' term='excel'/><category scheme='http://www.blogger.com/atom/ns#' term='vba'/><category scheme='http://www.blogger.com/atom/ns#' term='planilhas'/><category scheme='http://www.blogger.com/atom/ns#' term='macros'/><title>Matriz</title><content type='html'>Olá&lt;br /&gt;
&lt;br /&gt;
Nosso próximo post terá como assunto matrizes, que são essenciais para se fazer uma planilha automatizada funcionar bem. As matrizes servem para armazenar dados temporariamente para efetuarmos vários processamentos necessários no dia a dia de um escritório com várias rotinas de tratativas de relatórios em excel, ou mesmo quando manipulamos muitos dados.&lt;br /&gt;
&lt;br /&gt;
Não percam!!!!!!!!!!!!!!!&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/4986120378873341104-3526593758827985204?l=giovanedesouza.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://giovanedesouza.blogspot.com/feeds/3526593758827985204/comments/default' title='Postar comentários'/><link rel='replies' type='text/html' href='http://giovanedesouza.blogspot.com/2010/10/matriz.html#comment-form' title='0 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/4986120378873341104/posts/default/3526593758827985204?v=2'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/4986120378873341104/posts/default/3526593758827985204?v=2'/><link rel='alternate' type='text/html' href='http://giovanedesouza.blogspot.com/2010/10/matriz.html' title='Matriz'/><author><name>Giovane</name><uri>http://www.blogger.com/profile/12175115829217489022</uri><email>giovanedsouza@yahoo.com.br</email><gd:extendedProperty name='OpenSocialUserId' value='12409833617791306958'/></author><thr:total>0</thr:total></entry><entry gd:etag='W/&quot;DUAGRXo5fSp7ImA9Wx5VEUk.&quot;'><id>tag:blogger.com,1999:blog-4986120378873341104.post-6769684964274554538</id><published>2010-10-03T20:14:00.000-03:00</published><updated>2010-10-03T20:15:24.425-03:00</updated><app:edited xmlns:app='http://www.w3.org/2007/app'>2010-10-03T20:15:24.425-03:00</app:edited><category scheme='http://www.blogger.com/atom/ns#' term='célula em maiúsculo'/><category scheme='http://www.blogger.com/atom/ns#' term='excel'/><category scheme='http://www.blogger.com/atom/ns#' term='ucase'/><category scheme='http://www.blogger.com/atom/ns#' term='transforma em maúscula'/><category scheme='http://www.blogger.com/atom/ns#' term='macros'/><title>Transforma valor da célula em maiúscula</title><content type='html'>Olá&lt;br /&gt;
&lt;br /&gt;
Este código incrementa um laço for e coloca dentro dele a funcionalidade de transformar o conteúdo de cada célula em maiúsculo. Não podemos esquecer que quando queremos comparar dois valores é muito importante que os valores tenham o mesmo formato, não posso comparar minúscula com maiúscula ou vice-versa. Portanto segue um código bem interessante.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Sub maiuscula()&lt;br /&gt;
'&lt;br /&gt;
&amp;nbsp;Dim a, b As Integer&lt;br /&gt;
&amp;nbsp;Dim c As String&lt;br /&gt;
&lt;br /&gt;
&lt;span class="Apple-style-span" style="color: blue;"&gt;&amp;nbsp;For a = 1 To 10&lt;/span&gt; &lt;span class="Apple-style-span" style="color: red;"&gt;'10 é o número de colunas que você quer percorrer&lt;/span&gt;&lt;br /&gt;
&amp;nbsp;&lt;span class="Apple-style-span" style="color: blue;"&gt;&amp;nbsp;For b = 1 To 2000 &lt;/span&gt;&lt;span class="Apple-style-span" style="color: red;"&gt;'2000 é o numero de linhas que você quer percorrer&lt;/span&gt;&lt;br /&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp;&lt;span class="Apple-style-span" style="color: blue;"&gt;c = Cells(a, b).Value '&lt;/span&gt; &lt;span class="Apple-style-span" style="color: red;"&gt;c=variável que armazena o valor da célula&lt;/span&gt;&lt;br /&gt;
&amp;nbsp;&lt;span class="Apple-style-span" style="color: red;"&gt;&amp;nbsp; 'b e c são respectivamente o endereço da célula, b=coluna e c=linha&lt;/span&gt;&lt;br /&gt;
&amp;nbsp;&amp;nbsp; &amp;nbsp;&lt;span class="Apple-style-span" style="color: blue;"&gt;If c &amp;lt;&amp;gt; "" Then&lt;/span&gt;&lt;span class="Apple-style-span" style="color: red;"&gt; 'se valor de a for diferente de vazio&lt;/span&gt;&lt;br /&gt;
&amp;nbsp;&amp;nbsp; &amp;nbsp;&lt;span class="Apple-style-span" style="color: blue;"&gt;&amp;nbsp;&amp;nbsp;c = UCase(c)&lt;/span&gt;&lt;span class="Apple-style-span" style="color: red;"&gt;' o ucase converte em maiúscula&lt;/span&gt;&lt;br /&gt;
&lt;span class="Apple-style-span" style="color: blue;"&gt;&amp;nbsp;&amp;nbsp; &amp;nbsp;End If&lt;/span&gt;&lt;br /&gt;
&amp;nbsp;&amp;nbsp;&lt;span class="Apple-style-span" style="color: blue;"&gt;Next&lt;/span&gt;&lt;br /&gt;
&lt;span class="Apple-style-span" style="color: blue;"&gt;&amp;nbsp;Next&lt;/span&gt;&lt;br /&gt;
&lt;span class="Apple-style-span" style="color: blue;"&gt;&lt;br /&gt;
&lt;/span&gt;&lt;br /&gt;
&lt;span class="Apple-style-span" style="color: blue;"&gt;End Sub&lt;/span&gt;&lt;br /&gt;
&lt;div&gt;&lt;br /&gt;
&lt;/div&gt;&lt;br /&gt;
&lt;div&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/4986120378873341104-6769684964274554538?l=giovanedesouza.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://giovanedesouza.blogspot.com/feeds/6769684964274554538/comments/default' title='Postar comentários'/><link rel='replies' type='text/html' href='http://giovanedesouza.blogspot.com/2010/10/transforma-valor-da-celula-em-maiuscula.html#comment-form' title='0 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/4986120378873341104/posts/default/6769684964274554538?v=2'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/4986120378873341104/posts/default/6769684964274554538?v=2'/><link rel='alternate' type='text/html' href='http://giovanedesouza.blogspot.com/2010/10/transforma-valor-da-celula-em-maiuscula.html' title='Transforma valor da célula em maiúscula'/><author><name>Giovane</name><uri>http://www.blogger.com/profile/12175115829217489022</uri><email>giovanedsouza@yahoo.com.br</email><gd:extendedProperty name='OpenSocialUserId' value='12409833617791306958'/></author><thr:total>0</thr:total></entry><entry gd:etag='W/&quot;DEQFRXc_cSp7ImA9Wx5VEUk.&quot;'><id>tag:blogger.com,1999:blog-4986120378873341104.post-6687711880198844548</id><published>2010-10-03T19:51:00.000-03:00</published><updated>2010-10-03T19:51:54.949-03:00</updated><app:edited xmlns:app='http://www.w3.org/2007/app'>2010-10-03T19:51:54.949-03:00</app:edited><category scheme='http://www.blogger.com/atom/ns#' term='varrer intervalo'/><category scheme='http://www.blogger.com/atom/ns#' term='excel'/><category scheme='http://www.blogger.com/atom/ns#' term='laço for'/><category scheme='http://www.blogger.com/atom/ns#' term='macros'/><title>Varrendo uma guia numa planilha do Excel</title><content type='html'>Não raro, temos a necessidade de varrer uma planilha em busca de alguma informação ou mesmo pra preencher alguma matriz. Nesse código você pode conferir um pequeno exemplo:&lt;br /&gt;
&lt;br /&gt;
Como varrer um intervalo em uma planilha&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;span class="Apple-style-span" style="color: blue;"&gt;Sub varreintervalo()&lt;/span&gt;&lt;br /&gt;
&lt;span class="Apple-style-span" style="color: blue;"&gt;'&lt;/span&gt;&lt;br /&gt;
&lt;span class="Apple-style-span" style="color: blue;"&gt;&amp;nbsp;Dim a, b As Integer&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&amp;nbsp;&lt;span class="Apple-style-span" style="color: blue;"&gt;For a = 1 To 10&lt;/span&gt;&lt;span class="Apple-style-span" style="color: red;"&gt; '10 é o número de colunas que você quer percorrer&lt;/span&gt;&lt;br /&gt;
&amp;nbsp;&amp;nbsp;&lt;span class="Apple-style-span" style="color: blue;"&gt;For b = 1 To 2000&lt;/span&gt;&lt;span class="Apple-style-span" style="color: red;"&gt; '2000 é o numero de linhas que você quer percorrer&lt;/span&gt;&lt;br /&gt;
&lt;span class="Apple-style-span" style="color: red;"&gt;&amp;nbsp;&amp;nbsp; 'aqui você coloca o que quer que o laço execute, seja um contador ou qualquer coisa&lt;/span&gt;&lt;br /&gt;
&amp;nbsp;&lt;span class="Apple-style-span" style="color: blue;"&gt;&amp;nbsp;Next&lt;/span&gt;&lt;br /&gt;
&lt;span class="Apple-style-span" style="color: blue;"&gt;&amp;nbsp;Next&lt;/span&gt;&lt;br /&gt;
&lt;span class="Apple-style-span" style="color: blue;"&gt;&lt;br /&gt;
&lt;/span&gt;&lt;br /&gt;
&lt;span class="Apple-style-span" style="color: blue;"&gt;End Sub&lt;/span&gt;&lt;br /&gt;
&lt;div&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/4986120378873341104-6687711880198844548?l=giovanedesouza.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://giovanedesouza.blogspot.com/feeds/6687711880198844548/comments/default' title='Postar comentários'/><link rel='replies' type='text/html' href='http://giovanedesouza.blogspot.com/2010/10/varrendo-uma-guia-numa-planilha-do.html#comment-form' title='0 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/4986120378873341104/posts/default/6687711880198844548?v=2'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/4986120378873341104/posts/default/6687711880198844548?v=2'/><link rel='alternate' type='text/html' href='http://giovanedesouza.blogspot.com/2010/10/varrendo-uma-guia-numa-planilha-do.html' title='Varrendo uma guia numa planilha do Excel'/><author><name>Giovane</name><uri>http://www.blogger.com/profile/12175115829217489022</uri><email>giovanedsouza@yahoo.com.br</email><gd:extendedProperty name='OpenSocialUserId' value='12409833617791306958'/></author><thr:total>0</thr:total></entry><entry gd:etag='W/&quot;CE4DSXg8cSp7ImA9Wx5VEU8.&quot;'><id>tag:blogger.com,1999:blog-4986120378873341104.post-8905494261302923536</id><published>2010-10-03T13:22:00.000-03:00</published><updated>2010-10-03T13:22:58.679-03:00</updated><app:edited xmlns:app='http://www.w3.org/2007/app'>2010-10-03T13:22:58.679-03:00</app:edited><category scheme='http://www.blogger.com/atom/ns#' term='clipboard'/><category scheme='http://www.blogger.com/atom/ns#' term='excel'/><category scheme='http://www.blogger.com/atom/ns#' term='limpar área de transferência'/><category scheme='http://www.blogger.com/atom/ns#' term='macros'/><title>Limpar área de transferência</title><content type='html'>No desenvolvimento de macros que geralmente precisamos limpar a área de transferência para que não apareça uma chata mensagem de que "Você deseja manter os dados da área de transferência?", penei por um bom tempo para encontrar um código que não precisasse clicar em nenhum botão para seguir com a rotina.&lt;br /&gt;
Então encontrei este pequeno fragmento que ajudou em muito.&lt;br /&gt;
Vamos a ele:&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Application.CutCopyMode = False&lt;br /&gt;
&lt;div&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div&gt;Basta inserí-lo no seu código que não aparecerá mais a inconveniente janela para ficar clicando.&lt;/div&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/4986120378873341104-8905494261302923536?l=giovanedesouza.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://giovanedesouza.blogspot.com/feeds/8905494261302923536/comments/default' title='Postar comentários'/><link rel='replies' type='text/html' href='http://giovanedesouza.blogspot.com/2010/10/limpar-area-de-transferencia.html#comment-form' title='0 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/4986120378873341104/posts/default/8905494261302923536?v=2'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/4986120378873341104/posts/default/8905494261302923536?v=2'/><link rel='alternate' type='text/html' href='http://giovanedesouza.blogspot.com/2010/10/limpar-area-de-transferencia.html' title='Limpar área de transferência'/><author><name>Giovane</name><uri>http://www.blogger.com/profile/12175115829217489022</uri><email>giovanedsouza@yahoo.com.br</email><gd:extendedProperty name='OpenSocialUserId' value='12409833617791306958'/></author><thr:total>0</thr:total></entry><entry gd:etag='W/&quot;C08CRnk8cSp7ImA9Wx5VEEk.&quot;'><id>tag:blogger.com,1999:blog-4986120378873341104.post-7470742515343286803</id><published>2010-10-02T10:49:00.000-03:00</published><updated>2010-10-02T14:51:07.779-03:00</updated><app:edited xmlns:app='http://www.w3.org/2007/app'>2010-10-02T14:51:07.779-03:00</app:edited><category scheme='http://www.blogger.com/atom/ns#' term='excel'/><category scheme='http://www.blogger.com/atom/ns#' term='planilhas'/><category scheme='http://www.blogger.com/atom/ns#' term='macros'/><title>Macros  e Excel</title><content type='html'>&lt;span class="Apple-style-span" style="font-family: Arial; font-size: small;"&gt;&lt;span class="Apple-style-span" style="font-size: 13px;"&gt;H&lt;/span&gt;&lt;/span&gt;oje em dia temos uma necessidade imensurável de conhecermos e dominar o Excel e Macros(VBA). Cada dia mais as rotinas manuais em tratamento de relatórios, planilhas, nos tomam tempo e isso poderia ser aproveitado para outras coisas, como analisar o que estamos fazendo ou mesmo fazer coisas que agreguem mais valor ao nosso trabalho. Com o conhecimento em programação e lógica (Mais lógica que programação) que obtive ao longo de 10 anos trabalhando com sistemas em diversas empresas aprendi a usar macros e vba. Isso me deu uma oportunidade de desenvolver várias planilhas automatizadas para meu trabalho e o de outras pessoas, desde planilhas que consolidam resultados, enviam emails, geram indicadores de performance e etc...Pensando nisso resolvi compartilhar este conhecimento com as outras pessoas atuando de forma individualizada, ou seja, ensinando as pessoas o que elas precisam aprender e focando no que realmente será útil para elas.&lt;br /&gt;
&lt;div&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div&gt;Se você deseja aprender um pouco mais sobre macros em excel, entre em contato pelos comentários do post ou pelo email: giovanedsouza@yahoo.com.br&lt;br /&gt;
&lt;div&gt;&lt;/div&gt;&lt;/div&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/4986120378873341104-7470742515343286803?l=giovanedesouza.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://giovanedesouza.blogspot.com/feeds/7470742515343286803/comments/default' title='Postar comentários'/><link rel='replies' type='text/html' href='http://giovanedesouza.blogspot.com/2010/10/macros-e-excel.html#comment-form' title='0 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/4986120378873341104/posts/default/7470742515343286803?v=2'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/4986120378873341104/posts/default/7470742515343286803?v=2'/><link rel='alternate' type='text/html' href='http://giovanedesouza.blogspot.com/2010/10/macros-e-excel.html' title='Macros  e Excel'/><author><name>Giovane</name><uri>http://www.blogger.com/profile/12175115829217489022</uri><email>giovanedsouza@yahoo.com.br</email><gd:extendedProperty name='OpenSocialUserId' value='12409833617791306958'/></author><thr:total>0</thr:total></entry><entry gd:etag='W/&quot;DEMNQ3cycSp7ImA9Wx5VEE8.&quot;'><id>tag:blogger.com,1999:blog-4986120378873341104.post-6988172130526721235</id><published>2010-10-02T10:34:00.001-03:00</published><updated>2010-10-02T10:34:52.999-03:00</updated><app:edited xmlns:app='http://www.w3.org/2007/app'>2010-10-02T10:34:52.999-03:00</app:edited><title></title><content type='html'>Sejam Bem vindos ao Giovane´s Blog!!!!!!!!&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/4986120378873341104-6988172130526721235?l=giovanedesouza.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://giovanedesouza.blogspot.com/feeds/6988172130526721235/comments/default' title='Postar comentários'/><link rel='replies' type='text/html' href='http://giovanedesouza.blogspot.com/2010/10/sejam-bem-vindos-ao-giovanes-blog.html#comment-form' title='0 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/4986120378873341104/posts/default/6988172130526721235?v=2'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/4986120378873341104/posts/default/6988172130526721235?v=2'/><link rel='alternate' type='text/html' href='http://giovanedesouza.blogspot.com/2010/10/sejam-bem-vindos-ao-giovanes-blog.html' title=''/><author><name>Giovane</name><uri>http://www.blogger.com/profile/12175115829217489022</uri><email>giovanedsouza@yahoo.com.br</email><gd:extendedProperty name='OpenSocialUserId' value='12409833617791306958'/></author><thr:total>0</thr:total></entry></feed>