Hi All,

i have 25 charts in a sheets (Chart Name: Chart 1, chart 2 chart 3
etc.). Now i want to change the name chart 25 to chart 1. but i am
not able to do the same as there is already a chart with the same
name, this is what i think.

the charts in the sheets are not placed in the sorted order by their
names. so i want to rename the charts from the first chart in the
sheet till last and then sort the charts by their name.

please help.

thanks,
navin

Could you use other name, such as "Cht 1" etc? Then it will bw easy. Or you
need do it twice: Change it to Cht1, then change it back to Chart 1 again, I
guess.
--
VBA


"navin" wrote:

> Hi All,
>
> i have 25 charts in a sheets (Chart Name: Chart 1, chart 2 chart 3
> etc.). Now i want to change the name chart 25 to chart 1. but i am
> not able to do the same as there is already a chart with the same
> name, this is what i think.
>
> the charts in the sheets are not placed in the sorted order by their
> names. so i want to rename the charts from the first chart in the
> sheet till last and then sort the charts by their name.
>
> please help.
>
> thanks,
> navin
>
>