"Don Guillett" wrote:

the macro recorder is your friend

Cheers
Copied that macro into Macro1, found the number of the chart by putting it
in a window, then changed the macro to this number. This allowed me to name
both charts as I wanted, solving the problem.

I get the feeling this roundabout route wasn't what you had in mind when you
answered, but if it works, it works :p