If Cell Blank then Delete Row

[Nuccio92]

Please Login or Register  to view this content.

I have a macro that pulls all the information that I need. At the end I want it to go through Column A and Delete the entire row if the Cell in Column A is blank. The last part of the macro is what I tried to use but it is not working.

[AB33]

Could be one of the 2 reasons:
The null strings are derived from a formula
you have not referenced the sheet name, so the code is looping through a different sheet.

Option Explicit

Please Login or Register  to view this content.

Or if they are truly blank

Please Login or Register  to view this content.

[xladept]

Try evaluating the Cells(j,"A")

Please Login or Register  to view this content.

[bakerman2]

Also see http://www.excelforum.com/excel-prog...at-macros.html

Reason is that according to example file cells in column A are not blank but contain 2 spaces.
See my last post for solution.

[xladept]

Hi Nuccio,

Thanks for the rep!

Is your problem solved?