Hi Phil,

Hopefully its just a line wrapping problem.

Msg = Msg & vbCrLf & ChtObj.Name & _
" " & ChtObj.Chart.ChartTitle.Text

Cheers
Andy

Phil Hageman wrote:

Andy, Thanks for your reply. When running the code, I get a Compile error: syntax error on the line:
Msg = Msg & vbCrLf & ChtObj.Name & " " &

Thanks,
Phil

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info