I am running a macro that looks in column N and if there is a numeric value then it deletes the entire row
the code is:-
Sub deleterows()
For i = Cells(Rows.Count, "N").End(xlUp).Row To 1 Step -1
If IsNumeric(Cells(i, "N")) Then Rows(i).EntireRow.Delete
Next i
End Sub
but it seems to be deleting rows that have no data in ie should be ignored and left alone
am i missing something .....pls help
the code is:-
Sub deleterows()
For i = Cells(Rows.Count, "N").End(xlUp).Row To 1 Step -1
If IsNumeric(Cells(i, "N")) Then Rows(i).EntireRow.Delete
Next i
End Sub
but it seems to be deleting rows that have no data in ie should be ignored and left alone
am i missing something .....pls help