V
Valeria
Dear experts,
I need to compare 2 ranges of data by a concatenation of cells (for both). I
have the following code
For i = 1 To 10
Set f = sha.Range("a" & i & ":d" & i).Find(what:=shb.Range("a1:d1"),
lookat:=xlWhole, LookIn:=xlValues)
If Not f Is Nothing Then MsgBox f.Address
Next i
But it does not do what I want as it just stops the comparison at the first
cell value, it does not concatenate the values of the range.
Could you please help me?
Many thanks in advance.
Kind regards
I need to compare 2 ranges of data by a concatenation of cells (for both). I
have the following code
For i = 1 To 10
Set f = sha.Range("a" & i & ":d" & i).Find(what:=shb.Range("a1:d1"),
lookat:=xlWhole, LookIn:=xlValues)
If Not f Is Nothing Then MsgBox f.Address
Next i
But it does not do what I want as it just stops the comparison at the first
cell value, it does not concatenate the values of the range.
Could you please help me?
Many thanks in advance.
Kind regards