I am getting an error about append range. Here I am trying to past data starting in column F at the end of a file. I did the find first/last data row and used that saved value for the row number. But something is not working… Any ideas/tips/suggestions?
Hey
You have the range as “F-1” change it as a valid cell please regards
Pass the range as “F1” instead of “F-1”
Hi @Siafakas_Diane ,
The Range is specified as -1, are you performing any sort of filtering before writing it to Excel?
Do check the value of the first and last row in Immediate to pinpoint why the values are showing up as -1.
-1 is usually returned when a given value is not found.
Kind Regards,
Ashwin A.K
I don’t see any “-” in the value I am trying to use. Maybe something wrong with the “find last row” from a previous step.
Hi @Siafakas_Diane ,
That last bit is returning -1 because the value was not found.
Saved.Values(Of Int32)("LastRowIndex from Find First/Last Data Row").ToString
Have you tried using the Find First/Last Data Row Activity to find the last row?
It outputs the integer value itself.
Could you give that a try?
Kind Regards,
Ashwin A.K
Thank you! I have fixed the find first/last row and it seems to be working now 
Great @Siafakas_Diane !
We’d appreciate it if you could mark the answer as solution so that others facing similar issues may benefit from it also so that we can close this thread.
Kind Regards,
Ashwin A.K
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.