Hi,

I'm stumped! I am trying to make the contents of a cell into a chart title.
I know I can do it like this...

ActiveChart.ChartTitle.Select
Selection.Caption = "=tab_name!R2C1"

However, I am trying to use the same macro on several different tabs in
the same EXCEL worksheet. Obviously, I can't have the tab name in the
macro. But, I don't get a title at all when I try to remove it like this...

ActiveChart.ChartTitle.Select
Selection.Caption = "=R2C1"

or
ActiveChart.ChartTitle.Select
Selection.Caption = "=A2"

Is this possible?

I am (kinda new at) using EXCEL2010.

Thanks,
Michelle