Unable to use copy/paste range

[Sneha_1992 (Sneha)]

Hi Team, While working with excel I am facing an issue with copy/paste range activity

what ever I give in range it is not working

[vrdabberu (Varunraj Dabberu)]

Hi @Sneha_1992

change the range as V2:V doesn’t work for the activity.

Regards

[Sneha_1992 (Sneha)]

its already V2:V. even this is not wokring

[vrdabberu (Varunraj Dabberu)]

The range provided by you doesn’t work so i’m asking you to try changin the range and it will work. @Sneha_1992

Regards

[mkankatala (Mahesh Kankatala)]

Hi @Sneha_1992

You can use the Find first/last row activity to get the last row count of the specific column, then give the range as below,

Excel.sheet("Sheet name").Range("V2:V"+Lastrow.toString)

Hope it helps!!