OK one more macro question

[paul061]

Is it possible to combine the contents of two cells? In my chart problem from my previous post I'd like to combine cell B7 (which says "test") and Cell B15 (which says "data") to create a chart title "test data"

 

[jmthompson]

To continue from the previous thread

With ActiveSheet.ChartObjects(1).Chart     
     .HasTitle = True     
     .ChartTitle.Text = Range("B7").Value & " " & Range("B15").Value  
End With

 

[paul061]

Thank you!