try Answers From trianswer.com
0 votes
How to delete rows in excel?
asked Aug 14, 2010 by triuser (1,774 points)

1 Answer

0 votes

Try something like this

Sub Macro3()
' This scans down column A1 to A24
' and delete those rows that are not integers

Dim x
For x = 1 To 24
If Cells(x, 1) <> Int(Cells(x, 1)) Then
Cells(x, 1).EntireRow.Delete
*** If
Next
*** Sub
answered Aug 15, 2010 by trianswer (22,754 points)

Related questions

0 votes
1 answer
asked Dec 24, 2011 by triuser (1,774 points)
0 votes
1 answer
asked Nov 2, 2015 by triuser (1,774 points)
0 votes
1 answer
asked Aug 21, 2010 by triuser (1,774 points)
0 votes
3 answers
asked Aug 22, 2010 by triuser (1,774 points)