tags:

views:

52

answers:

0

Why this doesn't have any effect?

Dim targetRange As Microsoft.Office.Interop.Excel.Range
                Dim sourceRange As Microsoft.Office.Interop.Excel.Range = exlTargetApp.Worksheets(" Recognition 1, 2, 3").Range("M69:N69")
                sourceRange.Select()
                sourceRange.Copy()

                targetRange = exlTargetApp.Worksheets(" Recognition 1, 2, 3").Range("M70:N70")
                targetRange.PasteSpecial(XlPasteType.xlPasteAll, _
                                         XlPasteSpecialOperation.xlPasteSpecialOperationAdd, _
                                         False, _
                                         False)
In Excel:
     M    N
69   23   23
70   2    2