View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default 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