Copy paste in Range not working

Hello Friends

Below is the code, I am trying to copy value from wks1.range("S2:S200") but copying only 1 value, so can you guys help me on this.

Please Login or Register  to view this content.

Another way:

Please Login or Register  to view this content.

Thank you so much AB33,

Rep Added

Hi AB33

What would be the shortcut code for below.

Please Login or Register  to view this content.

Would this work?

Please Login or Register  to view this content.

Not working
error line

Please Login or Register  to view this content.

Run time error 1004
Method 'Range' of object'_worksheet failed

You are getting an error because you need to include the object variables-wks1 and wks from your code in to jolivanes' code
You can not use jolivanes' as it is. His code assumes that you have variable wks1 and wks .

Thanks AB33.
Yes, indeed. The OP did not show any of his code, with the exception of the one line, so I assumed he had all of this in the rest of his code.

Hi AB33 & jolivanes

Please see below code

Please Login or Register  to view this content.

Try this maybe

Please Login or Register  to view this content.

Thanks jolivanes

Rep Added