I'm here with some problems, I never moved in Visual Basic and was seeing if it helped me to make a listing that I have in Excel faster (Through Visual Basic Excel).
It's very simple, I just want to look in the array if you have a word that has less than 3 letters and if you have, delete the word or do replace
for "" (which I think is to have nothing too) >
I had something like this, but it is not working, it returns:
Object required
My code:
nome = Target(1, 1)
nomesArray = Split(nome)
Dim i As Integer
i = 0
While i < UBound(nomesArray, 1)
If Len(nomesArray(i)) < 3 Then
nomesArray.Value = Replace(nomesArray.Value, nomesArray(i), "")
End If
i = i + 1
Wend
Can anyone help please?