Macro not finding finding selected characters in strings

Following code should look at every cell in sheet 1 used range, move any rows where a cell contains one of these four characters: ' or ; or - or ! and delete the blank row in sheet 1.

It's cycling through the cells correctly, but not finding the characters:

Please Login or Register  to view this content.

Any guidance, suggestions or solutions welcome as ever

Ochimus

Sintek,

Really grateful for the prompt response.

The only one that seemed to work was the second suggestion, and that never deleted the relevant rows from sheet 1, so i added that to the Code.

Please Login or Register  to view this content.

When I ran it, the Macro missed the Hyphen in C5 and the two Hyphens in B8, but then running it again straight away it DOES pick them up, leaving just rows 2 and 6 on Sheet 1, as expected.

Any ideas?

Ochimus

Originally Posted by Ochimus

... When I ran it, the Macro missed the Hyphen in C5 and the two Hyphens in B8, but then running it again straight away it DOES pick them up, leaving just rows 2 and 6 on Sheet 1, as expected.

1. 'Exit For' is missing:
2. Deleting a row not here (red) because you are changing the area you are working on (mark the cells and run delete at the end of the macro):

Please Login or Register  to view this content.

3. code below:

Please Login or Register  to view this content.

you can change to:

Please Login or Register  to view this content.

Well, it's enormous thanks to everyone who responded.

Trust Excel to provide four totally different solutions to the same problem! Tempting to try each one over a few thousand records and see whether there is any significant difference in speed between the different approaches.

Ochimus