copying and pasting a dynamic range

Hi, I have successfully copied and pasted a range into another sheet, however, the range is ever-changing as I am using the RAND function in the range. But I have only pasted the values, and of course, these do not change when the range changes.

Is there a way to code this up so the range i pasted changes when the original range changes i.e. when pressing F9?

Here is my code so far below

Please Login or Register  to view this content.

Thanks for your help and time

Hi,

Yes just use

Please Login or Register  to view this content.

Rgds