I am using a macro that currently looks up a range in a sheet within the same file, but I want to split these files up and therefore need a macro that will search the required value in a file located on sharepoint and return the correct value.

So far i have set up so that the macro goes and opens the required file in share point, but i cannot get the syntax of the macro line correct so that it runs. Instead i get an error.

Please Login or Register  to view this content.
DelivActiveEnd are just variables given to a number. TRMWB is the workbook using the specfifec link given in cell D6 on input sheet.

Please Login or Register  to view this content.
Any ideas would be greatly appreciated.