fill Formula1 with named range

I need to fill the Formula1 property of FormatConditions.Add using a variable that refers to a Named Range on the worksheet

The Name is “DC_RES” and it is stored in Variable “colRng”

Please Login or Register  to view this content.

Results in the formula being:
="DC_RES"
But I need to quotes to go away!

I’ve tried a lot of variations and I’m just chasing my tail at this point. Please help!

the full code follows:

Please Login or Register  to view this content.

Hi,

Have you tried ...

Please Login or Register  to view this content.

HTH
Carim

I knew it would be that simple :o

Thanks Carim

Glad it fixed your problem.

Thanks for the feedback

Carim