Hi there,
How to use excel to drag a text to the last row?
Excel.Sheet(“Yoursheetname”).Range(string.Format(“A2:A{0}”,Saved.Values(of Int32)(“Last row index from Find First/Last Data Row”).ToString))
I tried above syntax using fill range but i insert my range as B7:B{0}. It pops an error the range does not exist.
Can advise please.
Thanks!
HI @mark_rajkumar1
You dont need the end range address if you are using Modern Excel Activities
give like this
Excel.Sheet(“Yoursheetname”).Range("A1")
Above will automatically fill upto last row
If this not works
- First read your range and store them in a datatable
- Then use Fill Range activity
Excel.Sheet(“Yoursheetname”).Range("A1:A"+(ReadrangeDTVariable.Rows.Count+1).ToString)
Hope this Helps!
Regards
Sudharsan
@Sudharsan_Ka i tried both the method its not working. Can advise other methods?
@Sudharsan_Ka i use click activity by putting the cursor in the bottom edge of the cell
system
(system)
Closed
5
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.