Alternatively, remove ".Characters" and change to R1C1 notation:
.Axes(xlValue, xlPrimary).AxisTitle.Text = "=Sheet1!R24C5"
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______
"Chris" wrote in message
...
Thanks a lot Martin
"Martin" wrote:
VBA is a very different place to Excel and it has to talk a kind of
pidgin-English to be understood by Excel! Instead of Sheet1!E24 which is
pure Exceleeze you've got to say:
ActiveWorkbook.Sheets("Sheet1").Range("E24").Value
It's logical but kinda laborious...
"Chris" wrote:
When running a macro, how do I link a chart axis title such as the
y-axis to
a cell in a worksheet?
In the VBA section, the line of code for the title is:
.Axes(xlValue, xlPrimary).AxisTitle.Characters.Text = "Values"
I'm trying to link the word "Values" to a cell instead of a text
string. I
tried typing in Sheet1!E24 with and without quotes but it won't work.