copying only values into another worksheet

[partyrental]

Hi
I have this piece of code below, when u run the macro, the yellow highlighted code is copying the formula from the other worksheet. I want it to copy only the values not the formula.
What modifications should i make to the code to get just the values copied over

Capture.PNG

Thanks

[davesexcel]

pastespecial cannot be on one line

Please Login or Register  to view this content.