.find problem passing a varibale

I would like to find the location of a cell that contains the same value as a cell in a different worksheet using the .find method.

Here is my code:

Please Login or Register  to view this content.

The first message box displays the value "NAME" in the box.
I recieve an error (Runtime error 91 Object Variable or with block variable not set)
This error happens before the second mssage box appears.

The code works if I replace

Please Login or Register  to view this content.

What do I need to do to get the variable containing a cell address to work with the .Find?

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



(I have added them this time. Please read all forum rules and comply in the future.)

Perhaps the Value in B3 contains a trailing space "NAME " and it cannot find an exact match.

Also, it may be better to include the other arguments for the .Find method to avoid unexpected results.

Please Login or Register  to view this content.

You're welcome. Glad it worked out.