Macro to copy chart from one workbook to another,

[tonywatsonhelp]

Is it possible to get a macro to copy a chart from open workbook called master into current workbook current tab and set chart data to the formula name tonytest?

 

[AlphaFrog]

    Workbooks("Master.xls").Sheets("Sheet1").ChartObjects("Chart 1").Chart.ChartArea.Copy
    ActiveSheet.Paste
    ActiveChart.SetSourceData Source:=Range("tonytest")

 

[tonywatsonhelp]

Thank you Alphafrog just tested it works perfectly