chart title based on Named Range

I need to "build" a chart title and include the value (text) from a named range "Code"

With aChart

        'Formatting
        
        .HasTitle = True
        .ChartTitle.Text = "Configuration " & CODE & " DC Resistance"

where CODE is I need to insert the value of the nmaed range "CODE"

this seems simple but for the life of me, I cant figure it out.
Thanks
Robert

thanks Teylyn, But when using that with "CODE" in the place of "MyRange" I get a runtime error 13: type mismatch.

Ahh, you asked the right question. the reference is to a dynamic range of cells that have the same values in this particular usage. If I that's Why I'm modifying my titles to include "code". I need to take a better look at how I want to use this maybe just manualy edit the titles in this case.

BTW if I reference a sigle cell in the name formula then

.ChartTitle.Text = "Configuration " & Range("CODE") & " DC Resistance"

works fine.

Thanks for helping me clear up my problem.
Robert