VBA to run a Linear Regression Automatically

[nirvehex]

Ok I'll take out the X3 part. Why not use the lrE where it says:

Application.Run "ATPVBAEN.XLAM!Regress", ActiveSheet.Range("F1:F" & lr), ActiveSheet.Range("A1:A" & lrE),

I want the range to run A1 over to column E and down the last row. So my X range would be A1:last row of E. I don't have that right there?

Also - is there anyway to have the macro press the ok on a prompt that comes up after I run this? What's happening is I'm overwriting a the ANOVA summary table that comes up when the macro pastes the ANOVA table in cell P1, which is exactly what I want it to do, however Excel always asks me if this is ok in a dialogue box.

Thanks for the continued advice! I know this isn't the first one you've helped me on!