@ppr @supermanPunch @Sree_Krishnan_vellinezhi
Function Macro1(Output) As String
Set Sickness_Registration_WB = Workbooks.Open(“C:\Users\Documents\UiPath\Test\Input\Input.xlsx”)
Set Sickness_Registration_WS = Sickness_Registration_WB.Sheets(“Sheet1”)
Sickness_Registration_WS.Activate
Set Inputdt_WB = Workbooks.Open(“C:\Users\Documents\UiPath\Test\Input\Inputdt.xlsx”)
Set Inputdt_WS = Inputdt_WB.Sheets(“Sheet1”)
Set Inputdt1_WS = Inputdt_WB.Sheets(“Sheet2”)
Inputdt_WS.Activate
lastrow = Inputdt_WS.Range(“A” & Rows.Count).End(xlUp).Row
Inputdt_WS.Range(“G1” & lastrow).AutoFilter Field:=7, Criteria1:=“Menn”
Output = Inputdt_WS.Range(“A” & Rows.Count).End(xlUp).Row
Balanceworkings = “1”
Done:
Exit Function
eh:
Var1 = Err.Description
Balanceworkings = Var1
End Function
In this case i am not getting any value in output variable , i need to pass this output variable to uipath.
Pls help !!!