If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
another simple question
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 |
#2
|
|||
|
|||
another simple question
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 |
#3
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|