Deleting Entired Rows Based on Data Conditions

[starbwoy]

Hi Everyone- I have been trying get a macro working. Basically I have a list in column H like this (about 1000-1200 rows):

open
close
open
open
close
open

I need to apply a set of rules to them:

1) For any 'double opens', delete the first value

eg)
open - delete this entire row
open
close

2) For any 'double closes', delete the second value

eg)
open
close
close - delete this entire row
open

Any help would be much appreciated.

Thanks.

[VBA Noob]

starbwoy,

Please read forum rules below and then add the link to the other excel forum

Many thanks

VBA Noob

[starbwoy]

Sorry. Will not double post.

[fecurtis]

Are there ever any cases where you'll have three or more consecutive cells in column H that equal "open" or "close"? If so, this code won't work properly:

Please Login or Register  to view this content.

But if you're only concerned with doubles, this should do the trick. It starts at H2 and works its way down (I assume H1 has a heading, if not, adjust it accordingly).

[VBA Noob]

No issue with cross posting as long as you add the link

BTW you still need to add the link

VBA Noob

[starbwoy]

Fecurtis- Thanks for your help!

Here is the link to the other forum

http://www.mrexcel.com/forum/showthread.php?t=321100