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.

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" wrote in message
...
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.

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
"Steved" wrote in
message
...
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.


.