Application.WorksheetFunction.Match in VBA

Hi,

I am trying to match a value to another sheet in the workbook. I am trying to use Application.WorksheetFunction.Match but I am not getting correct results.

My code for the match:

Please Login or Register  to view this content.

I also tried the followiing code but still incorrect results.

Please Login or Register  to view this content.

I appreciate any direction you can provide.

Thanks

Comment out the On Error Resume Next to see how it fails. I suspect though that you do NOT need the dot in front of "sheets"


Regards, TMS

What results are you getting and how are they incorrect?

Ok, so that seems to confirm it is the MATCH. Can you post a sample workbook?

If you look on my upload tab I have a double check for the site id. It is in the site id column (the value searched for) and it is also the first 8 letters of the project ID. They do not match. If I don't have the correct row number it is pulling in an incorect project ID as well as others.

Thanks for your help.



Never mind TMS. I figured it out. My range on shtMod needed to start on row 1.

Thanks!

Thank goodness for that. I don't think I was ever going to find it!




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


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

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


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.