Code to clear cells in a range which are not highlighted

**Gti182** · 05-15-2014, 08:28 AM

Hi All,

Looking for some code to clear cells which are not highlighted

i.e. clear everything from row 2 downwards (Columns I:P) but exclude cells which are highlighted (not conditional formatting)

Thanks

**Norie** · 05-15-2014, 08:31 AM

How are the cells highlighted?

**Gti182** · 05-15-2014, 08:32 AM

cells are highlighted by the user with the fill colour option

**Gti182** · 05-15-2014, 08:48 AM

this works

Sub Macro1()
        Range("I2:P1000").Select
        For Each Cell In Selection
        If Cell.Interior.ColorIndex = xlNone Then
        Cell.ClearContents
        
        End If
        Next

    End Sub

Code to clear cells in a range which are not highlighted

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Code to clear cells in a range which are not highlighted

Re: Code to clear cells in a range which are not highlighted

Re: Code to clear cells in a range which are not highlighted

Re: Code to clear cells in a range which are not highlighted

Thread Information

Users Browsing this Thread

Similar Threads

Need code to searches every row in range and clear rows with sequential numbers.

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

[SOLVED] Setting the range as only those cells selected/ highlighted

[SOLVED] VBA Clear Cells for one range if cell in other range is blank

[SOLVED] Macro needed to clear cells in range based on value of cells in another range

Bookmarks

Bookmarks

Posting Permissions