Changes in code to paste special - Values

[moonbreakker]

Hello,

I have this code that copies cells in a row and pastes it at different places in another sheet.

Please Login or Register  to view this content.

Instead of ActiveSheet.Paste i need to paste only values. But it does not work. I googled and it said first i need to select range which i think is selected in the line above the paste function. What am i missing. There are almost 150 cells that need to be copied. I spent hours writing the code below but then realized that i need to use paste special.

Please Login or Register  to view this content.

PS: I have deleted lots of repetitive code above as the forum does not allow more than 15000 characters. Is there an easy way to write this code?
I do have 2 columns.

For eg.

r = "EV" & ri
Range(r).Select
Application.CutCopyMode = False
Selection.Copy
Windows(f).Activate
Range("C65").Select
ActiveSheet.Paste

I have prepared 2 columns. One contains list like EV above and next to it i have range like C65.

Thank you for reading.

EDIT: Is there any way i can Ctrl+H and replace all something with something else? That would be very useful.

[JOHN H. DAVIS]

Try change these type of references in your code.

Please Login or Register  to view this content.

To:

Please Login or Register  to view this content.

[moonbreakker]

Worked. I did CTRL+H and changed as you mentioned.

Thank you so much.

[JOHN H. DAVIS]

You're welcome. Glad to help out and thanks for the feedback.