Hi

I am using the following code to copy from the InputData sheet of one
workbook and paste only values to the rspPlan sheet of another
workbook:

InputData.Range("d54:D73").Copy
rspPlan.Activate: rspPlan.Range("w180:w199").Select:
Selection.PasteSpecial Paste:=xlPasteValues

The source range has formulae in all the cells, but values only in a
few. The code is however pasting the formulae also. I want only values
to be pasted.

What will be the code to do this?

Also, is there a better way/code?

Thanks in advance for the help.

Raj