VBA Delete blank rows in a given range on Excel [d

Question

This question already has an answer here:

• Excel VBA: Delete entire row if cell in column A is blank (Long Dataset) 1 answer

Before thinking to flag this as a duplicate question, please let me assure you that I found not an answer satisfying this very simple need. So I have a picture included to help me describe what EXACTLY I want to do. Please scroll down and pass the picture.

Imagine data being set in a neat way. Rows 1 to 9 must stay untouched. Rows 22 and so on must stay untouched.

From line 21 to 10 (that way intended) I want the code to check if the line is blank. If the line is blank I want the line deleted. Removed entirely. Otherwise, I want it untouched.

Thus in the picture, lines 1 to 9 stay untouched. From lines 21 to 10, only 10 and 11 stay. Lines 22 and so on stay untouched.

Checking the first cell if it is null, will do the trick, I just want the correct syntax to make it happen right and only within A21 to A10 for the example.

It is probably stupidly easy, but for some reason it gives me a hard time to do it right, since I am new to the VBA methods.

I am sure there will be the EntireRow.Delete method involved somehow I am just not so good yet with what you can do with VBA yet.

The first answer to this question was pretty near my needs and yet so far.

Excel VBA to delete blank rows within a range

Problem is that I am not very experienced and I don't understand all the methods, neither all arguments passed to that example. It is kinda complex and what I would love to see is something simple, documented in a way to understand what is going on, so I can implement it on my real life scenario.

This question: Excel VBA: Delete entire row if cell in column A is blank (Long Dataset)

The question has an answer for the ENTIRE spreadsheet, not helpful really in my case.

As you can see, I provide an example, I am not asking you to do my job, I just honestly wanna learn how to do what I asked.

I am not sure if I need a FOR that iterates with negative step -1, including some methods inside the loop, or if there is a ready method for this, including a looping, so here I am asking more experienced people how to do something, probably ridiculously easy.
Any help would be appreciated.

Answer 1

You need to loop backwards from the end of the range and delete the relevant row index, like so

for x=numrows to 1 step -1
    if ws.range("a" & x).value="" then ws.rows(x).delete
next x 

Where ws is the worksheet you are working on.