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

try

rows(cells(rows.count,"a").end(xlup).row).delete

--
Don Guillett
SalesAid Software

"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

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

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

Thanks works a treat

Is it possible for you to explain the syntax or tell me where I can find out
about it

Thanks again
"Don Guillett" wrote in message
...
try

rows(cells(rows.count,"a").end(xlup).row).delete

--
Don Guillett
SalesAid Software

"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

there is no reason to retrieve the row number and feed it to the rows
object. Just use what you find directly

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

go to the bottom of the spreadsheet. Select cell A65536. Hit the end
button, then the up arrow, then do Edit= delete and select Entire Row

That is pretty much it.

--
Regards,
Tom Ogilvy


"Newbie" wrote in message
...
Thanks works a treat

Is it possible for you to explain the syntax or tell me where I can find
out
about it

Thanks again
"Don Guillett" wrote in message
...
try

rows(cells(rows.count,"a").end(xlup).row).delete

--
Don Guillett
SalesAid Software

"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