Macros to clear contents except for first cell of each colour in a particular row

Excel 2016:

I have a row of 70 colours (EACH COLOUR occupies several cells)

Now, what I want to do is –

For each colour in the range , I want to clear contents except for the first cell of each colour.


Like this row – I have 5 rows to perform. Please let me know if Im not clear or if you ave some questions


By: Kriti

Leave a Reply

Your email address will not be published. Required fields are marked *