"Run time error 1004-Method ‘Range’ of object’_Global’ failed" while executing an Excel macro - Unable to handle excel-pop ups

Help
,
3

Hi,

Now it is displaying a new error.

“Run-time error ‘1004’ : Method ‘Range’ of object’_Global’ failed”

Any idea as to when this popup appears. ?
Because i’m unable to reproduce this popup when i manually trigger the Macro. It worked fine on manual trigger. However it appears when triggered via “Execute macro” activity.

PS: I need to trigger this macro in Excel1, while Excel2 is opened.

Untitled