ExcelCom _XLSearch (match entire cell contents?)

[Sorak99]

Hello,

is it possible with (or without) the ExcelCom when using _XLSearch to have it run under the assumptions of (match entire cell contents)?

For example when i use dog i will get cells with blackdog, whitedog, as well as dog.

George

[randallc]

Hello,

is it possible with (or without) the ExcelCom when using _XLSearch to have it run under the assumptions of (match entire cell contents)?

For example when i use dog i will get cells with blackdog, whitedog, as well as dog.

George

You could do this yourself; just search the array generated for complete matches to give a new array of results

Best, Randallc

[Sorak99]

Thanks Randall,

I should have thought of that , getting better with the ExcelCom too, just taking me a while