I need some help in finding a macro that will delete a line if the message #N/A appears. Right now I have a macro that will hide a row if it has a zero in it and it loops all the way till it hits "done" would like to add the ability to delete a row with #N/A in it, here is my code for the hide zero macro
Sub Hide_Zeros()
'Hides all rows less than zero starting at C11
ActiveSheet.Range("e12").Select
Do Until ActiveCell.Value = "END"
ActiveCell.Offset(1, 0).Activate
Cntr = Cntr + 1
If ActiveCell.Value <= 0 Then
ActiveCell.EntireRow.Hidden = "true"
End If
Loop
End Sub
Any help would be awesome, thanks!
Bookmarks