another simple question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MoiraGunn - 20 Sep 2003 02:32 GMT

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

Reply to this Message

J.E. McGimpsey - 20 Sep 2003 03:05 GMT

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

> 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

Reply to this Message

MoiraGunn - 20 Sep 2003 05:21 GMT

That worked thanks!!

> one way:
>
[quoted text clipped - 14 lines]
> >
> > Thanks, Kathy

Reply to this Message