Copy cell into heading

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I can't quite see it, but it's got to be with "TEXT".
I have this..
With ActiveChart
.HasTitle = True
.ChartTitle.Characters.Text = _
"W.E MM/DD/YY MVSA HOURLY CPU BUSY FROM 9AM TO 5PM " & Chr
(10) & "WEEKLY AVERAGE%

I'd like cell K2 instead of MM/DD/YY.
Thanks.
 
Assuming it's on sheet 1:

.ChartTitle.Characters.Text = _
"W.E " & Worksheets(1).range("K2").Value & _
" MVSA HOURLY CPU BUSY FROM 9AM TO 5PM " & _
Chr (10) & "WEEKLY AVERAGE%"

Don't forget the closing quote.

- Jon
 
Absolutely perfect! Thank you.
-----Original Message-----
Assuming it's on sheet 1:

.ChartTitle.Characters.Text = _
"W.E " & Worksheets(1).range("K2").Value & _
" MVSA HOURLY CPU BUSY FROM 9AM TO 5PM " & _
Chr (10) & "WEEKLY AVERAGE%"

Don't forget the closing quote.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______



.
Click to expand...
 
Back
Top