Here is an easy one, I guess, for those who know the answer:

Charts on a worksheet are named Chart1, Chart2, etc. as they ar
created, and this is the name you must refer to when manupulating the
in VBA.
Is it possible to look up the name of a chart, and if affirmative is i
possible to change it?


NS

--
ns
-----------------------------------------------------------------------
nsv's Profile: http://www.excelforum.com/member.php...fo&userid=2650
View this thread: http://www.excelforum.com/showthread.php?threadid=55725

Hi,

Hold the Shift key whilst selecting the chartobject, sizing handles
shold be white instead of black, and the charts name will appear in the
Name Box (next to the formula bar). You can then change the charts name
via the name box.

With code use,

Activechart.parent.name = "NewName"

Cheers
Andy

nsv wrote:
> Here is an easy one, I guess, for those who know the answer:
>
> Charts on a worksheet are named Chart1, Chart2, etc. as they are
> created, and this is the name you must refer to when manupulating them
> in VBA.
> Is it possible to look up the name of a chart, and if affirmative is it
> possible to change it?
>
>
> NSV
>
>

--

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

Thanks Andy..

--
ns
-----------------------------------------------------------------------
nsv's Profile: http://www.excelforum.com/member.php...fo&userid=2650
View this thread: http://www.excelforum.com/showthread.php?threadid=55725