Drag and fill the text in a row to the last row studiox

[mark_rajkumar1 (mark rajkumar)]

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!

[Sudharsan_Ka]

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

[mark_rajkumar1 (mark rajkumar)]

@Sudharsan_Ka i tried both the method its not working. Can advise other methods?

[mark_rajkumar1 (mark rajkumar)]

@Sudharsan_Ka i use click activity by putting the cursor in the bottom edge of the cell