I want to do a multiple regression through VBA code so I want to understand
the code structure.

I recorded a macro to do this, using Tools | Data Analysis | Regression, I
filled in my Y and X ranges and the cell range to post the results, however
the code that resulted did not show any of the ranges in it.

When I ran this code it asked me firstly to imput the "Y" range, and when I
key this and rerun the macro, a message indicated that the range need to be a
"contiguous reference" and I don't know what this means.

Can anyone please help me with the line code to do the multiple regression?

Thanks KEN