confused about runtime error

I have this piece of code

Please Login or Register  to view this content.

ar and val both return numeric values but the last string of my code returns "run-time error '1004': Application-defined or object-defined error.

Any ideeas? tnx.

That works great, thank you very much. If I could ask one more thing. I need a range of cells that have the same value.

Please Login or Register  to view this content.

this only gets me the first value. How could i get all of them?

figured it out ty.