I created a Macro just using the record Macro tool. I'm analyzing data
points by graphing 600 points and also finding a slope and R-squared value of
these points. When I open excel, import the data, and run the Macro
everything works fine. However, when I save that file and open a new book
the Macro encounters a bug. I open visual basic and change the line that is
a problem from the Book1 to Book2 and click Run and the Macro works fine.
Does anyone know a way to change this to avoid this nuisance? Thanks for all
your help.

Use Activeworkbook instead of Workbooks("Book1.xls")

--

HTH

RP
(remove nothere from the email address if mailing direct)


"chris_rip" wrote in message
...
I created a Macro just using the record Macro tool. I'm analyzing data
points by graphing 600 points and also finding a slope and R-squared value
of
these points. When I open excel, import the data, and run the Macro
everything works fine. However, when I save that file and open a new book
the Macro encounters a bug. I open visual basic and change the line that
is
a problem from the Book1 to Book2 and click Run and the Macro works fine.
Does anyone know a way to change this to avoid this nuisance? Thanks for
all
your help.

That seemed to do the trick. I'm glad to know that it was something so
simple to fix the problem. Thanks for the tip.

CR


"Bob Phillips" wrote:

Use Activeworkbook instead of Workbooks("Book1.xls")

--

HTH

RP
(remove nothere from the email address if mailing direct)


"chris_rip" wrote in message
...
I created a Macro just using the record Macro tool. I'm analyzing data
points by graphing 600 points and also finding a slope and R-squared value
of
these points. When I open excel, import the data, and run the Macro
everything works fine. However, when I save that file and open a new book
the Macro encounters a bug. I open visual basic and change the line that
is
a problem from the Book1 to Book2 and click Run and the Macro works fine.
Does anyone know a way to change this to avoid this nuisance? Thanks for
all
your help.