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