Excel 2007: get formula from charttitle

  • Thread starter Thread starter be_675
  • Start date Start date
B

be_675

I have been using this code to get a formula from a charttitle:

oChart.Activate
sTitle = ExecuteExcel4Macro("GET.FORMULA(""Title"")")

It no longer works in excel 2007. Can someone tell me how to get a
formula from a charttitle using VBA?

Thanks
b
 

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

Syntax for selecting a textbox within a chart? 4
How can i prevent the COMException 0x80010108 and 0x80010105? 0
Extract Chart Titles from graphs 1
Get Label formula with get.formula(selection()) in XL-2007 1
Chart Documenting Via VBA Questions 2
Graph - Runtime Error 1004 5
Unable to set text property of the Charttitle class 14
Excel/VBA question: Link ChartTitle at run-time, anyone? 2

Back
Top