Suíte Office:
Tópico Oficial Dicas de Excel
__________________________________________
Envie MP para sugerir tópicos para esta seção.
__________________________________________
1
Sala destinada para questões, dúvidas e dicas envolvendo pacotes ou suítes de escritório destinados ao Windows: instalação, configuração, desempenho, implementações, suítes Office, Open Office, Libre Office etc.
lulaca disse:fiz o que vc falou de mesclar as células ´so que o texto é grande e não aparece ele todo, isso vai ser visto em data show por isso a célula deve estar visivel com todo o texto.
exemplo pegue esse texto e faça ele fica visivel tanto em linhas como coluna?
DEMETRIUS DE ALMEIDA PIRES.
Permita-me contrapor alguns pontos de vistas do que o amigo apresentou...
Não existe e nem vai existir qualquer programa que compacte um DVD, em média 6.5 Gb para 4.7 Gb, sem perder qualidade... seja ele qual for, o tempo que for, as passagens que der... sempre se perderá qualidade... é inevitável... senão poderiamos esperar no futuro um compactador que transformasse 6.5 GB em apenas um byte com a qualidade de cinema...
O Rebuilder, o DVD2SVCD, e tantos outros, utilizando o CCE ou equivalente, vai demorar horas nessa conversão e no final o resultado é aproximadamente igual, pouco melhor ou pouco pior... para se notar a diferença vc teria que utilizar equipamentos de precisão, pois a nossa visão e audição não vai detetar essas pequenas diferenças...
O problema do Shrink é que ele é freeware... e quando as coisas são grátis, todo santo desconfia de sua eficiência... se vc compactar o MENU, MAIN e EXTRA a 50%, vc notará alguma diferença se for assistir em tela grande, com algum projetor... em TV até 29" não dá para notar muita diferença... o pior DVD que compactei foi o da IVETE SANGALO... não cortei o EXTRA porque ele é um segundo show... e no próprio DVD original, a imagem do EXTRA já é sofrível... assistindo em uma TV de 34", eu notei alguma perda de qualidade colando os olhos na tela da TV, pois foi compactado próximo aos 50%... o DVD original tem 8.2 Gb, maior do que o senhor dos anéis... mas nada que incomode se assitido a uma distância adequada...
Sou defensor do Shrink porque ele oferece todos os recursos necessários para copiar um DVD, é rápido, é fácil de usar, é freeware, é popular e apresenta ótimos resultados...
O RB apresenta um ótimo resultado também, tem mais recursos, é pago, é complicado de se usar e gasta horas pra fazer o mesmo trabalho que o Shrink faz em 1/2 hora...
No final, a diferença de imagem/som, se existir, é desprezível e poderá ser pior ou melhor... será que vale a pena gastar horas a fio nesse tipo de compactação ??? Penso que não...
Além do que, embora eu não utilize, o Shrink tem um tal de EAC... dependendo de como vc setar o EAC, a compactação será feita em mais de uma passagem, demorando mais tempo e melhorando a qualidade do produto final (dizem)... eu não utilizo porque tanto o EAC como o RB deixam a imagem um pouco borrada, sob o minha ótica, perdendo a definição... isso é devido a eliminação de detalhes para tornar cada frame mais enxuto, com menor número de bytes...
Finalmente, quem quer copiar vários DVD por dia, terá que ter alguns micros dedicados para trabalhar com o RB... com o Shrink é vapt-vupt...
Bem, são os meus pontos de vista, não necessariamente perfeitos...
A B C D E
Critério 1 Critério 2 Critério 3 Situação (#1) - (NF34) - (CRIT34) - situação1, situação2, situação3.
#1 NF34 CRIT34 situação1 (#2) - (NF21) - (CRIT87) - situação4, situação5.
#1 NF34 CRIT34 situação2 (#3) - (NF35) - (CRIT63) - situação1, situação2, situação3, situação4.
#1 NF34 CRIT34 situação3 (#4) - (NF27) - (CRIT19) - situação5.
#2 NF21 CRIT87 situação4
#2 NF21 CRIT87 situação5
#3 NF35 CRIT63 situação1
#3 NF35 CRIT63 situação2
#3 NF35 CRIT63 situação3
#3 NF35 CRIT63 situação4
#4 NF27 CRIT19 situação5
Resultado na coluna E
(#1) - (NF34) - (CRIT34) - situação1, situação2, situação3.
(#2) - (NF21) - (CRIT87) - situação4, situação5.
(#3) - (NF35) - (CRIT63) - situação1, situação2, situação3, situação4.
(#4) - (NF27) - (CRIT19) - situação5.
Com 2 critérios o expert Mário Lúcio fez com perfeição
=let(a; byrow(map(A2:A11;B2:B11;lambda(x;y;hstack(concatenar("(";x;""concatenar("(";y;""))); lambda(x; join(" - "; x))); byrow(unique(a); lambda(y; y&" - "&join(", "; filter(C2:C11; a=y)))))
Tentei fazer com 3 e não consegui; Fiz assim:
=let(a; byrow(map(A2:A;B2:B;C2;C;lambda(x;y;z;hstack(CONCATENATE("(";x;""CONCATENATE("(";y;""CONCATENATE("(";z;""))); lambda(x; join(" - "; x))); byrow(unique(a); lambda(y; y&" - "&join(", "; lambda(z; z&" - "&join(", "; filter(C2:C; a=y)))))
LaerteB disse:Boa tarde, Patricia Mielczarski
Obrigado você ; estamos aqui para ajudar.
Fiquei feliz que resolveu a sua questão .. e também agora sabemos que o erro era
ocasionado pelo formato da imagem (.ico) .
Opa seu Office é da versão de "1908", bem velhinho né rsrsrsrs...
LaerteB
Sub DiagramaProdução1A()
'
' novo diagrama produção
'
On Error GoTo TE
Application.ScreenUpdating = False
i = 12
j = 3
counter1 = 14
Do While counter1 <> 0
Cells(i, j).Select
While Not Cells(i, j).Text = "" ' continua enquanto linha não estiver em branco
' Teste de resistividade
If Cells(i + 1, j + 129).Text = "33" Then
ActiveSheet.Shapes.Range(Array("CONTRAPESO").Select
Selection.Copy
Cells(i - 2, j + 2).Select
ActiveSheet.Paste
Selection.ShapeRange.IncrementLeft 10.5750393701
Selection.ShapeRange.IncrementTop 1.5750393701
Else
End If
If Cells(i, j + 129).Text = "ESTAIADA" Then
'revisão
If Cells(i - 2, j + 1).Text = "R" And Cells(i, j + 1).Text = "MBCR" Then
ActiveSheet.Shapes.Range(Array("ObjectT").Select
Selection.Copy
Cells(i - 2, j).Select
ActiveSheet.Paste
Selection.ShapeRange.IncrementLeft -1.4750393701
Selection.ShapeRange.IncrementTop 1.8750393701
Selection.ShapeRange.IncrementTop 1.8750393701
Selection.ShapeRange.IncrementTop 1.8750393701
Selection.ShapeRange.IncrementTop 1.4750393701
PULAR = OK
Else
If Cells(i - 2, j + 1).Text = "R" Then
ActiveSheet.Shapes.Range(Array("ObjectT").Select
Selection.Copy
Cells(i - 2, j).Select
ActiveSheet.Paste
Selection.ShapeRange.IncrementLeft -1.4750393701
Selection.ShapeRange.IncrementLeft -1.8750393701
Selection.ShapeRange.IncrementTop 1.8750393701
Selection.ShapeRange.IncrementTop 1.8750393701
Selection.ShapeRange.IncrementTop 1.8750393701
Selection.ShapeRange.IncrementTop 1.4750393701
PULAR = OK
Else
'montagem
If Cells(i - 2, j + 1).Text = "M" And Cells(i, j + 1).Text = "MBCR" Then
ActiveSheet.Shapes.Range(Array("ObjectTM").Select
Selection.Copy
Cells(i - 2, j).Select
ActiveSheet.Paste
Selection.ShapeRange.IncrementLeft -1.4750393701
Selection.ShapeRange.IncrementTop 1.8750393701
Selection.ShapeRange.IncrementTop 1.8750393701
Selection.ShapeRange.IncrementTop 1.8750393701
Selection.ShapeRange.IncrementTop 1.4750393701
PULAR = "OK"
Else
PULAR = "NOK"
If Cells(i - 2, j + 1).Text = "M" Then
ActiveSheet.Shapes.Range(Array("ObjectTM").Select
Selection.Copy
Cells(i - 2, j).Select
ActiveSheet.Paste
Selection.ShapeRange.IncrementLeft -1.4750393701
Selection.ShapeRange.IncrementTop 1.8750393701
Selection.ShapeRange.IncrementTop 1.8750393701
Selection.ShapeRange.IncrementTop 1.8750393701
Selection.ShapeRange.IncrementTop 1.4750393701
PULAR = "OK"
Else
PULAR = "NOK"
'montagem incompleta
If Cells(i - 2, j + 1).Text = "MI" Then
ActiveSheet.Shapes.Range(Array("Object 11").Select
Selection.Copy
Cells(i - 2, j).Select
ActiveSheet.Paste
Selection.ShapeRange.IncrementLeft -1.8750393701
Selection.ShapeRange.IncrementLeft -1.8750393701
Selection.ShapeRange.IncrementLeft -1.8750393701
Selection.ShapeRange.IncrementLeft -1.8750393701
Selection.ShapeRange.IncrementLeft -1.8750393701
Selection.ShapeRange.IncrementLeft -1.8750393701
Selection.ShapeRange.IncrementLeft -1.8750393701
Selection.ShapeRange.IncrementLeft -1.8750393701
Selection.ShapeRange.IncrementLeft -1.8750393701
Selection.ShapeRange.IncrementLeft -1.8750393701
Selection.ShapeRange.IncrementTop -1.8750393701
Selection.ShapeRange.IncrementTop -1.8750393701
Selection.ShapeRange.IncrementTop -1.8750393701
Selection.ShapeRange.IncrementTop -1.8750393701
Selection.ShapeRange.IncrementTop -1.8750393701
Selection.ShapeRange.IncrementTop -1.8750393701
Selection.ShapeRange.IncrementTop -1.8750393701
Selection.ShapeRange.IncrementTop -1.8750393701
Selection.ShapeRange.IncrementTop -1.8750393701
Selection.ShapeRange.IncrementTop -1.8750393701
Selection.ShapeRange.IncrementTop -1.8750393701
PULAR = "OK"
Else
PULAR = "NOK"
End If
End If
End If
End If
End If
'EHS
If j > 3 Then
If Cells(i - 2, j - 3).Text = "G" Then
ActiveSheet.Shapes.Range(Array("Freeform 127").Select
Selection.Copy
Cells(i - 2, j - 3).Select
ActiveSheet.Paste
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementTop 1.8750393701
Selection.ShapeRange.IncrementTop 1.8750393701
Selection.ShapeRange.IncrementTop 1.8750393701
Selection.ShapeRange.IncrementTop 1.8750393701
Selection.ShapeRange.IncrementTop 1.8750393701
Selection.ShapeRange.IncrementTop 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementTop 1.8750393701
Selection.ShapeRange.IncrementTop 1.8750393701
Selection.ShapeRange.IncrementTop 1.8750393701
Selection.ShapeRange.IncrementTop 1.8750393701
Selection.ShapeRange.IncrementTop 1.8750393701
Selection.ShapeRange.IncrementLeft -1.8750393701
Else
End If
Else
End If
'EHS vão vante
If j > 3 Then
If j = 108 Then
If Cells(i - 2, j + 3) = "" And Cells(i + 2, j - 105).Text = "G" Then
ActiveSheet.Shapes.Range(Array("Freeform 127").Select
Selection.Copy
Cells(i - 2, j - 3).Select
ActiveSheet.Paste
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementTop 1.8750393701
Selection.ShapeRange.IncrementTop 1.8750393701
Selection.ShapeRange.IncrementTop 1.8750393701
Selection.ShapeRange.IncrementTop 1.8750393701
Selection.ShapeRange.IncrementTop 1.8750393701
Selection.ShapeRange.IncrementTop 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementTop 1.8750393701
Selection.ShapeRange.IncrementTop 1.8750393701
Selection.ShapeRange.IncrementTop 1.8750393701
Selection.ShapeRange.IncrementTop 1.8750393701
Selection.ShapeRange.IncrementTop 1.8750393701
Selection.ShapeRange.IncrementLeft -1.8750393701
Else
End If
Else
End If
Else
End If
'lançamento
If j > 3 Then
If Cells(i - 1, j - 3).Text = "L" Then
ActiveSheet.Shapes.Range(Array("Freeform 128").Select
Selection.Copy
Cells(i - 2, j - 3).Select
ActiveSheet.Paste
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementTop 1.8750393701
Selection.ShapeRange.IncrementTop 1.8750393701
Selection.ShapeRange.IncrementTop 1.8750393701
Selection.ShapeRange.IncrementTop 1.8750393701
Selection.ShapeRange.IncrementTop 1.8750393701
Selection.ShapeRange.IncrementTop 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementTop 1.8750393701
Selection.ShapeRange.IncrementTop 1.8750393701
Selection.ShapeRange.IncrementTop 1.8750393701
Selection.ShapeRange.IncrementTop 1.8750393701
Selection.ShapeRange.IncrementTop 1.8750393701
Selection.ShapeRange.IncrementLeft -1.8750393701
Else
End If
Else
End If
'lançamento OPGW
If j > 3 Then
If Cells(i - 1, j - 2).Text = "OPGW-L" Then
ActiveSheet.Shapes.Range(Array("Freeform 190").Select
Selection.Copy
Cells(i - 2, j - 3).Select
ActiveSheet.Paste
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementTop 1.8750393701
Selection.ShapeRange.IncrementTop 1.8750393701
Selection.ShapeRange.IncrementTop 1.8750393701
Selection.ShapeRange.IncrementTop 1.8750393701
Selection.ShapeRange.IncrementTop 1.8750393701
Selection.ShapeRange.IncrementTop 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementTop 1.8750393701
Selection.ShapeRange.IncrementTop 1.8750393701
Selection.ShapeRange.IncrementTop 1.8750393701
Selection.ShapeRange.IncrementTop 1.8750393701
Selection.ShapeRange.IncrementTop 1.8750393701
Selection.ShapeRange.IncrementLeft -1.8750393701
Else
End If
Else
End If
'F1
If Cells(i, j + 130).Text = "3" Then
ActiveSheet.Shapes.Range(Array("Imagem 1688").Select
Selection.Copy
Cells(i, j).Select
ActiveSheet.Paste
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Else
End If
'F2
If Cells(i, j + 130).Text = "4" Then
ActiveSheet.Shapes.Range(Array("Imagem 1689").Select
Selection.Copy
Cells(i, j).Select
ActiveSheet.Paste
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Else
End If
' pré montagem
If Cells(i - 2, j + 1).Text <> "R" And Cells(i - 2, j + 1).Text <> "M" And Cells(i - 2, j + 1).Text <> "MI" Then
If Cells(i, j + 128).Text = "1" Then
ActiveSheet.Shapes.Range(Array("Imagem 730").Select
Selection.Copy
Cells(i, j).Select
ActiveSheet.Paste
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Range("Y73".Select
End If
End If
' pré montagem
If Cells(i - 2, j + 1).Text <> "R" And Cells(i - 2, j + 1).Text <> "M" And Cells(i - 2, j + 1).Text <> "MI" Then
If Cells(i, j + 128).Text = "2" Then
ActiveSheet.Shapes.Range(Array("Imagem750").Select
Selection.Copy
Cells(i, j).Select
ActiveSheet.Paste
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Range("Y73".Select
End If
End If
If PULAR = "NOK" Then
ActiveSheet.Shapes.Range(Array("Pizza 83").Select
Selection.Copy
Cells(i - 2, j).Select
ActiveSheet.Paste
' 1° quadrante
' 1° opção
'
If Cells(i - 2, j).Text = "F" Then
'edita grafico
With Selection.ShapeRange.Fill
.Visible = msoTrue
.ForeColor.RGB = RGB(46, 205, 9)
.Transparency = 0
.Solid
End With
Else
If Cells(i - 2, j).Text = "P" Then
'edita grafico
With Selection.ShapeRange.Fill
.Visible = msoTrue
.ForeColor.RGB = RGB(147, 119, 103)
.Transparency = 0
.Solid
End With
Else
If Cells(i - 2, j).Text = "0" Then
'edita grafico
With Selection.ShapeRange.Fill
.Visible = msoTrue
.ForeColor.RGB = RGB(255, 255, 255)
.Transparency = 0
.Solid
End With
Else
If Cells(i - 2, j).Text = "MI" Then
'edita grafico
With Selection.ShapeRange.Fill
.Visible = msoTrue
.ForeColor.RGB = RGB(255, 255, 0)
.Transparency = 0
.Solid
End With
Else
'sondagem & topografia
If Cells(i - 2, j).Text = "ST" Then
'edita grafico
With Selection.ShapeRange.Fill
.Visible = msoTrue
.ForeColor.RGB = RGB(112, 48, 160)
.Transparency = 0
.Solid
End With
With Selection.ShapeRange.Line
.Visible = msoTrue
.ForeColor.ObjectThemeColor = msoThemeColorAccent6
.ForeColor.TintAndShade = 0
.ForeColor.Brightness = -0.25
.Transparency = 0
End With
With Selection.ShapeRange.Line
.Visible = msoTrue
.Weight = 6
End With
Else
End If
'SONDAGEM
If Cells(i - 2, j).Text = "SO" Then
'edita grafico
With Selection.ShapeRange.Line
.Visible = msoTrue
.ForeColor.ObjectThemeColor = msoThemeColorAccent6
.ForeColor.TintAndShade = 0
.ForeColor.Brightness = -0.25
.Transparency = 0
End With
With Selection.ShapeRange.Line
.Visible = msoTrue
.Weight = 6
End With
Else
End If
'TOPOGRAFIA
If Cells(i - 2, j).Text = "TO" Then
'edita grafico
With Selection.ShapeRange.Fill
.Visible = msoTrue
.ForeColor.RGB = RGB(112, 48, 160)
.Transparency = 0
.Solid
End With
Else
'CONFERÊNCIA
If Cells(i - 2, j).Text = "COF" Then
'edita grafico
With Selection.ShapeRange.Fill
.Visible = msoTrue
.ForeColor.RGB = RGB(0, 176, 240)
.Transparency = 0
.Solid
End With
Else
End If
End If
End If
End If
End If
End If
'
' Inicio do 2° quadrante
'
ActiveSheet.Shapes.Range(Array("PIZZA 86").Select
Selection.Copy
Cells(i - 2, j).Select
ActiveSheet.Paste
j = j + 1
If Cells(i - 2, j).Text = "F" Then
'edita grafico
With Selection.ShapeRange.Fill
.Visible = msoTrue
.ForeColor.RGB = RGB(46, 205, 9)
.Transparency = 0
.Solid
End With
Else
'6² OPÇÃO
If Cells(i - 2, j).Text = "P" Then
'edita grafico
With Selection.ShapeRange.Fill
.Visible = msoTrue
.ForeColor.RGB = RGB(147, 119, 103)
.Transparency = 0
.Solid
End With
Else
'5² OPÇÃO
If Cells(i - 2, j).Text = "0" Then
'edita grafico
With Selection.ShapeRange.Fill
.Visible = msoTrue
.ForeColor.RGB = RGB(255, 255, 255)
.Transparency = 0
.Solid
End With
Else
'sondagem & topografia
If Cells(i - 2, j).Text = "ST" Then
'edita grafico
With Selection.ShapeRange.Fill
.Visible = msoTrue
.ForeColor.RGB = RGB(112, 48, 160)
.Transparency = 0
.Solid
End With
With Selection.ShapeRange.Line
.Visible = msoTrue
.ForeColor.ObjectThemeColor = msoThemeColorAccent6
.ForeColor.TintAndShade = 0
.ForeColor.Brightness = -0.25
.Transparency = 0
End With
With Selection.ShapeRange.Line
.Visible = msoTrue
.Weight = 6
End With
Else
End If
'SONDAGEM
If Cells(i - 2, j).Text = "SO" Then
'edita grafico
With Selection.ShapeRange.Line
.Visible = msoTrue
.ForeColor.ObjectThemeColor = msoThemeColorAccent6
.ForeColor.TintAndShade = 0
.ForeColor.Brightness = -0.25
.Transparency = 0
End With
With Selection.ShapeRange.Line
.Visible = msoTrue
.Weight = 6
End With
Else
End If
'TOPOGRAFIA
If Cells(i - 2, j).Text = "TO" Then
'edita grafico
With Selection.ShapeRange.Fill
.Visible = msoTrue
.ForeColor.RGB = RGB(112, 48, 160)
.Transparency = 0
.Solid
End With
Else
'Conferência
If Cells(i - 2, j).Text = "COF" Then
'edita grafico
With Selection.ShapeRange.Fill
.Visible = msoTrue
.ForeColor.RGB = RGB(0, 176, 240)
.Transparency = 0
.Solid
End With
Else
End If
End If
End If
End If
End If
j = j - 1
ActiveSheet.Shapes.Range(Array("PIZZA 84").Select
Selection.Copy
Cells(i - 2, j).Select
ActiveSheet.Paste
'
' Inicio do 3° quadrante
'
'5 opção
If Cells(i - 1, j).Text = "F" Then
'edita grafico
With Selection.ShapeRange.Fill
.Visible = msoTrue
.ForeColor.RGB = RGB(46, 205, 9)
.Transparency = 0
.Solid
End With
Else
'6² OPÇÃO
If Cells(i - 1, j).Text = "P" Then
'edita grafico
With Selection.ShapeRange.Fill
.Visible = msoTrue
.ForeColor.RGB = RGB(147, 119, 103)
.Transparency = 0
.Solid
End With
Else
'7 opção
If Cells(i - 1, j).Text = "0" Then
'edita grafico
With Selection.ShapeRange.Fill
.Visible = msoTrue
.ForeColor.RGB = RGB(255, 255, 255)
.Transparency = 0
.Solid
End With
Else
'sondagem & topografia
If Cells(i - 2, j).Text = "ST" Then
'edita grafico
With Selection.ShapeRange.Fill
.Visible = msoTrue
.ForeColor.RGB = RGB(112, 48, 160)
.Transparency = 0
.Solid
End With
With Selection.ShapeRange.Line
.Visible = msoTrue
.ForeColor.ObjectThemeColor = msoThemeColorAccent6
.ForeColor.TintAndShade = 0
.ForeColor.Brightness = -0.25
.Transparency = 0
End With
With Selection.ShapeRange.Line
.Visible = msoTrue
.Weight = 6
End With
Else
End If
'SONDAGEM
If Cells(i - 2, j).Text = "SO" Then
'edita grafico
With Selection.ShapeRange.Line
.Visible = msoTrue
.ForeColor.ObjectThemeColor = msoThemeColorAccent6
.ForeColor.TintAndShade = 0
.ForeColor.Brightness = -0.25
.Transparency = 0
End With
With Selection.ShapeRange.Line
.Visible = msoTrue
.Weight = 6
End With
Else
End If
'TOPOGRAFIA
If Cells(i - 2, j).Text = "TO" Then
'edita grafico
With Selection.ShapeRange.Fill
.Visible = msoTrue
.ForeColor.RGB = RGB(112, 48, 160)
.Transparency = 0
.Solid
End With
Else
'Conferência
If Cells(i - 2, j).Text = "COF" Then
'edita grafico
With Selection.ShapeRange.Fill
.Visible = msoTrue
.ForeColor.RGB = RGB(0, 176, 240)
.Transparency = 0
.Solid
End With
Else
End If
End If
End If
End If
End If
ActiveSheet.Shapes.Range(Array("PIZZA 85").Select
Selection.Copy
Cells(i - 2, j).Select
ActiveSheet.Paste
j = j + 1
'
' Inicio do 4° quadrante
'
'1 opção
If Cells(i - 1, j).Text = "F" Then
'edita grafico
With Selection.ShapeRange.Fill
.Visible = msoTrue
.ForeColor.RGB = RGB(46, 205, 9)
.Transparency = 0
.Solid
End With
Else
'2² OPÇÃO
If Cells(i - 1, j).Text = "P" Then
'edita grafico
With Selection.ShapeRange.Fill
.Visible = msoTrue
.ForeColor.RGB = RGB(147, 119, 103)
.Transparency = 0
.Solid
End With
Else
'3² OPÇÃO
If Cells(i - 1, j).Text = "0" Then
'edita grafico
With Selection.ShapeRange.Fill
.Visible = msoTrue
.ForeColor.RGB = RGB(255, 255, 255)
.Transparency = 0
.Solid
End With
Else
'sondagem & topografia
If Cells(i - 2, j).Text = "ST" Then
'edita grafico
With Selection.ShapeRange.Fill
.Visible = msoTrue
.ForeColor.RGB = RGB(112, 48, 160)
.Transparency = 0
.Solid
End With
With Selection.ShapeRange.Line
.Visible = msoTrue
.ForeColor.ObjectThemeColor = msoThemeColorAccent6
.ForeColor.TintAndShade = 0
.ForeColor.Brightness = -0.25
.Transparency = 0
End With
With Selection.ShapeRange.Line
.Visible = msoTrue
.Weight = 6
End With
Else
End If
'SONDAGEM
If Cells(i - 2, j).Text = "SO" Then
'edita grafico
With Selection.ShapeRange.Line
.Visible = msoTrue
.ForeColor.ObjectThemeColor = msoThemeColorAccent6
.ForeColor.TintAndShade = 0
.ForeColor.Brightness = -0.25
.Transparency = 0
End With
With Selection.ShapeRange.Line
.Visible = msoTrue
.Weight = 6
End With
Else
End If
'TOPOGRAFIA
If Cells(i - 2, j).Text = "TO" Then
'edita grafico
With Selection.ShapeRange.Fill
.Visible = msoTrue
.ForeColor.RGB = RGB(112, 48, 160)
.Transparency = 0
.Solid
End With
Else
'Conferência
If Cells(i - 2, j).Text = "COF" Then
'edita grafico
With Selection.ShapeRange.Fill
.Visible = msoTrue
.ForeColor.RGB = RGB(0, 176, 240)
.Transparency = 0
.Solid
End With
Else
End If
End If
End If
End If
End If
j = j - 1
'mc1
ActiveSheet.Shapes.Range(Array("Retângulo Arredondado 89").Select
Selection.Copy
Cells(i - 2, j).Select
ActiveSheet.Paste
Selection.ShapeRange.IncrementLeft 25.272440944
Selection.ShapeRange.IncrementTop 33.036062991
If Cells(i - 2, j).Text = "G" Then
'edita grafico
With Selection.ShapeRange.Fill
.Visible = msoTrue
.ForeColor.RGB = RGB(49, 197, 213)
.Transparency = 0
.Solid
End With
Else
' 2° opção
If Cells(i - 2, j).Text = "L" Then
'edita grafico
With Selection.ShapeRange.Fill
.Visible = msoTrue
.ForeColor.RGB = RGB(81, 88, 213)
.Transparency = 0
.Solid
End With
Else
'3 opção
If Cells(i - 2, j).Text = "R" Then
'edita grafico
With Selection.ShapeRange.Fill
.Visible = msoTrue
.ForeColor.RGB = RGB(184, 88, 115)
.Transparency = 0
.Solid
End With
Else
'4° OPÇÃO
If Cells(i - 2, j).Text = "M" Then
'edita grafico
With Selection.ShapeRange.Fill
.Visible = msoTrue
.ForeColor.RGB = RGB(242, 50, 30)
.Transparency = 0
.Solid
End With
Else
If Cells(i - 2, j).Text = "MI" Then
'edita grafico
With Selection.ShapeRange.Fill
.Visible = msoTrue
.ForeColor.RGB = RGB(255, 255, 0)
.Transparency = 0
.Solid
End With
Else
'6² OPÇÃO
If Cells(i + 1, j + 2).Text = "" Then
'edita grafico
With Selection.ShapeRange.Fill
.Visible = msoTrue
.ForeColor.RGB = RGB(255, 255, 255)
.Transparency = 0
.Solid
End With
Else
' 5° OPÇÃO
If Cells(i + 1, j + 2).Text = "MC" Then
'edita grafico
With Selection.ShapeRange.Fill
.Visible = msoTrue
.ForeColor.RGB = RGB(46, 205, 9)
.Transparency = 0
.Solid
End With
Else
'sondagem & topografia
If Cells(i - 2, j).Text = "ST" Then
'edita grafico
With Selection.ShapeRange.Fill
.Visible = msoTrue
.ForeColor.RGB = RGB(112, 48, 160)
.Transparency = 0
.Solid
End With
With Selection.ShapeRange.Line
.Visible = msoTrue
.ForeColor.ObjectThemeColor = msoThemeColorAccent6
.ForeColor.TintAndShade = 0
.ForeColor.Brightness = -0.25
.Transparency = 0
End With
With Selection.ShapeRange.Line
.Visible = msoTrue
.Weight = 6
End With
Else
End If
'SONDAGEM
If Cells(i - 2, j).Text = "SO" Then
'edita grafico
With Selection.ShapeRange.Line
.Visible = msoTrue
.ForeColor.ObjectThemeColor = msoThemeColorAccent6
.ForeColor.TintAndShade = 0
.ForeColor.Brightness = -0.25
.Transparency = 0
End With
With Selection.ShapeRange.Line
.Visible = msoTrue
.Weight = 6
End With
Else
End If
'TOPOGRAFIA
If Cells(i - 2, j).Text = "TO" Then
'edita grafico
With Selection.ShapeRange.Fill
.Visible = msoTrue
.ForeColor.RGB = RGB(112, 48, 160)
.Transparency = 0
.Solid
End With
Else
'Conferência
If Cells(i - 2, j).Text = "COF" Then
'edita grafico
With Selection.ShapeRange.Fill
.Visible = msoTrue
.ForeColor.RGB = RGB(0, 176, 240)
.Transparency = 0
.Solid
End With
Else
End If
End If
' 6° OPÇÃO
If Cells(i + 1, j + 2).Text = "0" Then
'edita grafico
With Selection.ShapeRange.Fill
.Visible = msoTrue
.ForeColor.RGB = RGB(255, 255, 255)
.Transparency = 0
.Solid
End With
Else
End If
End If
End If
End If
End If
End If
End If
'mc2
ActiveSheet.Shapes.Range(Array("Retângulo Arredondado 88").Select
Selection.Copy
Cells(i - 2, j).Select
ActiveSheet.Paste
Selection.ShapeRange.IncrementLeft 52.572440944
Selection.ShapeRange.IncrementTop 33.036062991
If Cells(i - 2, j).Text = "G" Then
'edita grafico
With Selection.ShapeRange.Fill
.Visible = msoTrue
.ForeColor.RGB = RGB(49, 197, 213)
.Transparency = 0
.Solid
End With
Else
' 2° opção
If Cells(i - 2, j).Text = "L" Then
'edita grafico
With Selection.ShapeRange.Fill
.Visible = msoTrue
.ForeColor.RGB = RGB(81, 88, 213)
.Transparency = 0
.Solid
End With
Else
'3 opção
If Cells(i - 2, j).Text = "R" Then
'edita grafico
With Selection.ShapeRange.Fill
.Visible = msoTrue
.ForeColor.RGB = RGB(184, 88, 115)
.Transparency = 0
.Solid
End With
Else
'4° OPÇÃO
If Cells(i - 2, j).Text = "M" Then
'edita grafico
With Selection.ShapeRange.Fill
.Visible = msoTrue
.ForeColor.RGB = RGB(242, 50, 30)
.Transparency = 0
.Solid
End With
Else
If Cells(i - 2, j).Text = "MI" Then
'edita grafico
With Selection.ShapeRange.Fill
.Visible = msoTrue
.ForeColor.RGB = RGB(255, 255, 0)
.Transparency = 0
.Solid
End With
Else
'6² OPÇÃO
If Cells(i, j + 2).Text = "" Then
'edita grafico
With Selection.ShapeRange.Fill
.Visible = msoTrue
.ForeColor.RGB = RGB(255, 255, 255)
.Transparency = 0
.Solid
End With
Else
' 5° OPÇÃO
If Cells(i, j + 2).Text = "MC2" Then
'edita grafico
With Selection.ShapeRange.Fill
.Visible = msoTrue
.ForeColor.RGB = RGB(46, 205, 9)
.Transparency = 0
.Solid
End With
Else
'sondagem & topografia
If Cells(i - 2, j).Text = "ST" Then
'edita grafico
With Selection.ShapeRange.Fill
.Visible = msoTrue
.ForeColor.RGB = RGB(112, 48, 160)
.Transparency = 0
.Solid
End With
With Selection.ShapeRange.Line
.Visible = msoTrue
.ForeColor.ObjectThemeColor = msoThemeColorAccent6
.ForeColor.TintAndShade = 0
.ForeColor.Brightness = -0.25
.Transparency = 0
End With
With Selection.ShapeRange.Line
.Visible = msoTrue
.Weight = 6
End With
Else
End If
'SONDAGEM
If Cells(i - 2, j).Text = "SO" Then
'edita grafico
With Selection.ShapeRange.Line
.Visible = msoTrue
.ForeColor.ObjectThemeColor = msoThemeColorAccent6
.ForeColor.TintAndShade = 0
.ForeColor.Brightness = -0.25
.Transparency = 0
End With
With Selection.ShapeRange.Line
.Visible = msoTrue
.Weight = 6
End With
Else
End If
'TOPOGRAFIA
If Cells(i - 2, j).Text = "TO" Then
'edita grafico
With Selection.ShapeRange.Fill
.Visible = msoTrue
.ForeColor.RGB = RGB(112, 48, 160)
.Transparency = 0
.Solid
End With
Else
'Conferência
If Cells(i - 2, j).Text = "cof" Then
'edita grafico
With Selection.ShapeRange.Fill
.Visible = msoTrue
.ForeColor.RGB = RGB(0, 176, 240)
.Transparency = 0
.Solid
End With
Else
End If
End If
' 6° OPÇÃO
If Cells(i + 1, j + 140).Text = "0" Then
'edita grafico
With Selection.ShapeRange.Fill
.Visible = msoTrue
.ForeColor.RGB = RGB(255, 255, 255)
.Transparency = 0
.Solid
End With
Else
End If
End If
End If
End If
End If
End If
End If
End If
End If
'Caso a torre já esteja montada
Else
End If
' pendência de projeto
If Cells(i + 1, j + 1).Text = "pp" Then
ActiveSheet.Shapes.Range(Array("Fluxograma: Somador 4").Select
Selection.Copy
Cells(i - 2, j).Select
ActiveSheet.Paste
Else
' Embargo sítio arqueológico
If Cells(i + 1, j + 1).Text = "s" Then
ActiveSheet.Shapes.Range(Array("Fluxograma: Somador 5").Select
Selection.Copy
Cells(i - 2, j).Select
ActiveSheet.Paste
Else
' Embargo proprietário
If Cells(i + 1, j + 1).Text = "p" Then
ActiveSheet.Shapes.Range(Array("Fluxograma: Somador 9").Select
Selection.Copy
Cells(i - 2, j).Select
ActiveSheet.Paste
End If
End If
End If
Else
' Caso torre seja autoportante os dados serão implantado em uma forma quadrada
'revisão
If Cells(i - 2, j + 1).Text = "R" Then
ActiveSheet.Shapes.Range(Array("Object 10").Select
Selection.Copy
Cells(i - 2, j).Select
ActiveSheet.Paste
Selection.ShapeRange.IncrementLeft -1.8750393701
Selection.ShapeRange.IncrementLeft -1.8750393701
Selection.ShapeRange.IncrementLeft -1.8750393701
Selection.ShapeRange.IncrementLeft -1.8750393701
Selection.ShapeRange.IncrementLeft -1.8750393701
Selection.ShapeRange.IncrementLeft -1.8750393701
Selection.ShapeRange.IncrementLeft -1.8750393701
Selection.ShapeRange.IncrementLeft -1.8750393701
Selection.ShapeRange.IncrementLeft -1.8750393701
Selection.ShapeRange.IncrementLeft -1.8750393701
Selection.ShapeRange.IncrementLeft -1.8750393701
Selection.ShapeRange.IncrementLeft -1.8750393701
Selection.ShapeRange.IncrementTop -1.8750393701
Selection.ShapeRange.IncrementTop -1.8750393701
Selection.ShapeRange.IncrementTop -1.8750393701
Selection.ShapeRange.IncrementTop -1.8750393701
Selection.ShapeRange.IncrementTop -1.8750393701
Selection.ShapeRange.IncrementTop -1.8750393701
PULAR = OK
Else
'montagem
If Cells(i - 2, j + 1).Text = "M" Then
ActiveSheet.Shapes.Range(Array("Object 9").Select
Selection.Copy
Cells(i - 2, j).Select
ActiveSheet.Paste
Selection.ShapeRange.IncrementLeft -1.8750393701
Selection.ShapeRange.IncrementLeft -1.8750393701
Selection.ShapeRange.IncrementLeft -1.8750393701
Selection.ShapeRange.IncrementLeft -1.8750393701
Selection.ShapeRange.IncrementLeft -1.8750393701
Selection.ShapeRange.IncrementLeft -1.8750393701
Selection.ShapeRange.IncrementLeft -1.8750393701
Selection.ShapeRange.IncrementLeft -1.8750393701
Selection.ShapeRange.IncrementLeft -1.8750393701
Selection.ShapeRange.IncrementLeft -1.8750393701
Selection.ShapeRange.IncrementLeft -1.8750393701
Selection.ShapeRange.IncrementLeft -1.8750393701
Selection.ShapeRange.IncrementTop -1.8750393701
Selection.ShapeRange.IncrementTop -1.8750393701
Selection.ShapeRange.IncrementTop -1.8750393701
Selection.ShapeRange.IncrementTop -1.8750393701
Selection.ShapeRange.IncrementTop -1.8750393701
Selection.ShapeRange.IncrementTop -1.8750393701
PULAR = "OK"
Else
PULAR = "NOK"
'montagem incompleta
If Cells(i - 2, j + 1).Text = "MI" Then
ActiveSheet.Shapes.Range(Array("Object 12").Select
Selection.Copy
Cells(i - 2, j).Select
ActiveSheet.Paste
Selection.ShapeRange.IncrementLeft -1.8750393701
Selection.ShapeRange.IncrementLeft -1.8750393701
Selection.ShapeRange.IncrementLeft -1.8750393701
Selection.ShapeRange.IncrementLeft -1.8750393701
Selection.ShapeRange.IncrementLeft -1.8750393701
Selection.ShapeRange.IncrementLeft -1.8750393701
Selection.ShapeRange.IncrementLeft -1.8750393701
Selection.ShapeRange.IncrementLeft -1.8750393701
Selection.ShapeRange.IncrementLeft -1.8750393701
Selection.ShapeRange.IncrementLeft -1.8750393701
Selection.ShapeRange.IncrementLeft -1.8750393701
Selection.ShapeRange.IncrementLeft -1.8750393701
Selection.ShapeRange.IncrementTop -1.8750393701
Selection.ShapeRange.IncrementTop -1.8750393701
Selection.ShapeRange.IncrementTop -1.8750393701
Selection.ShapeRange.IncrementTop -1.8750393701
Selection.ShapeRange.IncrementTop -1.8750393701
Selection.ShapeRange.IncrementTop -1.8750393701
PULAR = "OK"
Else
PULAR = "NOK"
End If
End If
End If
'grampeação
If j > 3 Then
If Cells(i - 2, j - 3).Text = "G" Then
ActiveSheet.Shapes.Range(Array("Freeform 127").Select
Selection.Copy
Cells(i - 2, j - 3).Select
ActiveSheet.Paste
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementTop 1.8750393701
Selection.ShapeRange.IncrementTop 1.8750393701
Selection.ShapeRange.IncrementTop 1.8750393701
Selection.ShapeRange.IncrementTop 1.8750393701
Selection.ShapeRange.IncrementTop 1.8750393701
Selection.ShapeRange.IncrementTop 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementTop 1.8750393701
Selection.ShapeRange.IncrementTop 1.8750393701
Selection.ShapeRange.IncrementTop 1.8750393701
Selection.ShapeRange.IncrementTop 1.8750393701
Selection.ShapeRange.IncrementTop 1.8750393701
Selection.ShapeRange.IncrementLeft -1.8750393701
Else
End If
Else
End If
'EHS vão vante
If j > 3 Then
If j = 53 Then
If Cells(i - 2, j + 3) = "" And Cells(i + 2, j - 50).Text = "G" Then
ActiveSheet.Shapes.Range(Array("Freeform 127").Select
Selection.Copy
Cells(i - 2, j - 3).Select
ActiveSheet.Paste
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementTop 1.8750393701
Selection.ShapeRange.IncrementTop 1.8750393701
Selection.ShapeRange.IncrementTop 1.8750393701
Selection.ShapeRange.IncrementTop 1.8750393701
Selection.ShapeRange.IncrementTop 1.8750393701
Selection.ShapeRange.IncrementTop 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementTop 1.8750393701
Selection.ShapeRange.IncrementTop 1.8750393701
Selection.ShapeRange.IncrementTop 1.8750393701
Selection.ShapeRange.IncrementTop 1.8750393701
Selection.ShapeRange.IncrementTop 1.8750393701
Selection.ShapeRange.IncrementLeft -1.8750393701
Else
End If
Else
End If
Else
End If
'lançamento
If j > 3 Then
If j > 3 And Cells(i - 1, j - 3).Text = "L" Then
ActiveSheet.Shapes.Range(Array("Freeform 128").Select
Selection.Copy
Cells(i - 2, j - 3).Select
ActiveSheet.Paste
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementTop 1.8750393701
Selection.ShapeRange.IncrementTop 1.8750393701
Selection.ShapeRange.IncrementTop 1.8750393701
Selection.ShapeRange.IncrementTop 1.8750393701
Selection.ShapeRange.IncrementTop 1.8750393701
Selection.ShapeRange.IncrementTop 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementTop 1.8750393701
Selection.ShapeRange.IncrementTop 1.8750393701
Selection.ShapeRange.IncrementTop 1.8750393701
Selection.ShapeRange.IncrementTop 1.8750393701
Selection.ShapeRange.IncrementTop 1.8750393701
Selection.ShapeRange.IncrementLeft -1.8750393701
Else
End If
Else
End If
'lançamento OPGW
If j > 3 Then
If Cells(i - 1, j - 2).Text = "OPGW-L" Then
ActiveSheet.Shapes.Range(Array("Freeform 190").Select
Selection.Copy
Cells(i - 2, j - 3).Select
ActiveSheet.Paste
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementTop 1.8750393701
Selection.ShapeRange.IncrementTop 1.8750393701
Selection.ShapeRange.IncrementTop 1.8750393701
Selection.ShapeRange.IncrementTop 1.8750393701
Selection.ShapeRange.IncrementTop 1.8750393701
Selection.ShapeRange.IncrementTop 1.8750393701
Selection.ShapeRange.IncrementLeft 1.8750393701
Selection.ShapeRange.IncrementTop 1.8750393701
Selection.ShapeRange.IncrementTop 1.8750393701
Selection.ShapeRange.IncrementTop 1.8750393701
Selection.ShapeRange.IncrementTop 1.8750393701
Selection.ShapeRange.IncrementTop 1.8750393701
Selection.ShapeRange.IncrementLeft -1.8750393701
Else
End If
Else
End If
'F1
If Cells(i, j + 130).Text = "3" Then
ActiveSheet.Shapes.Range(Array("Imagem 1688").Select
Selection.Copy
Cells(i, j).Select
ActiveSheet.Paste
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Else
End If
'F2
If Cells(i, j + 130).Text = "4" Then
ActiveSheet.Shapes.Range(Array("Imagem 1689").Select
Selection.Copy
Cells(i, j).Select
ActiveSheet.Paste
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Else
End If
' pré montagem
If Cells(i - 2, j + 1).Text <> "R" And Cells(i - 2, j + 1).Text <> "M" And Cells(i - 2, j + 1).Text <> "MI" Then
If Cells(i, j + 128).Text = "1" Then
ActiveSheet.Shapes.Range(Array("Picture 77").Select
Selection.Copy
Cells(i, j).Select
ActiveSheet.Paste
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Selection.ShapeRange.IncrementTop 1.0914173228
Range("Y73".Select
End If
End If
If PULAR = "NOK" Then
ActiveSheet.Shapes.Range(Array("Rounded Rectangle 239").Select
Selection.Copy
Cells(i - 2, j).Select
DesprotegerPlanilha
ActiveSheet.Paste
' 1° quadrante
' 5° OPÇÃO
If Cells(i - 2, j).Text = "F" Then
'edita grafico
With Selection.ShapeRange.Fill
.Visible = msoTrue
.ForeColor.RGB = RGB(46, 205, 9)
.Transparency = 0
.Solid
End With
Else
'6² OPÇÃO
If Cells(i - 2, j).Text = "P" Then
'edita grafico
With Selection.ShapeRange.Fill
.Visible = msoTrue
.ForeColor.RGB = RGB(147, 119, 103)
.Transparency = 0
.Solid
End With
Else
' 6° OPÇÃO
If Cells(i - 2, j).Text = "0" Then
'edita grafico
With Selection.ShapeRange.Fill
.Visible = msoTrue
.ForeColor.RGB = RGB(255, 255, 255)
.Transparency = 0
.Solid
End With
Else
'sondagem & topografia
If Cells(i - 2, j).Text = "ST" Then
'edita grafico
With Selection.ShapeRange.Fill
.Visible = msoTrue
.ForeColor.RGB = RGB(112, 48, 160)
.Transparency = 0
.Solid
End With
With Selection.ShapeRange.Line
.Visible = msoTrue
.ForeColor.ObjectThemeColor = msoThemeColorAccent6
.ForeColor.TintAndShade = 0
.ForeColor.Brightness = -0.25
.Transparency = 0
End With
With Selection.ShapeRange.Line
.Visible = msoTrue
.Weight = 6
End With
Else
End If
'SONDAGEM
If Cells(i - 2, j).Text = "SO" Then
'edita grafico
With Selection.ShapeRange.Line
.Visible = msoTrue
.ForeColor.ObjectThemeColor = msoThemeColorAccent6
.ForeColor.TintAndShade = 0
.ForeColor.Brightness = -0.25
.Transparency = 0
End With
With Selection.ShapeRange.Line
.Visible = msoTrue
.Weight = 6
End With
Else
End If
'TOPOGRAFIA
If Cells(i - 2, j).Text = "TO" Then
'edita grafico
With Selection.ShapeRange.Fill
.Visible = msoTrue
.ForeColor.RGB = RGB(112, 48, 160)
.Transparency = 0
.Solid
End With
Else
'Conferência
If Cells(i - 2, j).Text = "COF" Then
'edita grafico
With Selection.ShapeRange.Fill
.Visible = msoTrue
.ForeColor.RGB = RGB(0, 176, 240)
.Transparency = 0
.Solid
End With
Else
End If
End If
End If
End If
End If
'
' Inicio do 2° quadrante
'
j = j + 1
ActiveSheet.Shapes.Range(Array("Rounded Rectangle 240").Select
Selection.Copy
Cells(i - 2, j).Select
ActiveSheet.Paste
'5² OPÇÃO
If Cells(i - 2, j).Text = "F" Then
'edita grafico
With Selection.ShapeRange.Fill
.Visible = msoTrue
.ForeColor.RGB = RGB(46, 205, 9)
.Transparency = 0
.Solid
End With
Else
'6² OPÇÃO
If Cells(i - 2, j).Text = "P" Then
'edita grafico
With Selection.ShapeRange.Fill
.Visible = msoTrue
.ForeColor.RGB = RGB(147, 119, 103)
.Transparency = 0
.Solid
End With
Else
'5² OPÇÃO
If Cells(i - 2, j).Text = "0" Then
'edita grafico
With Selection.ShapeRange.Fill
.Visible = msoTrue
.ForeColor.RGB = RGB(255, 255, 255)
.Transparency = 0
.Solid
End With
Else
'6² OPÇÃO
If Cells(i - 2, j).Text = "MI" Then
'edita grafico
With Selection.ShapeRange.Fill
.Visible = msoTrue
.ForeColor.RGB = RGB(255, 255, 0)
.Transparency = 0
.Solid
End With
Else
'sondagem & topografia
If Cells(i - 2, j).Text = "ST" Then
'edita grafico
With Selection.ShapeRange.Fill
.Visible = msoTrue
.ForeColor.RGB = RGB(112, 48, 160)
.Transparency = 0
.Solid
End With
With Selection.ShapeRange.Line
.Visible = msoTrue
.ForeColor.ObjectThemeColor = msoThemeColorAccent6
.ForeColor.TintAndShade = 0
.ForeColor.Brightness = -0.25
.Transparency = 0
End With
With Selection.ShapeRange.Line
.Visible = msoTrue
.Weight = 6
End With
Else
End If
'SONDAGEM
If Cells(i - 2, j).Text = "SO" Then
'edita grafico
With Selection.ShapeRange.Line
.Visible = msoTrue
.ForeColor.ObjectThemeColor = msoThemeColorAccent6
.ForeColor.TintAndShade = 0
.ForeColor.Brightness = -0.25
.Transparency = 0
End With
With Selection.ShapeRange.Line
.Visible = msoTrue
.Weight = 6
End With
Else
End If
'TOPOGRAFIA
If Cells(i - 2, j).Text = "TO" Then
'edita grafico
With Selection.ShapeRange.Fill
.Visible = msoTrue
.ForeColor.RGB = RGB(112, 48, 160)
.Transparency = 0
.Solid
End With
Else
'Conferência
If Cells(i - 2, j).Text = "COF" Then
'edita grafico
With Selection.ShapeRange.Fill
.Visible = msoTrue
.ForeColor.RGB = RGB(0, 176, 240)
.Transparency = 0
.Solid
End With
Else
End If
End If
End If
End If
End If
End If
j = j - 1
ActiveSheet.Shapes.Range(Array("Rounded Rectangle 241").Select
Selection.Copy
Cells(i - 1, j).Select
ActiveSheet.Paste
'
' Inicio do 3° quadrante
'
'5 opção
If Cells(i - 1, j).Text = "F" Then
'edita grafico
With Selection.ShapeRange.Fill
.Visible = msoTrue
.ForeColor.RGB = RGB(46, 205, 9)
.Transparency = 0
.Solid
End With
Else
'6² OPÇÃO
If Cells(i - 1, j).Text = "P" Then
'edita grafico
With Selection.ShapeRange.Fill
.Visible = msoTrue
.ForeColor.RGB = RGB(147, 119, 103)
.Transparency = 0
.Solid
End With
Else
'6 opção
If Cells(i - 1, j).Text = "0" Then
'edita grafico
With Selection.ShapeRange.Fill
.Visible = msoTrue
.ForeColor.RGB = RGB(255, 255, 255)
.Transparency = 0
.Solid
End With
Else
'7 opção
'sondagem & topografia
If Cells(i - 2, j).Text = "ST" Then
'edita grafico
With Selection.ShapeRange.Fill
.Visible = msoTrue
.ForeColor.RGB = RGB(112, 48, 160)
.Transparency = 0
.Solid
End With
With Selection.ShapeRange.Line
.Visible = msoTrue
.ForeColor.ObjectThemeColor = msoThemeColorAccent6
.ForeColor.TintAndShade = 0
.ForeColor.Brightness = -0.25
.Transparency = 0
End With
With Selection.ShapeRange.Line
.Visible = msoTrue
.Weight = 6
End With
Else
End If
'SONDAGEM
If Cells(i - 2, j).Text = "SO" Then
'edita grafico
With Selection.ShapeRange.Line
.Visible = msoTrue
.ForeColor.ObjectThemeColor = msoThemeColorAccent6
.ForeColor.TintAndShade = 0
.ForeColor.Brightness = -0.25
.Transparency = 0
End With
With Selection.ShapeRange.Line
.Visible = msoTrue
.Weight = 6
End With
Else
End If
'TOPOGRAFIA
If Cells(i - 2, j).Text = "TO" Then
'edita grafico
With Selection.ShapeRange.Fill
.Visible = msoTrue
.ForeColor.RGB = RGB(112, 48, 160)
.Transparency = 0
.Solid
End With
Else
'Conferência
If Cells(i - 2, j).Text = "COF" Then
With Selection.ShapeRange.Fill
.Visible = msoTrue
.ForeColor.RGB = RGB(0, 176, 240)
.Transparency = 0
.Solid
End With
Else
End If
End If
End If
End If
End If
j = j + 1
ActiveSheet.Shapes.Range(Array("Rounded Rectangle 242").Select
Selection.Copy
Cells(i - 1, j).Select
ActiveSheet.Paste
'
' Inicio do 4° quadrante
'
'5 opção
If Cells(i - 1, j).Text = "F" Then
'edita grafico
With Selection.ShapeRange.Fill
.Visible = msoTrue
.ForeColor.RGB = RGB(46, 205, 9)
.Transparency = 0
.Solid
End With
Else
'6² OPÇÃO
If Cells(i - 1, j).Text = "P" Then
'edita grafico
With Selection.ShapeRange.Fill
.Visible = msoTrue
.ForeColor.RGB = RGB(147, 119, 103)
.Transparency = 0
.Solid
End With
Else
If Cells(i - 1, j).Text = "0" Then
'edita grafico
With Selection.ShapeRange.Fill
.Visible = msoTrue
.ForeColor.RGB = RGB(255, 255, 255)
.Transparency = 0
.Solid
End With
Else
'sondagem & topografia
If Cells(i - 2, j).Text = "ST" Then
'edita grafico
With Selection.ShapeRange.Fill
.Visible = msoTrue
.ForeColor.RGB = RGB(112, 48, 160)
.Transparency = 0
.Solid
End With
With Selection.ShapeRange.Line
.Visible = msoTrue
.ForeColor.ObjectThemeColor = msoThemeColorAccent6
.ForeColor.TintAndShade = 0
.ForeColor.Brightness = -0.25
.Transparency = 0
End With
With Selection.ShapeRange.Line
.Visible = msoTrue
.Weight = 6
End With
Else
End If
'SONDAGEM
If Cells(i - 2, j).Text = "SO" Then
'edita grafico
With Selection.ShapeRange.Line
.Visible = msoTrue
.ForeColor.ObjectThemeColor = msoThemeColorAccent6
.ForeColor.TintAndShade = 0
.ForeColor.Brightness = -0.25
.Transparency = 0
End With
With Selection.ShapeRange.Line
.Visible = msoTrue
.Weight = 6
End With
Else
End If
'TOPOGRAFIA
If Cells(i - 2, j).Text = "TO" Then
'edita grafico
With Selection.ShapeRange.Fill
.Visible = msoTrue
.ForeColor.RGB = RGB(112, 48, 160)
.Transparency = 0
.Solid
End With
Else
'Conferência
If Cells(i - 2, j).Text = "COF" Then
'edita grafico
With Selection.ShapeRange.Fill
.Visible = msoTrue
.ForeColor.RGB = RGB(0, 176, 240)
.Transparency = 0
.Solid
End With
Else
End If
End If
End If
End If
End If
j = j - 1
'caso a torre já estejá montada
Else
End If
Cells(i, j).Select
' pendência de projeto
If Cells(i + 1, j + 1).Text = "pp" Then
ActiveSheet.Shapes.Range(Array("Fluxograma: Somador 4").Select
Selection.Copy
Cells(i - 2, j).Select
ActiveSheet.Paste
Else
' Embargo sítio arqueológico
If Cells(i + 1, j + 1).Text = "s" Then
ActiveSheet.Shapes.Range(Array("Fluxograma: Somador 5").Select
Selection.Copy
Cells(i - 2, j).Select
ActiveSheet.Paste
Else
' Embargo proprietário
If Cells(i + 1, j + 1).Text = "p" Then
ActiveSheet.Shapes.Range(Array("Fluxograma: Somador 9").Select
Selection.Copy
Cells(i - 2, j).Select
ActiveSheet.Paste
End If
Cells(i + 1, j + 1).Select
End If
End If
End If
j = j + 3
Wend
i = i + 4
Cells(i, j).Select
j = 3
counter1 = counter1 - 1
Loop
TE: 'Tratar erro
End Sub
Rudney Estud... disse:Boa tarde pessoal,
Preciso separar os algarismos de varios números no excel em colunas ou linhas, utilizei a função =EXT.TEXTO, mas ela retorna somente texto e não consigo converter em número, pois preciso aplicar a função =SOMAQUAD nos alagrismos separados. Alguma ideia?
NOME | CÓDIGO INTERNO |
PEDRO | 11111111111 |
PRISCILA | 11111111112 |
CINTIA | 11111111113 |
MARIA 2 | 11111111114 |
MARIA 4 | 11111111115 |
PEDRO PAULO | 11111111116 |
VIRGINIA | 11111111117 |
PEDRO | 20011112222 |
PRISCILA | 20011112223 |
CINTIA | 20011112224 |
MARIA 2 | 20011112225 |
MARIA 4 | 20011112226 |
PEDRO PAULO | 20011112227 |
VIRGINIA | 20011112228 |
CLIENTE | MCI | CÓDIGO / BEM | VENDA EM |
CINTIA | 20011112224 | 525711700 CLIMATIZADOR ELGIN | 2020 |