Graps in macros
 

I'm trying to create a new graph BUT later i need to make some
enhancements in it. I'm trying to give the graph a NAME because I need
to refere it in another macro, but I can't give a graph a name inn
order to later select it. VB uses "GRAPH nn" as a standard name of
graphs... Any suggestions???


--
jormonal
------------------------------------------------------------------------
jormonal's Profile: http://www.excelforum.com/member.php...o&userid=34949
View this thread: http://www.excelforum.com/showthread...hreadid=546812

Graps in macros
 

if it is on a separate chart sheet

Charts(1).Name = "MyName"

if it is on a worksheet

activesheet.ChartObjects(1).Charts(1).Name = "MyName"

Something along those lines.

--
Regards,
Tom Ogilvy



"jormonal" wrote:


I'm trying to create a new graph BUT later i need to make some
enhancements in it. I'm trying to give the graph a NAME because I need
to refere it in another macro, but I can't give a graph a name inn
order to later select it. VB uses "GRAPH nn" as a standard name of
graphs... Any suggestions???


--
jormonal
------------------------------------------------------------------------
jormonal's Profile: http://www.excelforum.com/member.php...o&userid=34949
View this thread: http://www.excelforum.com/showthread...hreadid=546812