Clear Red Cells with VBA

[Gerry P]

I am totally new to this.....But I need help with a macro that will clear cells that are high lighted Red

I am trying to make a line plot with the combined good values from columns x,y,z x5:z21000

Excel 2013 Red color is rgb 255 Sheet name is " Curve Data "


I could email file if needed................. Thanks in advance for any help

 

[Gerry P]

This works Amazing Mark !!!!! wow !! 1 more question if you dont mind ? Is there a way to re populate the cells like a undue macro ?

 

[MARK858]

You can't normally undo actions by a macro but seeing as the cells held formulas (and I assume the formula is similar throughout) then it should be a simple task to put the formula back into all the cells.