Help making a chart title from cell contents.

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

Thank you so much!!!

Your code did way more than I needed. But, I was able to get the general format I required.
This is all the code I needed: (Quite basic... But, again, I'm a newbie!)

ActiveChart.ChartTitle.Select
Selection.Caption = "=" & ActiveSheet.Name & "!R2C1"

But, I'm happy for the entire code you sent. I am sure I'll be able to use that some time too!

Thanks again!
Michelle

BTW - Nice bike!