"Run time error 1004-Method ‘Range’ of object’_Global’ failed" while executing an Excel macro

I have an Excel application scope opened which has 7 command buttons to invoke different macros. While invoking them I need to have another excel file to be opened.So I’v used Excel application scope-2 inside the first one and invoked macros.
But it is not running the macro, instead it throws the below error window. But strangely macro executes while run it manually. Where could it have failed?


Kindly keep this excel application scope first and keep it open from the beginning while then use excel application scope and open the one where we need to click on the macro button
Like one after the another and not inside one another

—the coming to error
Kindly have a view on this error

Hope this would help you
Kindly try this and let know for any queries or clarification
Cheers @SudhakarAs92

1 Like

I hope the range in the Macro you are trying to invoke belongs to the first excel and when you try to invoke the same Macro in the second excel, due to the incorrect range, the error occurs @SudhakarAs92.

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.