another simple question
That worked thanks!!
"J.E. McGimpsey" wrote in message
...
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
|