Copy a range of value and paste to another range

[JayWangTPE]

Hi ,

I wanna copy a range of value and paste to another range.

One exception happen. How can I fix it?

System.Runtime.InteropServices.COMException: 'PasteSpecial method of Range class failed"




xlRange1 = xlWorkBook1.Worksheets(1).Range(Copyloc)
xlRange1.Copy()

xlRange2 = ws.Range("E22:E33")

xlRange2.PasteSpecial(Excel.XlPasteType.xlPasteAll, Excel.XlPasteSpecialOperation.xlPasteSpecialOperationAdd, True, True)

Continue reading...