Hi All,
In a sheet I find a value in column B. I use this VBA code
Set Found = Sheet3.Cells.Find(What:=VALUE1, After:=Sheet3.Range("B1"), LookIn:=xlValues, LookAt:= _
xlPart, SearchOrder:=xlByRows, SearchDirection:=xlPrevious)
I use the value in a different column (for example J) in the row found as
targe1tRow = Found.Row
I move this new value in variable VALUE1 and I try to find this value in column B in the same way.
Set Found = Sheet3.Cells.Find(What:=VALUE2, After:=Sheet3.Range("B1"), LookIn:=xlValues, LookAt:= _
xlPart, SearchOrder:=xlByRows, SearchDirection:=xlPrevious)
If I check the new value targe2tRow = Found.Row I find the same value of targe1tRow
I tried to reset the value in this way
Set Found = Nothing
but without success.
Any help will be well appreciated.
Thanks in advance for your kind support.
Regards,
Giovanni
In a sheet I find a value in column B. I use this VBA code
Set Found = Sheet3.Cells.Find(What:=VALUE1, After:=Sheet3.Range("B1"), LookIn:=xlValues, LookAt:= _
xlPart, SearchOrder:=xlByRows, SearchDirection:=xlPrevious)
I use the value in a different column (for example J) in the row found as
targe1tRow = Found.Row
I move this new value in variable VALUE1 and I try to find this value in column B in the same way.
Set Found = Sheet3.Cells.Find(What:=VALUE2, After:=Sheet3.Range("B1"), LookIn:=xlValues, LookAt:= _
xlPart, SearchOrder:=xlByRows, SearchDirection:=xlPrevious)
If I check the new value targe2tRow = Found.Row I find the same value of targe1tRow
I tried to reset the value in this way
Set Found = Nothing
but without success.
Any help will be well appreciated.
Thanks in advance for your kind support.
Regards,
Giovanni