I am using Excel 2003. I recorded creating a stock chart with the
macro recorder. When I play back the macro, I get the following in the
message box:
Run-time error '1004':
Method 'ChartType' of object '_Chart' failed
When I go into the debug mode, it has stopped at the second line of the
macro. The first two lines are:
Charts.Add
ActiveChart.ChartType = xlStockVOHLC
Seems strange that I cannot play back a recorded macro. What did I do
wrong?