Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Recording Regression in Macros
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Recording Regression in Macros
Yes, you can record, but if your ranges specified are empty or of a
different length then you will get an error. -- Regards, Nigel "Hitesh" <Hitesh @discussions.microsoft.com wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Recording Macros | New Users to Excel | |||
Training: More on how to use macros in Excel: Recording Macros | Excel Worksheet Functions | |||
How do I make the Stop Recording bar pop up when recording macros | Excel Worksheet Functions | |||
Recording Macros | Excel Discussion (Misc queries) | |||
Macros not recording | Excel Discussion (Misc queries) |