Hi,
I'm trying to record a macro in Excel 97 to automate some frequently used charts.
It works fine if I make no changes to the charts, but if I resize or reposition the charts, then the problems begin - I get an error stating that the item with the specified name wasn't found (ie chart 1).
Anyone got any ideas?
I'm trying to record a macro in Excel 97 to automate some frequently used charts.
It works fine if I make no changes to the charts, but if I resize or reposition the charts, then the problems begin - I get an error stating that the item with the specified name wasn't found (ie chart 1).
Anyone got any ideas?