vba, countif in a loop.

[montecarlo2012]

Hi.
I founded many examples on how to countif, except this case
I have an array, I would like to find how to COUNT the cells in every column until a color is found and then stop count
The first column form B3:B12 are 10 cells without color, then color found and count stop, result on B1
And the same for the rest of the columns until G.

Any help will be very appreciated, thank you.

 

[montecarlo2012]

Thank you Sir. is really appreciated your input.

 

[DanteAmor]

Im glad to help you, thanks for the feedback

 

[montecarlo2012]

Bump