Delete Current Row With Offset (-1,0)

[habsfan]

Hey there,

for the life of me I cannot figure this out.

Looking do delete current row & all other rows below it except the last.

I was trying: Range(ActiveCell, ActiveCell.End(xlDown).Offset(-1, 0)).Select

which gave me only the cells in A:A that I needed to delete
Tried rows(activecell.row, (I cannot end and xldown(-1,0 here

Any help would be appreciated.

[LeoTaxi]

Try

Please Login or Register  to view this content.

Kind regards
Leo

[habsfan]

Worked like magic. Now I just need to understand it.