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

H

Holger Gerths

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.
 
J

Jon Peltier

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
 

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

Retrieving linked label formula with VBA 1
Excel 2007: get formula from charttitle 1
Exporting Outlook 2007 contact list without losing groups 0
Drop down list control value in vba 2
ASK Field Formatting 1
XL 2010 to XL 2007 backward compatibility 2
XL2007: Linked-labels reference is not copied with sheet 1
How can I get rid of the language box? 0

Top