Passing Argument to Excel Macro

Feedback Activities
, ,
20

Hello everyone,

From what I’ve done and researched up until now, I saw that after creating a macro with parameters, UiPath is not running the macro anymore, or the modifications are not saved(which makes no sense). Is there some kind of bug? I mention the fact that i’m not receiving any kind of error.

my example:
//ading a new line

Sub newLine()

Dim value As Integer
value = int1
With ThisWorkbook.Worksheets(“Sheet1”)
Sheets(“Sheet1”).Range(“A” & CStr(1)).Select
ActiveCell.EntireRow.Insert shift:=xlDown
End With

End Sub

in execute macro i have “newLine”
=>working

Sub newLine(int1 As Integer)

Dim value As Integer
value = int1
With ThisWorkbook.Worksheets(“Sheet1”)
Sheets(“Sheet1”).Range(“A” & CStr(int1)).Select
ActiveCell.EntireRow.Insert shift:=xlDown
End With

End Sub

in execute macro i have “newLine(1)”
=>not working

Is this some kind of bug? Am I doing something wrong?
Here is the file macro_newLine.zip (14.7 KB)

1 Like