For some reason excel will not allow me to change the size of the
AxisTitle in VBA but only the placement!

My problem is that I want to keep the Value-Axis title on one line,
even when the text exced some given number of characters. Are there
anyone who now how to do this?

Thank you very much in advance.
Best regards
Christian Scheuer

Instead of an axis title, you could use a text box, then position and
size it with code.

Christian Scheuer wrote:
> For some reason excel will not allow me to change the size of the
> AxisTitle in VBA but only the placement!
>
> My problem is that I want to keep the Value-Axis title on one line,
> even when the text exced some given number of characters. Are there
> anyone who now how to do this?

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html