How to search multiple values and delete rows

[Nandkumar]

Simpo_Macros_Trial.docx
Hi,

I am amateur VBA developer. Trying to learn certain new things to be able to avoid repetitive monotonous tasks using excel functiuons

I am trying to develop a Macro whick will delete rows based on values in first cell of row. PF below macro I developed. But I have to run this macro multiple times to get desired result. Look forward to understand how this error can be rectified

[AB33]

Nandkumar,
Please use code tags with your code as per forum's rule. If you are trying to search multiple values and delete them, it would be much faster to use the find function than a loop. Please attach a sample book. To attach it, go to advance then attachment