Writing a macro that deletes blank rows

[britt@wjg]

I need help writing a macro. I only have experience recording them, not writing them in VBA.

I need to check columns A and B for blanks. If A and B are both blank, I want the macro to delete the row and move on to check the next row. I need to perform this macro for the entire worksheet.

Thanks in advance for the help.

[royUK]

Try this

Please Login or Register  to view this content.

[britt@wjg]

My sheet is about 10,000 lines. Is this too large for the macro to run? I tried a couple times to run it and it took about 3 minutes then Excel gave me the "Not Responding" message.

[royUK]

I should think it is the size of the range

[JHCali]

Hi,

Rather than create a new topic, I am posting my question in here as it is related.

In a sheet titled "WH", I have a column in which I designate each row with either a "W" or and "S". I need the macro to search all the rows with "S" and delete these rows. Also, this macro needs to work for any sets of data, independent of the number of rows a specific set may have.

Thanks in advance for your help!

[mdbct]

Try this version:

Please Login or Register  to view this content.

[JHCali]

mdbct,

The column I need the macro to look at is column B. Sorry for not making that clear initially. Does the code you provided need to be modified in any way so that the macro knows what column to look at?

Thanks.

[mdbct]

JHCali,
My response was to the original poster's question, not yours. You should have started a new post for your question. This thread has been marked as "solved" and could be skipped over by "the solvers" since they would think there is now longer an issue.

I've highlighted the line that checks the B column for the lettere S being present

Please Login or Register  to view this content.

[JHCali]

Mdbct,

Rookie poster mistake. Thanks for the heads up. But moreover, thanks for your help. Your code worked perfectly!