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