Deleting rows depending cell value

[Liju144]

Hi friends,

am using the below code for deleting row depending the cell value it deleting the row but some its not deleting the rows.

Please Login or Register  to view this content.

[Naveed Raza]

try this code..

Please Login or Register  to view this content.

[Liju144]

Thank you ,


it showing the run time error(13) type mis Match.

[Pepe Le Mokko]

Using loops might not be the fastest way
Try

Please Login or Register  to view this content.

[Liju144]

Thank you ,,,


it's Working Proper.