Mutliple .Find Criteria

[quej2003]

Hi

Just wondering if it is possible to have multiple criteria for .Find in VBA, tried using union to overcome this but to no avail!

Cheer

 

[Andrew Poulsom]

Hi

Just wondering if it is possible to have multiple criteria for .Find in VBA, tried using union to overcome this but to no avail!

Cheer

Such as? The answer is likely to be no.

 

[quej2003]

Such as? The answer is likely to be no.

Set Found = Columns("AA:AZ").Find(what:="SH", LookIn:=xlValues, lookat:=xlWhole)

Where SH is a text string, just aiming to have more than SH

 

[Weaver]

You could make a list and perform a find for each item in turn, with perhaps a range (using union to add new results) that records the cells of all the 'hits'.

Kinda depends on what you want to do with the results.

 

[quej2003]

You could make a list and perform a find for each item in turn, with perhaps a range (using union to add new results) that records the cells of all the 'hits'.

Kinda depends on what you want to do with the results.

That works lovely in fact, hadn't thought of doing something quite like that, thank you kindly sir.

The only thing I was doing with my hits is simply finding the column that its in really.