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.