Using Excel 2010
I have 6 charts. Excel designated the first 5 charts "Chart 1", "Chart 3", "Chart 4", "Chart 22" and "Chart 24", fine. Then it designated the 6th chart "Chart 3", so I have two "Chart 3".
How can I reassign a new name to this chart so I can refer to it when writing vba code?
I have 6 charts. Excel designated the first 5 charts "Chart 1", "Chart 3", "Chart 4", "Chart 22" and "Chart 24", fine. Then it designated the 6th chart "Chart 3", so I have two "Chart 3".
How can I reassign a new name to this chart so I can refer to it when writing vba code?