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.

If Not IsError(Application.Match(Range("A1"), Range("DifferentWorkbook.xlsm!Namedrange"),0)) then
I am sure its something simple I am doing wrong - but just havent been able to find the answer.

Thanks for any help