Problems With VBA Find Method

[Belthasar]

Hello!

I am using the "Find" method in VBA to search for a defined term and select the cell that is returned. Here is the code:

Please Login or Register  to view this content.

On my machine, this works perfectly. However, after sending it to colleague who is running a German version of Excel 2010, it no longer finds anything. Here's the strange thing: I've walked him through simply recording a macro using the "Find" function in excel, which correctly identifies the matching cell as he's recording it. However, once he tries to run the code he's recorded, it throws an Error 91 since it hasn't found anything.

His recorded macro looks exactly like the "Find" block in my code, except that it activates the cell instead of selecting it.

Please Login or Register  to view this content.

I cannot, for the life of me, understand why this is not working. If anyone has any ideas, they would be greatly appreciated.

[The_Prist]

Try

Please Login or Register  to view this content.

[AB33]

How is the code working with out setting a range and testing if it returns a true or not?

[The_Prist]

You may use this code also:

Please Login or Register  to view this content.

[AB33]

The_ Prist,
That is exactly what I was referring to.