Using LookAt:=xlWhole constant with Find-Not working

[Pawnar]

Hello Team,

I'm quite new to VBA and need your help!!

I have a range B2:B7 wherein two names are available Rahulkhera singh and Rahul Kumar, I need to find out separately each name. I'm able to find out Rahulkhera with the help of xlPart one of the parameter of Find. But it is not working with LookAt:=xlWhole, getting error - Object variable not set (Error 91)

I'm attaching a file for your reference. Please do the needful.

Thank you.

Regards,
Manish

[davsth]

It is not clear what you want to do from you example


To match the whole, the whole cell has to match your text your are searching for, nothing in the cells is just Rahul so it will find nothing

To match part Rahul would match in both names as they both contain Rahul

[sintek]

Depends what you want to do you want to do with these names once found...
One option...

Please Login or Register  to view this content.

are other options aswell...Loop, Array, formula etc etc

[davesexcel]

You can't look at xlwhole unless you use wildcards.

Here is a find loop

Please Login or Register  to view this content.

[Pawnar]

I'm sorry for the confusion here!!

I was just able to solve the problem. Your explanation does match with my result.

In order to match whole, I should have used the whole word that contain in cell for find parameters.

Thank you for your support.

Regards,
Manish

[Pawnar]

Thanks a lot!!

Warm Regards,
Manish

[Pawnar]

Thanks a million.

Warm Regards,
Manish