Macro To delete Blank Row

[don1235]

HI,

Is there a VBA code to remove blank rows between Data. I have a report with large number of rows.


Regards

 

[Marcelo Branco]

Maybe this can help

http://www.ozgrid.com/VBA/VBACode.htm

M.

 

[CWatts]

There is, but it would depend on your data. It may be easier for you to use auto filter, select only the blank rows, delete them all and then remove the auto filter.

 

[Akinrotimi]

Don1235,

There is a simple solution for you.

Assuming the column in question is A,the code below switftly clears it out:

Columns("a:a").SpecialCells(xlCellTypeBlanks).EntireRow.Delete

Regards

Rotimi