Change colour of every cell in workbook that matches RGB index

[Bonnister]

Hello everyone

After spending some time developing a series of models for various business users, one of my colleagues has now advised me that the RGB index I've been using in every model is in fact slightly different to what it should be (our marketing is very strict on the exact colours we use).

I'm trying to code a solution to this in VBA but failing. So the question is, I need a sub that will loop through every cell on every worksheet in a given workbook, and if the cell interior colour matches the RGB index in question, it changes the interior colour to a different RGB index.

If anyone can show me how to do this I will be incredibly grateful

Many thanks
Bonnister

[Norie]

Perhaps.

Please Login or Register  to view this content.

[stnkynts]

What index do you want to identify and what index do you want to change it to?

[ragulduy]

Please Login or Register  to view this content.

[Bonnister]

Norie, Stnkynts,ragulduy

Thanks to you all for your input, I went for the first one and Norie, it works perfectly. I'd got the cell.interior coding and the for...next loop, just seemed to have problems with the dims and usedrange.

Thanks again everyone

Bonnister