I have recorded a macro that creates and formats a chart in Excel 2000. I
need to run this macro in other workbooks with the same type of data. This
macro also formats the raw data before creating the chart. When I run the
macro it formats the data and creates the chart just fine. But when it starts
to format the chart I get an error message "Run-time error '9': Subscript out
of range". When I run the debugger a line containing the original sheet
reference in another workbook is highlighted. How do I get rid of the
specific reference so that the macro will run in other workbooks?

post your code please

Regards

Trevor


"CAS" wrote in message
...
I have recorded a macro that creates and formats a chart in Excel 2000. I
need to run this macro in other workbooks with the same type of data. This
macro also formats the raw data before creating the chart. When I run the
macro it formats the data and creates the chart just fine. But when it
starts
to format the chart I get an error message "Run-time error '9': Subscript
out
of range". When I run the debugger a line containing the original sheet
reference in another workbook is highlighted. How do I get rid of the
specific reference so that the macro will run in other workbooks?