1
ola thank you for your attention.
I need to compare the value of the last filled cell with the antepenultimate. if the value is different I want to continue with the current value if seje = place the word error
this is being necessary because in my code is loading the result of the previous search
.Document.all("cpf").innerText = Range("a" & linha)
.Document.all("btn_consultar").Click
Application.Wait (Now + TimeValue("00:00:01"))
Range("g" & linha) = IE.Document.all("teste1").innerText
Range("b" & linha) = IE.Document.all("teste2").innerText
Range("d" & linha) = IE.Document.all("teste3").innerText
Range("e" & linha) = IE.Document.all("teste"5).innerText
Range("f" & linha) = IE.Document.all("tesste2").innerText
Range("g" & linha) = IE.Document.all("5353fsf").innerText
menos1 = linha - 1
linha = linha + 1
MsgBox ("linha")
MsgBox ("menos1")
Application.Wait (Now + TimeValue("00:00:01"))
Wend
Wend
Wend
End With
End Sub
Thays good evening, this comparison is in column or row, in this range have blank cells?
– Paulo Vieira
hi paulo good night, are in column and a sequence of Cpf that I play in the system and returns me a value in the cell Range("d" & line) = IE.Document.all("msisdnClient"). innerText however the result is repeating when negative. then I would like to compare the result with the previous line if it is equal to the previous one to fill in with error or something like that
– Thays Lima