delete rows without numbers
 

Dim i As Integer

For i = ActiveSheet.UsedRange.Rows.Count To 1 Step -1
Select Case IsNumeric(Left(Range("a" & i).Value, 1))
Case False
Rows(i).Delete Shift:=xlUp
End Select
Next

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com