Clearing only specific text in range

**track85** · 04-06-2020, 05:32 PM

Hey everyone,

I'm stumped. Have a worksheet and assigned a macro button that will clear contents of a specific range. The clear button works but I just want to clear the cells that contain W while leaving the cells that are marked X.

Thanks

**alansidman** · 04-06-2020, 05:39 PM

Option Explicit

Sub ClearW()
    Dim c As Range
    Dim rng As Range
    Dim lr As Long
    lr = Range("A" & Rows.Count).End(xlUp).Row
    Set rng = Range("B2:O" & lr)
    For Each c In rng
        If c = "W" Then c.ClearContents
    Next c
End Sub

**track85** · 04-06-2020, 06:39 PM

works perfectly. Thanks so much!

Clearing only specific text in range

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Clearing only specific text in range

Re: Clearing only specific text in range

Re: Clearing only specific text in range

Thread Information

Users Browsing this Thread

Similar Threads

Formula help - excluding a specific text value from a mode range of text values

Selecting and clearing a Specific Range within an Active Selection

[SOLVED] VBA to Find Specific Text, then Copy range to next open cell under specific text

Clear range based on cell value - clearing cells out of specified range

Find specific text in cell that matches range, then display specific text

[SOLVED] Return specific text if a different text is contained anywhere in a range of cells

Display msgbox when specific text entered in specific range

Bookmarks

Bookmarks

Posting Permissions