How to run macro with argument

[rahamtullah (Mohammed Rahamtullah)]

Hi @crazywindy,

Please refer these topics for help.

How to execute Macro with arguments

Hello, for the last few hours I’ve been trying to use Execute Macro activity and pass arguments but the macro doesn’t work as expected and I would appreciate some help. What I want to achieve is to copy a specific row, insert the copied row just below it, and insert a value in a cell of the new row. I’ve created a macro that works fine when running it from excel or when using Execute Macro activity without passing any arguments. But when I pass in a few arguments, even though the arguments are …

Execute Excel macro with argument throws range does not exist error

So, here’s the code in the XSLM file, Module1: Sub CloneTemplate(strName As String) 'strName = "wubba" Sheets("EXAMPLE").Select Sheets("EXAMPLE").Copy After:=Sheets(Sheets.Count) Sheets("EXAMPLE (2)").Select Sheets("EXAMPLE (2)").Name = strName End Sub Here’s the activity in my XAML: [image] Here’s the error: Source: Execute macro Message: The range does not exist Exception Type: ExcelException UiPath.Excel.ExcelException: The range does not exist ---> System.Runtime.…

Regards,
Rahamat