entering a worksheet formula into a chart title through vba

I have a spreadsheet that among other things, creates a chart every time I run a particular VBA routine.

I know I can manually click on the chart title and then click in the formula bar to make the title refer to a cell contents, thus making the title "auto-updating", but because I have just dynamically "created" the chart, I need to be able to do this through VBA. (Obviously can't ask each user to do the formula bar thing!)

I can't simply enter the worksheet formula (eg "='sheet1'!A1") into the ChartTitle.Characters.Text property as it simply shows as text, so I need to programmatically do the same thing as entering it into the formula bar.

Just can't work out how.

Any tips?

thanks
Guy

yip, silly me.

thanks Andy

Guy