Help with Code That Searches for a Blank Row and Deletes it within a Range

[b0ttle]

Hey guys,

I am looking to modify my original code for a little more function.

I have cells B:O, that range from 20 - 300. What I am trying to do is create a function that looks through all of the cells B:O, and if all cells are blank, completely delete the row.

However I also only want this to occur between the 20 - 300, not to mess with anything outside of that range.

Any suggestions?

Please Login or Register  to view this content.

[mikerickson]

One way would be

Please Login or Register  to view this content.

[b0ttle]

I see how you structured your code and I like it, however it doesnt seem to want to delete anything,

Do I need to add anything into the code?

[mikerickson]

Do the cells that being deleted contain formulas that evaluate to "", or are they just blank cells?

[b0ttle]

completely blank cells

[mikerickson]

As you step through it, is the If line failing to recognize an empty row, or is the .Delete line failing?