Find(what:= range("A1, B2, C3, D4") 1

[heizer]

Hello!

The problem is:
I need to find the four cell that have the same value "99" in below configurations

A B C D
1 99
2 99
3 99
4 99

A B C D
1 99
2 99
3 99
4 99

Can anyone help me?
Thanks for everyone!

 

[xlbo]

Use the FIND / FINDNEXT functions in columns A

There is a very good example for findnext in the excel VBA help file

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[heizer]

Hi, all!

I want only added:
this post is a crossing post
[

http://www.ozgrid.com/forum/

- 45k]

thanks

 

[SkipVought]

meaning what?

Skip,

_{Did you hear what happened when the OO programmer lost his library?...
He's now living in OBJECT poverty!}