Macro to set RowHeight after ColorIndex.

Hi I would like to have a macro which can set the row height after colorindex. So if there is cells with color index 4. it set the rowheight to example 34 in those rows with that color ,
And if the colorindex is 16 it set the rowheight to example 25 in those cells with that color.

I have attached a little test sheet to work with.

Hope some can help.

Sincerely

Abjac

You could try this.

Please Login or Register  to view this content.

Thanks Jolivanes and Patel 45. Both codes work just perfect. It can be an advance to have both options. To change if there is color, but also only change if there data inside. So great with both codes.

Thanks to both of you

Have a nice day

Sincerely
Abjac