2 Replies Latest reply: Mar 26, 2012 4:42 PM by Sarah Thompson RSS

    Macro Error "Object doesn't support this property or method: 'XLDoc.Sheets(...).Selection'"



      I have a macro to export and format a chart to Excel (2010). The problem is Excel interprets one of the column headers as a date and changes it from 10-20 to Oct-20.


      My solution was to change the cell format to text and add the column header back in but I'm getting the following error message when running the macro:


                "Object doesn't support this property or method: 'XLDoc.Sheets(...).Selection'"



                     XLDoc.Sheets("Sheet4").Selection.NumberFormat = "@"
                     XLDoc.Sheets("Sheet4").ActiveCell.FormulaR1C1 = "10-20"





      Any suggestions are greatly appreciated!


      Thank you,