Hi All,

I would like to delete more than one row(which columnA cells contain nothing ) in between rows that is as follows.that is allow only one row(like row3 after vba progamme)
in between for spacing or no row in between(like row1 and2) How to write the VBA code
many thanks

ColumnA ColumnB
Row1 Peter Math Mark=100
Row2 John Math Mark=99
Row3


Row4
Row5 tom math mark=68
row6
row7
row8 mary math mark=50

After we use VBA progamme , the result as follows

ColumnA ColumnB
Row1 Peter Math Mark=100
Row2 John Math Mark=99
Row3
Row4 tom math mark=68
row5
row6 mary math mark=50


Thanks
Tomlam