Activity find LastRow error?

Help Activities
, ,
1

I use activity find LastRow but show error as below ?

image
image1244×513 38.9 KB

image
image1174×244 11 KB

Please guide me for solve it.

2

@fairymemay

Try round braces instead of square brackets and then check once.

3

I had the same issue as you a couple of days ago. Turns out that even if you do provide an variable in the activity itself, it does not “transfer” it to the properties panel.

Check if all provided variable also exist in the properties panel.

billede
billede883×449 28.1 KB

4

Hi @fairymemay ,

Just to see how the activity works, could you try passing in the Range into the Source Field ?

image

Kind Regards,
Ashwin A.K

5

@fairymemay Try below steps, it solves your issue

  • First take Use Excel File activity

Capture
Capture357×466 6.47 KB

  • Provide your excel path in the Excel File field
  • Within the do keep Find First/Last Data Row activity
  • Now change the expression in the source field to
Excel.Sheet("Sheet1").Range("A1:C3")

This would work. Also, below link for ref