Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Simple Chart name modification Not working
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Simple Chart name modification Not working
Try this syntax:
Sub nameidentify() With Sheets(1).ChartObjects(1).Chart .HasTitle = True .ChartTitle.Text = "Analysis" End With End Sub I couldn't get it to respond to ActiveChart. "R Tanner" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I create a behavior modification chart for children | New Users to Excel | |||
Chart Axis Modification | Excel Programming | |||
This should be so simple but it's not working, please help | Excel Programming | |||
Simple Macro Modification | Excel Programming | |||
This should be simple but it's not working for me! | New Users to Excel |