how to delete a row
Hi
if your list is in column A (that is column A indicates the last row).
Try the following macro
Sub delete_last_row()
Dim rng As Range
Set rng = Cells(Rows.Count, 1).End(xlUp) 'change the 1
according to your column with data
rng.EntireRow.Delete
End Sub
Assign this macro to a button/toolbar
Frank
Newbie wrote:
Hi,
I want to be able to - on the click of a button - find the last row
in a list and delete the complete line.
How do I do this?
Thanks
|