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?