Hi all.
I'm working on a project in which it'd be nice to have a worksheet function
comparable to the LIKE operator from VBA.
E.g. the names on the worksheet aren't all spelled exactly the same, but
match in general.
Does any one have any idea on what it would take to create a worksheet
function for the LIKE operator?
My VBA skills are no where near that advanced, so I thought I'd come here to
get an idea on the logic involved in the operator.

Thank you.

Scratch this request.
I found John Walkenbach's IsLike function.
Thanks.


"Steve" wrote:

Hi all.
I'm working on a project in which it'd be nice to have a worksheet function
comparable to the LIKE operator from VBA.
E.g. the names on the worksheet aren't all spelled exactly the same, but
match in general.
Does any one have any idea on what it would take to create a worksheet
function for the LIKE operator?
My VBA skills are no where near that advanced, so I thought I'd come here to
get an idea on the logic involved in the operator.

Thank you.

Hi,

COuld you share the link

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Steve" wrote in message
...
Scratch this request.
I found John Walkenbach's IsLike function.
Thanks.


"Steve" wrote:

Hi all.
I'm working on a project in which it'd be nice to have a worksheet
function
comparable to the LIKE operator from VBA.
E.g. the names on the worksheet aren't all spelled exactly the same, but
match in general.
Does any one have any idea on what it would take to create a worksheet
function for the LIKE operator?
My VBA skills are no where near that advanced, so I thought I'd come here
to
get an idea on the logic involved in the operator.

Thank you.