Paste values?

X

xp

I've copied a single area rectanular group of cells.

The program opens a new file. A specific start cell is selected (C9).

Now I want to paste values. What is the line of code to paste values?
 
P

Per Jessen

Did you copy the cells before PasteSpecal?

Post your code, so we can see what is going wrong.

Regards,
Per
 
R

ryguy7272

Probably, the easiest way to do this is to record a macro and view the results:

Range("C9").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
SkipBlanks _
:=False, Transpose:=False

HTH,
Ryan---
 
Top