View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] jmcdaid@gmail.com is offline
external usenet poster
 
Posts: 1
Default Retrieving the formula contents of a chart title

I am attempting to retrieve the formula used to generate a chart's
title as part of a tool i am developing, but i am having trouble. I
have browsed the charts object model and have had no joy - Both
chtObject.Chart.ChartTitle.Text and chtObject.Chart.ChartTitle.Caption
return the resulting title, and not the formula used to generate it.

Any assistance would be appreciated.

Kind Regards,

Joseph Mc Daid