How to get a ChartTitle formula

  • Thread starter DaH via OfficeKB.com
  • Start date
D

DaH via OfficeKB.com

Hi,

With an object ChartTitle, one can assign to the property Text a reference
to a cell:
ChartTitle.Text = "=Sheet1!$C$3"

What I would like to know is if there is a way to read this reference from
the object ChartTitle, because all I can see is the result of the formula
and not the formula itself.

Thanks,
DaH
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2007: get formula from charttitle 1
Cumulative formula for word table 0
How can i prevent the COMException 0x80010108 and 0x80010105? 1
Copy addition formula of non-consecutive horizontal cells 2
Syntax for selecting a textbox within a chart? 4
Not able to add title to the chart programmetically 1
Unable to set text property of the Charttitle class 14
LISTNUM + Mail Merge + INCLUDETEXT : Referencing Paragraph # Can't get to work 0

Top