Help with VBA code

[Shani]

Column A has values such as http://google.com/news
Column B has values such as http://google.com

I want to write a for loop so that

for i =1 To iLastRow
If Cells( i, 1 ) Like Cells( i, 2 ) Then Cells ( i, 1).Value=
"Whatever"
Next i


This for loop doe snot work. I think the Like is no working correctly.
It works fine when
Cells( i, 1 ) Like "*cat*"

But does not work when comparing with a cell for example If Cells( i, 1
) Like Cells( i, 2 )

[Bob Phillips]

For i = 1 To iLastRow
If Cells(i, 1).Value Like "*" & Cells(i, 2).Value & "*" Then
Cells(i, 1).Value = "Whatever"
End If
Next i


--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"Shani" <[email protected]> wrote in message
news:[email protected]...
> Column A has values such as http://google.com/news
> Column B has values such as http://google.com
>
> I want to write a for loop so that
>
> for i =1 To iLastRow
> If Cells( i, 1 ) Like Cells( i, 2 ) Then Cells ( i, 1).Value=
> "Whatever"
> Next i
>
>
> This for loop doe snot work. I think the Like is no working correctly.
> It works fine when
> Cells( i, 1 ) Like "*cat*"
>
> But does not work when comparing with a cell for example If Cells( i, 1
> ) Like Cells( i, 2 )
>

[Shani]

thanks