Delete rows eith blank cells

[maxdjn1]

XXXXXXXXXXX
XXXXXXXXXX
XXXXXXXXXX
XXXXXxxXXX
_________________________________________________
H E A D E R L I N E H E A D E R L I N E
_________________________________________________
X____________X________________________X
X____________X________________________X
X____________X________________________X
______________X________________________
______________X________________________


Hi I need some one help to write a code. I have data in above format where top five lines are title lines. which I would require following whith the header of columns. I want to make a copy of the whole sheet in different worksheet in same workbook and want the rows to be deleted where first coloum is blank.

Please help me

Thanks
Max

 

[texasalynn]

try turning on the filters and then select "blank" for 1st column and delete the rows