Hi all,

I recorded a macro and selected a chart sheet and the chart on it and
it wrote the code:

ActiveSheet.ChartObjects("Chart 1").Activate

I then rerean the code and was kind of surpirsed when the code came up
with the message that
the item was not found. There seems to be a difference between the
code when it is recorded from a macro and when it is written which
seems wrong to me, if the object oroducres the code in the macro when
selected why on earth will it not select when it is run back, I am
somewhat nonplussed! I was pretty proficient at programming excel 2003
but the latest version seems to be a lot less user friendly am I
right?

Thanks and regards, Mark