Activity find LastRow error?

Help Activities
, ,
5

@fairymemay Try below steps, it solves your issue

  • First take Use Excel File activity

Capture

  • 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

1 Like