Ask a questionAsk a question
 

Questioninsertrowrange always returns nothing in Excel 2007 vba

  • Wednesday, November 04, 2009 6:53 PM___sm Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     

    In Excel 2003, I could use the ListObject.InsertRowRange property to position my selection for inserting new data into a list (2003) (or excel table (2007))

    code snippet:

    Dim myLO As ListObject
    Dim myLoRowRng As Range
    Dim myPlaceholderRow As ListRow

    Set myLO = TimeTrackingData.ListObjects(1)
    Set myPlaceholderRow = myLO.ListRows(myLO.ListRows.Count)
    myPlaceholderRow.Range.Activate
    Set myLoRowRng = myLO.InsertRowRange
       
    In this case, myLoRowRng.Address is the range of the InsertRowRange as long as myLO.Active evaluated to TRUE.

    In Excel 2007, using the same code as above, myLO.InsertRowRange always returns "nothing" even though my ListObject.Active property evaluates to TRUE.  Also, in Excel 2007, the "insert row" is never visible (i.e. marked with an asterisk "*").  The Excel 2007 VBA help and Excel 2007 Object model both indicate that the InsertRowRange property exists and is not deprecated.  Has this functionality actually been removed?

    Has anyone else been able to use the insertrowrange property?