Unable to use copy/paste range

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

Hi @Sneha_1992

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

Regards

its already V2:V. even this is not wokring

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

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!!

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.