How to use studiox to drag a value all the way down in excel

[Mark_Rajkumar (Mar)]

Hi there,

I am using studiox. I am trying to use autofill to drag a value down. However i dont have know how to use activity. Can i get an example scrrenshot without an xaml attachment over here.

Thanks!

[Anil_G (Anil Gorthi)]

@Mark_Rajkumar

Hope this helps…So basically you have to provide the range starting from the cell you have data and till the row you need.Here A2 is where the first data or the formula is present

cheers

[Sudharsan_Ka]

HI @Mark_Rajkumar

You can even give only the start row address , it will be auto fill upto the last row
Click on this and in expression editor give your expression like

Excel.Sheet("YourSheetName").Range("StartAddress")

Regards
Sudharsan

[Mark_Rajkumar (Mar)]

Thanks @Sudharsan_Ka it worked.