row delete

[vikram]

hi all,

when i use this command to delete all rows if column A is blank, in
few cases it deletes all the rows even if column A is not blank why i
it so

Columns("A").SpecialCells(xlCellTypeBlanks).EntireRow.Delete
End Su

 

[Ron de Bruin]

Hi vikram

There is a limit with Specialcells
http://support.microsoft.com/default.aspx?scid=kb;en-us;832293

Look also on David's site
http://www.mvps.org/dmcritchie/excel/delempty.htm

 

[vikram]

so what is the way out

 

[Ron de Bruin]

David have a example on his site

Look also on David's site

http://www.mvps.org/dmcritchie/excel/delempty.htm