Andy -

That was what I was thinking, too, what's in B1? Like B1 says Axis
Title, and B2 has the real axis title.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

Andy Pope wrote:
Hi Peter,

The code works for me.
If it doesn't generate an error then the only thing I can think is that
B1 contains "Axis Title" :)

peter wrote:

i must be doing something wrong.

copying that code exactly, it produces "Axis Title"

i'm probably missing something silly. thanks for your help.
hopefully this'll lead me on the right path