Recording Regression in Macros

[Guest]

Hi,
I am using the regression function to run regression 3 sets of (x,y) data in
a single file.
I tried to record this activity using Record MAcro. However, when the run
the macro in my next file, it says missing Y data for regression.

I am not sure whats happening .. I have trieed recording macro in the
present workbook, new workbook and Personal workbook, with no luck

Can we record regressions using the Record macro feature??

PLease advise. A solution to this will be very bery helpful
Thanks
Hitesh

 

[Nigel]

Yes, you can record, but if your ranges specified are empty or of a
different length then you will get an error.