Hi,

If the chart is an object on a worksheet then try

Activechart.parent.name = "XXX"

Cheers
Andy

רוז×*ט wrote:
the user operate a macro to build a chart, and the chart has an automatic
number
from the excel not from the user.
after a while the user want to deleat this chart by another macro
but the macro dont identify the chart
i want to add a line in the first macro that will give a name to the chart
it built

I Tried ActiveChart.Name = "XXX"
but it didnt work

i apriciet your help
rozent


--

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