Paste values?

  • Thread starter Thread starter xp
  • Start date Start date
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?
 
Did you copy the cells before PasteSpecal?

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

Regards,
Per
 
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---
 
cut and paste

for cut and paste normally the code statements are

Code: 
Range("a1").Cut
	Range("F5").Select
	ActiveSheet.Paste

this means the relevant worksheet has to be activated and destination cell has to be selected. .Is there no method to do this without activating worksheet and selecting the destination cell (by using "with" statement).

thanks
 
Back
Top