Thread: Running multiple regressions in macros

Hi,
I'm very new to VBA, and am trying to run a macro that will perform three multiple regressions for me. Not sure what I'm doing wrong, but here is the code that I'm getting an error for:

Application.Run "ATPVBAEN.XLAM!Regress", ActiveSheet.Range("$X$3:$X$155"), _
        ActiveSheet.Range("$Q$3:$W$155"), False, True, , ActiveSheet.Range( _
        "$AA$175"), False, False, False, False, , False
     Application.Run "ATPVBAEN.XLAM!Regress", ActiveSheet.Range("$Y$3:$Y$155"), _
        ActiveSheet.Range("$Q$3:$W$155"), False, True, , ActiveSheet.Range( _
        "$AK$175"), False, False, False, False, , False
     Application.Run "ATPVBAEN.XLAM!Regress", ActiveSheet.Range("$Z$3:$Z$155"), _
        ActiveSheet.Range("$Q$3:$W$155"), False, True, , ActiveSheet.Range( _
        "$AU$175"), False, False, False, False, , False

Any help I can get would be greatly appreciated!!

-Dmitry

I think you just have to be sure all cells in your data range have a value. You may have to adjust your range to suit your data.