VBA Excel - Adding a therm on a formula already exist in a cell.

[yorgosnc]

Hi guys, my question is simples. I have this code, running just fine, but now I need to add something in it.

Please Login or Register  to view this content.

As you can see, he searches which cell it's colored and then reference in the Cell "D4". But I need sum one cell (always fixed coordenates), so that in the cell something like: "=R$4 + T$11". R$4 just example, that my code is already finding, and I need to add the cell T11.

I tried a few variations but I can't get through.

Code:

Please Login or Register  to view this content.

thanks in advance.

[bakerman2]

How about this?

Please Login or Register  to view this content.

[yorgosnc]

Exactly what I need mate! Thank you so much!

And if a needed to add in this formula at the Cell L4.
After seen which one is the max, add the cell T11

Please Login or Register  to view this content.

[bakerman2]

Like this ?

Please Login or Register  to view this content.

[cytop]

Also posted on OzGrid - and MrExcel

[Richard Buttrey]

Thanks cytop

@yorgosnc
Please note our forum rules about cross posting. Please edit your original and add any cross posted links.