Excel 2007: get formula from charttitle

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

How to get a ChartTitle formula 0
How can i prevent the COMException 0x80010108 and 0x80010105? 1
Extract Chart Titles from graphs 1
Get Label formula with get.formula(selection()) in XL-2007 1
Display weeks from a Milestone 0
Autonumber field in Excel that behaves the same as Access 0
LISTNUM + Mail Merge + INCLUDETEXT : Referencing Paragraph # Can't get to work 0
Graph - Runtime Error 1004 5

Top