delete rows containing blanks in column A

[krish T]

I have some blanks in Column A. I want to delete the rows with blanks in Column A only. It shouldn't delete the row if the blank in column B.

Please help me to get it done using code.

Thanks
krish

[pike]

Hi krish T
A quick search of the forum turned up this by jake
A good place to starthttp://www.excelforum.com/excel-prog...mpty-rows.html