ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How to get a ChartTitle formula (https://www.excelbanter.com/charts-charting-excel/29440-how-get-charttitle-formula.html)

DaH via OfficeKB.com

How to get a ChartTitle formula
 
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


All times are GMT +1. The time now is 01:35 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com