I can set an Excel Chart title to a range or a named range with VBA but if I inqiure I just get the actual value. How to find out what the Title reference is if there is one?
Code:ActiveChart.ChartTitle.Text = "=Test1!R3C10" ActiveChart.ChartTitle.Text = "=Sheet1!ChtTitle" Debug.Print ActiveChart.ChartTitle.Text '==> Derivative





Reply With Quote