Application.Run with cell reference

[sarabjitjoshan]

Hi,

Help!!

I am trying to call a Macro from another workbook names "My_Data by xxx_19 Nov 16.xlsm".

I have refrenced the name of this file in Cell F3 and Name of the Macro in Cell H3.

Application.Run (Range("F3").Value & "!" & Range("H3").Value) gives me the following error:

Run-time error '1004':
Application-defined or object-defined error


Regards,
SJ

 

[RoryA]

Welcome to the forum.

Try this:

Application.Run "'" & Range("F3").Value & "'!" & Range("H3").Value