Hi,

Macro recorder is good for things like this, assuming not xl2007.
You can only link to 1 cell. If you have multiple cells you will need to
concatenate them in a single cell and link to that.

' linked to A1
ActiveChart.ChartTitle.Text ="=Sheet1!R1C1"

Cheers
Andy
--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"T-Man" wrote in message
...
I need a macro to link a chart title to a cell or range