Copy an d paste only values in Excel

CamiCat

Member
Hello ,

I want to copy the data from WorkBook_1 which is excel formula to WorkBook_2.
When I'm using 'Copy and Pate Worksheet Range' stage, the data is copied as formula from WorkBook_1 and same is pasted in WorkBook_2.
How can I paste the copied data as 'values only'.?
Do I need to make any change in 'code' of 'Paste worksheet' available under 'Copy and Paste Worksheet Range' ?
If yes, then can please guide what changes I should do?
Thank you,
Camilla.
 
Top