Relative Range Selection

I am struggling with the following code. I just need to copy and paste values in a dynamic range and I keep getting stuck at the line Range(Cells(y, 3), Cells(Z, 33)).Select

Please Login or Register  to view this content.

is there a possibility for you to upload the whole sheet? thanks

It is actually a huge file and I have managed to work it out. There was an issue with variable "y" assignment. Thanks for responding though.