I have a chart on a sheet which is printed via a button and a macro s
tha only the chart is printed and not the entire sheet (but the char
has to be ON a sheet because it goes with a table).

What I need to do is add the current date to the end of the chart titl
after the text "Date: " which comes at the end of the title, an
overwrite any existing date there. This way it will update the date o
the title every day without user intervention.

Thank

--
Message posted from http://www.ExcelForum.com