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
Bookmarks