I've got some delete code
The code works great if the sheet data is in non-table format, but all my data ranges are in tables. How do I use ListRow to delete a table record using a combobox selection? The row needs to move up after deletion. I recorded a macro deleting entire row 4
What does (4:4) mean? My table is 'n' rows and 5 columns
Code:
Rw = Me.ListBox1.ListIndex + 2
If Me.ListBox1.ListIndex > -1 Then Sheets(1).Cells(Rw, 5).Resize(1, 5).Value = ""
Code:
Row(4:4).Select