Sub Macro13()
'
' Macro13 Macro
' Macro recorded 1/18/2005 by isacp
'
' Keyboard Shortcut: Ctrl+Shift+N
'
For Each Item In Selection
If Item.Value = "NA" Then
Item.EntireRow.Delete
End If
Next Item
End Sub
this is my code
for some reason when i select say b1:b20
and all the cells have NA in it it only deletes 10
'
' Macro13 Macro
' Macro recorded 1/18/2005 by isacp
'
' Keyboard Shortcut: Ctrl+Shift+N
'
For Each Item In Selection
If Item.Value = "NA" Then
Item.EntireRow.Delete
End If
Next Item
End Sub
this is my code
for some reason when i select say b1:b20
and all the cells have NA in it it only deletes 10