Like Function in VBA/Macros

[fahadakbar]

Hello,

i am tring to run a "For Each" Loop in excel with the condition that if cells in selecton trends ("Like") with another range.

Range("A:A").Select
For Each MyCell In Selection
If Mycell.value Like Range("B:B")

Now I am not sure if I can run Like function against a range ... it works if i change range to a single cell

I want this because i have two column data, both contains client names, however names in both columns are slightly
different ... (Like Colum A has ABC INC and Column B has ABC INC. ) so idea is to replace name in column A with Column B

Thanks for Help

 

[Andrew Poulsom]

Welcome to MrExcel.

Are the names always adjacent to each other?

If Left(Mycell.Offset(, 1).Value, Len(Mycell.Value)) = Mycell.Value Then

 

[fahadakbar]

No they are not... it can be anywhere in column B... that why I am looking for a range

 

[Andrew Poulsom]

Maybe:

If WorksheetFunction.CountIf(Range("B:B"), Mycell.Value & "*") Then

 

[fahadakbar]

Thanks... i didnt get it completely, but i got another clue....