Macro to clear all white cells in range

[tonywatsonhelp]

Hi Everyone,
I would like a macro that I can set the cell fill colour with RGB (to start lets say white)
and it clears contents of any cell in range R11:R200 that has a white background.

Please help if you can,
Thanks
Tony

 

[rollis13]

With this snippet you can clear contents in a range with cells with white background (or none):

Dim wCell   As Range
For Each wCell In Range("R11:R200")
    If wCell.Interior.Color = vbWhite Then wCell.ClearContents
Next