Macro - Delete Rows of a Certain Letter Case

[godonnygo]

Hi, I have some data in Excel that follows a pattern similar to the following:

Please Login or Register  to view this content.

What I want in this example is for the rows that are in "proper" case (or whatever you call a capital followed by lowecase letters), ie A2, A5, A8, to be deleted by a macro.

Does anyone think this could be done? I'm not really sure if Excel/VBA can differentiate between cases.

[StephenR]

Try this.

Please Login or Register  to view this content.

[mudraker]

Here is another macro that you could also try

Please Login or Register  to view this content.

[royUK]

And another way, I prefer to find all the cells then do one delete

Please Login or Register  to view this content.

[godonnygo]

Yeah Roy, I was thinking the find and delete option could be worth trying.

Thanks very much guys, I'll give them all a go when I get a chance. Great work.

[godonnygo]

Cheers, gave those a go and they all worked like a charm.