Excel VBA Delete row macro

preview_player
Показать описание
In this tutorial we outline how you can create a macro which will delete an entire defined row.

If you are new to excel please follow the following link to be able to follow on with the rest of this tutorial.

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

Sheets("Sheet1").Range("A4").Select

If you have any questions then please drop them in the comments below.

Please like and subscribe!
Рекомендации по теме
Комментарии
Автор

Your videos are so easy to follow and use Thanks.

Can this formula be used with an IF function. I.e. if the row in the table shows no data =delete?
Thanks

nigelhornsby
Автор

How can I delete the row just above the last one? This code erases only the last one...

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

jakastrojansek