Vba code it only deleting part of what It should

[cinstanl]

I have the below code. I want this to delete every item in Column z that is NA... it is only deleting the first section of NA and not deleting the others. Is there something I need to add to this to get it to delete all NA's

Please Login or Register  to view this content.

[mikeTRON]

if you are deleting rows I would suggest you start from the top and work UP.

[Trebor76]

Hi cinstanl,

Try this:

Please Login or Register  to view this content.

Regards,

Robert