how to write a vba code to delete data after a last row?

[jaik22]

'Range("A23").End(xlDown).Offset(1).Resize(ActiveSheet.UsedRange.Rows.Count).EntireRow.Delete

So far I have this code to delete data after the last row. However, how can I edit the code to delete only A through E columns instead of entire rows?

Thank you

 

[Ruddles]

Try:-

Range("A23").End(xlDown).Offset(1).Resize(ActiveSheet.UsedRange.Rows.Count,5).ClearContents

 

[jaik22]

Awesome! Thanks, it works.