View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default how to delete a row

cells(rows.count,1).End(xlup).EntireRow.Delete

is one possibility.

--
Regards,
Tom Ogilvy

"Newbie" wrote in message
...
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