I want to do the following:

- Search column B for a value...let's say "X"

- Continue to search the rest of column B, after you've found X, and do the following:

- If (i,B) = vbNullString -> Do Nothing
- If (i,B) = any other value -> delete all rows from that row down

Here's a rough outline of what I'm thinking, but it's not working.

Please Login or Register  to view this content.
This doesn't seem to do anything though...