Hello group,

I am trying to create a Match code in VBA.

I can do it easily in the Worksheet eg.
=+MATCH(5,[TestB1.xls]Sheet1!$A$1:$A$18,0)
where Testb1.xls is the other open workbook

All my attemps at creating the macro have resulted in errors.
Any insights ?

Michael Singmin