Make a Change to Code

[Steved]

Hello From Steved

Set FoundCell = Sh.Columns(1).Find( _
what:="2220")

At the moment the Above only finds a single Value.

Can I expand it to find 3 Value's in the same row please.
The "2220" Value is in Col A But Value "267"and "6.00"
is between Col B and Col AK in the same Row.

Set FoundCell = Sh.Columns(1).Find( _
what:="2220","267","6.00")

Thankyou.

 

[Otto Moehrbach]

No, you can't do that. What you can do is use the Find statement you have
to find the first value, then get the row of that first value, then use two
subsequent Find statements to search that one row to find the other two
values.
HTH Otto

 

[Steved]

Thanks Otto

-----Original Message-----
No, you can't do that. What you can do is use the Find statement you have
to find the first value, then get the row of that first value, then use two
subsequent Find statements to search that one row to find the other two
values.
HTH Otto



.