Home |
Search |
Today's Posts |
#2
![]() |
|||
|
|||
![]()
Berthica,
These macros should help: Sub GetChartName() MsgBox "The chart name is: " & ActiveChart.Parent.Name End Sub Sub RenameChart() ActiveChart.Parent.Name = Chart1 End Sub ---------------------------- Regards, John Mansfield http://www.pdbook.com "Berthica" wrote: I have a lot of charts in a woorkbook and need to refer to them in my VBA. I cannot know the names (numbers) of all the charts. mHow can I change a chart's name so it is easy to find them ? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Urgent help! how to automatically resize all the charts? | Excel Worksheet Functions | |||
Can't create dynamic charts | Charts and Charting in Excel | |||
how do i make a date change automatically if i change one before . | Excel Discussion (Misc queries) | |||
change axis info on radar charts | Charts and Charting in Excel | |||
How do I change the default settings in charts? | Charts and Charting in Excel |