Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 7
Default Excel 2007: get formula from charttitle

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
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default Excel 2007: get formula from charttitle

This sounds so familiar. I believe I've reported this as a bug.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


wrote in message
...
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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2007 formula help STEVE THE PARTS GUY Excel Worksheet Functions 1 August 21st 07 02:11 PM
excel 2007 formula STEVE THE PARTS GUY Excel Worksheet Functions 1 August 20th 07 02:20 PM
Excel 2007 Formula Display Training Spec. Excel Discussion (Misc queries) 5 April 5th 07 01:22 PM
VBA: Can't set ChartTitle.Text?? Ed Charts and Charting in Excel 1 October 3rd 06 11:59 PM
How to get a ChartTitle formula DaH via OfficeKB.com Charts and Charting in Excel 0 June 6th 05 07:40 PM


All times are GMT +1. The time now is 04:12 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"