View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default Simple Chart name modification Not working

That line works on a chart sheet. For an embedded chart you need:

Application.ActiveChart.Parent.Name = "Analysis"

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"R Tanner" wrote in message
...
When I try to do the following procedure, I get an 'Out of Memory'
error. Why would this be?

Sub nameidentify()

Application.ActiveChart.Name = "Analysis"

End Sub