Put a chart's title using vba

[varshneybhasker]

hey, i want to add a chart's title using VBA.
It should pick the title from a cell (merged cell) in another worksheet.
(Worksheet name "Summary" ........chart title's source cells A1:G1)
Please help me with the coding.
Thanxx.

[Jacc]

You can just click on the title, type = and then select a cell.

If you need it in VBA the macro recorder gives something like this

Please Login or Register  to view this content.

[varshneybhasker]

It worked..Thanx buddy