chart title based on Named Range

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

Please Login or Register  to view this content.

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

Please Login or Register  to view this content.

works fine.

Thanks for helping me clear up my problem.
Robert