Macro tutorial - How to delete the last row

In this video we outline how you can create a macro that will delete the last row in your dataset.

If you are new to excel macros then please watch the following playlist before we get started:

The code that we used in this video is as follows:

Range("A" & Rows.Count).End(xlUp).Select
ActiveCell.EntireRow.Delete

If you have any questions or comments then please put these in the description below.

Thankyou for liking and subscribing.

[philt]

Very helpful video, It was easy to follow and well explained. Many thanks

[massimilianocervino]

Hi this is super helpful! Thank you! Any chance please you could write the macro for the last row plus 1 row (ie: the last row is 10, i would like to delete 11).. thank you!

[johnrockwell]

I would prefer my new row to become the last row, and not the first row. Is this possible? thanks. Great Video!