VBA Refer to named range in different workbook

I have been trying to program a macro, which will check if a value exists within a dynamic named range in a different workbook.
I had several problems originally with the code for the MATCH part of the code even within same workbook until found the answer to use application.match instead of worksheetfunction.match, but am still having problems with looking into a different workbook.

Please Login or Register  to view this content.

I am sure its something simple I am doing wrong - but just havent been able to find the answer.

Thanks for any help

seems to be equally effective on same workbook, but i think my issue is with the syntax i am using to call the named range from a different workbook

Please Login or Register  to view this content.

Is this the correct way to call that range, or is it some form of workbooks("Differentworkbook").range("NamedRange") etc..

ok thanks guys