I have a list and I want to always select the last item in it to paste into an excel spreadsheet. I thought I could create a new variable containing the number of records in the list, then use this in the write to excel command - actually, in the example below, I want to get row 2, the last row with data in it.
How would I write the value in row 2 to excel using the 'write to excel worksheet' command
