Delete List Row

[Papi]

When I use a list in 2003 I use the shortcut Alt > E > W to delete one row. When I record the same keystrokes it converts that to

Selection.ListObject.ListRows(14).Delete

. That unfortunately is row specific. Any idea how to delete a row using a list (or selected rows) using VBA?
Thanks

 

[Al Chara]

I just read that when table filtering is enabled, some Excel commands will produce different results, e.g. When deleting data from the Table, entire rows must be deleted. I made some tests and when the Table is filtered, you can only delete entire sheet rows and not just table rows, as when the table is unfiltered.

 

[Papi]

When the cursor enters the table it automatically turns the filter dropdowns on (at least in 2003 at work). By going Alt > E > W, it deletes the entire data on the section of the table and data on the outside is not affected. If the normal delete is used, it will delete the entire row. What you wrote does exactly what Alt > E > W does which deletes the row from the section it sits in. The only item that it will not affect is the last data row (my mistake on wording earlier). When the cursor is placed at the bottom of a list/table it opens a new row to keep the table in the same format as before i.e. formulas will carry down to the new row. So the new row is what I was calling the last row. That is what I meant by one down from the last one. Thanks again.