views:

87

answers:

0

Hi, I am having a problem getting pastespecial to work. Here is my code:

 osheet.Range("C2").Copy(.Range("C3:C" & endRow)) '**end of data
 osheet.Range("C:C").Select()
 osheet.Range("C:C").PasteSpecial(Paste:=Excel.XlPasteType.xlPasteValues, _
   Operation:=Excel.XlPasteSpecialOperation.xlPasteSpecialOperationNone, _
   SkipBlanks:=False, Transpose:=False)

Can someone please tell me what I am doing wrong.

Thanks,

Lora