[thecoolest2009]

Every time I record a macro and create a pivot table it seems to work very well until I close the sheet. When I open up an a new sheet and try to re-run the macro the debugger opens and tells me that there is an error in this line. What am I missing?

The macro is save in the personal workbook.


ActiveChart.SetSourceData Source:=Sheets("Sheet1").Range("A3")

[turbodante]

Can you provide a sample?

[Zack Barresse]

This is part of the problem with recorded macros. They aren't always that efficient (99 times out of 100). Can you explain what it is you are trying to do here, and provide your workbook, along with the code you have stored in your Personal.xls workbook?

[Aj_old]

if you can post the whole code, we can find the problem easier.
The problem can be due to the wrong reference.