Hi JS,

just check id is numeric or empty, then delete?

Try:

'=============
Public Sub Tester()
With Columns(1)
.SpecialCells(xlCellTypeConstants, xlNumbers). _
EntireRow.Delete
.SpecialCells(xlCellTypeBlanks).EntireRow.Delete
End With
End Sub
'<<=============


---
Regards,
Norman


"js" wrote in message
...
Hi,

I have a excel file like this:
id name
1 ll1
2 ll2
abc xxxxxxxxxxxxxx
10 ll3

23 ll4

my job is to remove the empty line or the id column is not numeric, I
manual did it now. I have lot's row. is it possible to do using VBA? just
check id is numeric or empty, then delete? I'm new to excel, please help.
Thanks.