Delete entire column if word "False" exists

**marreco** · 04-09-2014, 02:24 PM

Hi.
Sorry reply this post.

JOHN H. DAVIS, how i use you code, but delete rows?

i try.

With Range("1:200")
    .Replace "FALSE", ""
    .SpecialCells(xlCellTypeBlanks).EntireRow.Delete
End With

Thank!!!

**JOHN H. DAVIS** · 04-09-2014, 02:33 PM

@marreco. If you start another thread, I'd be glad to help you, but it is against Forum rules to post in another person's thread see Rule no 2.

2. Don't post a question in the thread of another member -- start your own. If you feel it's particularly relevant, provide a link to the other thread. You may include up to 3 links to other URLs in a single post, no more, so only link to the relevant pages.