If i know the coluumn A hav value like A1:A3 but I want the paste value in W2 : W7
i will get the count row of col A so If i get the 3 row then how i put the value in W1:W3
Hello @dhanu_lokhande
Try this
- Read range activity- Read data from A1:A3 and store variable as DT
- Write range activity- Write data
"W1:W"+DT.Rows.Count.tostring
error come as value of type of string can not be converted data table
@dhanu_lokhande
Use Datatable variables for read range activity.
Share the Error screenshot if possible
Hii @dhanu_lokhande ,
Actually You were updated the range in the wrong place. You have to put the Datatable name where you put the range. Whatever “W7:W”+db.rows.count.tostring is there that should be updated in right Upper corner.
Cheers 
2 Likes
@dhanu_lokhande
Here you should pass the data table variable from the read range.
