one way:

If you know the last cell, just use it's entirerow property:

lastCell.EntireRow.Delete

or, if you know the range:

With Range("A1").CurrentRegion
.Item(.Count).EntireRow.Delete
End With


In article ,
"MoiraGunn" wrote:

Hi all,
I want to delete the last row in a matrix using a macro.
I know how to select the last cell but not the last row.
Can any one help?

Thanks, Kathy