Find Method returns a string instead of a Range

For some reason, it seems that this following line returns the value its supposed to be searching for instead of the range where it finds the value.

Please Login or Register  to view this content.

Any ideas on why this might be the case?

Thanks

Hello Kaigai,

You're probably referring to the tool tip in VBA that shows the result of the find when you place the mouse on the variable. It will display the cell contents. To return the address, do this...

Please Login or Register  to view this content.

Also, you should get into the habit of declaring your variables. This can save you major headaches in coding.

However, if the search fails then dir_ee will be set to the special variable Nothing.

Hello Kaigi,

Set is used to assign an Object variable to either an existing object or a new object. If you know the object type your object variable will be assigned to, you should declare it as the assigned type.

For example, in your code the variable dir_ee is being assigned to a Range. You can then declare dir_ee as a Range like this...

Please Login or Register  to view this content.

Sometimes you don't know the type of object returned. In this case assign your object variable as Object. This is a generic form that accepts all types of objects. The drawback is you don't get the IntelliSense feature which shows the object's properties, methods, and events as you type in VBA.

Please Login or Register  to view this content.

Hello Kaigi,

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save