Get Label formula with get.formula(selection()) in XL-2007
 

Dear group,

in XL-2003 I can get a label formula with get.formula(selection()), when
selection is a datalabel.
Trying this in XL-2007, I get a type.mismatch.

Any good ideas about this?

Thanks,
Holger.

Get Label formula with get.formula(selection()) in XL-2007
 

Holger -

This is a known bug in Excel 2007. This is also broken for the chart title,
and I suspect other chart text elements are also broken.

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


"Holger Gerths" wrote in message
...
Dear group,

in XL-2003 I can get a label formula with get.formula(selection()), when
selection is a datalabel.
Trying this in XL-2007, I get a type.mismatch.

Any good ideas about this?

Thanks,
Holger.