Code:
Sub fire
Range("A9:C2629").Select
Selection.Replace What:="100.00%", Replacement:="100.00001%", _
LookAt:=xlPart, SearchOrder:=xlByRows, MatchCase:=False
End Sub
Sub fire
Range("A9:C2629").Select
Selection.Replace What:="100.00%", Replacement:="100.00001%", _
LookAt:=xlPart, SearchOrder:=xlByRows, MatchCase:=False
End Sub
ovim makroom pokusavam da zamenim od 9-tog reda pa nadalje tamo gde pise 100,00% sa 100,00001%.
ali ne funkcionise. ne prijavljuje gresku, ali ni ne zameni brojeve.
jel neka greska u kodu ili??
hvala unapred!
[Ovu poruku je menjao 3okc dana 13.03.2012. u 02:31 GMT+1]