none
PasteSpecial method of Range class failed RRS feed

  • Question

  • Hi,

    Excel 2007 Data to PowerPoint 2007 Charts

    I am trying to copy the values from range array to chart data (PowerPoint 2007). Below is the code, which gives me error on PasteSpecial method in VSTO - VB.NET - VS 2010.

    SelAreas(i).Copy()

    objShape.Chart.ChartData.Activate()

    oWS1 = objShape.Chart.ChartData.Workbook

    oWS1.ActiveSheet.Range("A1").Select()
                                oWS1.Application.Selection.PasteSpecial(Paste:=XlPasteType.xlPasteValuesAndNumberFormats, Operation:=Constants.xlNone, SkipBlanks:=False, Transpose:=False) ' Errors in this line...

    Error Message "PasteSpecial method of Range class failed"

    Please help.

    Thanks,
    balumail75.


    • Edited by balumail Monday, May 27, 2013 1:13 PM
    Monday, May 27, 2013 12:23 PM

Answers