vba e macros
DESCRIPTION
Programação sem complicaçãoTRANSCRIPT
%&'(89)4&'*9
012456789
57899
74
!"#$
wxyz{|z}~|xyz
+,-./0123/456789:.:6/6;/0:.60/6:?6>/@6/6ABCD56+EE/6;F.:>:6/6BCG+H568F6F6+,-:.SF?/ET56L1,2U:E6V:W,80FE6X:?/6YE1Z.8/[567//X6:6H/,-./?:60:6L?1=/\56L].@1?FE6/@6L8?-./6CSF,2F0/4N56YEF,0/6/6ABC6XF.F6H.8F.6iF9:?FE6V8,j@8>FE4T56a6;/0:.60/6:?4[56A8E1F?8OF23/60:6VF0/E6:6L/.@F-F23/6H/,08>8/,F?4\567:,0/6:6h.FSF,0/6,F6k:94`56H.8F,0/6VFEl9/F.0E6>/@6b8,8f.ZW>/E6mGXF.n?8,:Eo66,/6:?6Dc4c4d56C1-/@F-8OF,0/6/6k/.04e56bF-.8O:E6mC..FpEoDc56;./>:EEF@:,-/60:6C.q18S/E60:6i:=-/D456YEF,0/6/6C>>:EE6>/@/61@6BF>n6:EE/6b1?-81E1Z.8/6F/E6VF0/EDD56H.8F,0/6H?FEE:Er6P:f8E-./E6:6H/?:2U:EDN56is>,8>FE6CSF,2F0FE6XF.F6YE:.Q/.@EDT56C;+6k8,0/tED[56780F,0/6>/@6./ED`56H.8F,0/6G1X?:@:,-/E6mC00u+,Eov,08>:
01234567894616
"#$%&'()*+,)(-)'+.)/0,2'34'%$)'-).)+')-'56/&'()/'/0*7))68'9/0)6/0;')''&,A$(=A@)56>)-)#'')>).3)27)&',A$(';''3>)%'A5V'VU)U)(5V`)+/05V>).)2,'0;'$@U)()>)/0>),)'V-)>)7'0-56,)'V-)>)))7))$-')''>),)7)$)'`,'0307)=%(3'-)B'(/01_!_//'),A@)56/').)'+-56,A@)5V/').)b/0-))c.)-)'/.)U)()>)/0',C'@c.)@)5V3,>)/0)>));'.)+Tb$('X5V.Z([=B8345;87886893:;98D;E6382368964963634634G8H5B;E89B8345;87886893:;989;23449696K3348B89L693:;98B8346B3KN583487886893:;984493834B8;EOP68469843634634RS5629T@UR467A65468R86465;V68W93:;9966;383478;83L465;87886893:;98R38E88B3A6TX86;286Y834B8896Z984A83C848487886893:;98Y834B8;E467[E286B3834@[;646V6N
4N5E83489886;766\7;6654346834B]95E8878R9638N63;3834B^586;383938P6846286B38348_46;46B8K98CU9;45D
BE834V68WE88B848R45`8345;B3a5346984`83478358;6369578263465;87886893:;98Y834`B39658Y834`46359896K334D6N;638CU46984E88`85;87886893:;98`8345;87886893:;9846_G4RY834B3a53@;68438@Z98B3a53@;6847]@Z98G;8C?64B3a53@;684@Z9896E696848Y;b63LY8345;B3a53@;684E885;87886893:;984;^98Y834_58B8896Z98487886893:;98B8;EB8958446984263B89584Y834cdefghijklE88`85;V694646834G8H54R8
48m5896N3B3KN58C?6E88G8H54V68W
D5E;34D5886;B8;E9;7[E8G3L8RW;R8nop)%q0.)*_E68C?69;4s5AG84s5A465;96W
2;E8BD2G65;7t7236E88876;W86438]X
/01=>=>====FFIFJFMFMFQFFFFIIIIIIIMI=I=IFIIIIIQIFIIIIIIJIJIMIMIMIQI>I=/rIFIFIIII
962560464604452469625446544965464504
64464664
4
66296234569!1#549623456$5256469623456$525646962345662945&'(6966412*43+62129623456-5534564014440195-6642'(696556449!1056
69!105602-4642'(696556
6466465&60566/2469!10(696121!54646+56534564'(6
562596+214'(6$35
32593166260345641'(669752684295+'(6465&
9564462469!19504625
5464:5;1:5;1056662059:155162646(6545655'?9496'?@57455'?/16-6555
63454555649752606$2=$$C(%%D52+3)*#$+0,&&A="!!!*(!*(*()##!!#!!!%2(!#0##B*(4*(9!#($$(6107!(!#(4!C,%5(#(!!!(#/#"!./4#!(*(!+!.!!%:4!D,+!#EF*("(+.1%#G",#0"!#!#!!H!IE%2(!+(!")+!+!!##+(1J$(*(#01!!*("(+#/%:4!D!!+EF!!+E%#%+: KDL%5C!/(MNO8I!P(!Q!#!%R)*(K!,!4(4!,#&&&*(9!#!%
012345683925696
!"#$%!&!'(('!)*+,-.!'%!/0'1!,!(1!'((!23456789643:8;??73:6@3CDEFGH/'"!%'!!I!%!,-.!'D$J/D'/+'!#$+FGHK!/!0'1-.!'D'+"!%(,-.!'0'1D
fghijklmnjOopqrOq80stuv0
0123456839256960L3MNO3923PQRS6T0x2S6563593S9y39zQ456956o{3o334269o9[3QQ93Z64R34}y39qQ[6~SNQ9SQR6953Z5Q~66423F!%U0!!!'"DVK,W'0!"0+U S{Q699969
0L3MNO3923PQRS6T
"!%!"1!FGHIUJ()X''1D
835YZSR53[S345QY56
-$)X/"&1''&DE\]'^0U!I"!%""'K,/_("!XU!DE\]'`K"!%.'!FGHDE\]'a(!/'&I!!"'!J''Db!&(\]'c+"/I!!)`dU)*I,!]'DE\]'d/'FGHDE!!]'!(0'1"'"'()X'10ce'1D
ww|
0 1234567895
!"#$%'()#'(*++,*++-
#).#
/##0$%&"#(#""#12#'(34)
#5
.0#'(*++!#'(*++)606
#
#0$%&
7.0
80""
0
59#
1
+#4(##/04#"##
52#
"1#'(
:;?@;>=;ABC;>=;DEF?G
H
,)I
#
19
##.
59#0/6)J&15#.#KL"
#
459#1
M*N
##0O#
(.##$%'(
#N7#1452###)P.)0/6QRSTUVWXYZR[
459#0
#\)P#
]=^_?F`a?^b=;cdF^`F=;e?F?ffg@`=;hi@i;jk`@;ChG`Film?f
8
4QTUUTnR[
52/#
*+*#
0159"1#(.####&&I
#.###&.
1o
52
/#&"
o
0/1#'(
**)"(
52).0$%#1#0
##$%
*,#15#
*M
0
#4
#&p3P#q
*NI*!#
#)4#TrrsXYR
Dff?;t`u@=;D^f`^i;DEF?Gv
&w#"/I##\
+x#
#\""1/
#I#)yz..0w'(w)"7#w'("
M*x#/{#"I#|
0#+
#
#'(0/.'(&15#
#'9/#'()#}#,+M+y#
w)#
#
/p)##z.00"#1o"9#I14
#
.
/
.#K~0#)
0I##p()0I40)#
0#61
9
#
y
""#4$o..'(')y")""##)14N7x#
9y
#.#K
)14)59#y4#
{+p|#
.
#K)#
4
0
$%&)
02345674894
!"#$!#%#' (#)*+#&)*",#*-,,#*#*.$
/@KTX0X/Fx@0yA/xKzAL0@h/7@xL@X/F07Kx{LLXxX/
/890132038940405670544132008058909484:4;8894