Macro problem with VBA

M

Mike Dixon

I have created a simple macro that allows students to use a button to
run a regression analysis on a short block of data. I can do the
regression just fine but the macro returns the message: Run-time error
'1004': 'Analysis Toolpak - VBA' could not be found....

Any ideas? I've read the earlier post about a 1004 error that Jim
Gordon said was a serious bug. Is this the same bug?

I'm using Excel X with MacOS 10.2.8.

The macro reads:

Application.Run "'Analysis Toolpak - VBA'!Regress",
ActiveSheet.Range( _
"$D$12:$D$35"), ActiveSheet.Range("$C$12:$C$35"), False,
False, , _
ActiveSheet.Range("$A$100"), False, False, False, False, ,
False
ActiveWindow.ScrollRow = 70
Range("B104").Select
Selection.Copy
ActiveWindow.ScrollRow = 25
Range("C45").Select
ActiveSheet.Paste
ActiveWindow.ScrollRow = 65
Range("F111").Select
Application.CutCopyMode = False
Selection.Copy
ActiveWindow.ScrollRow = 32
Range("C46").Select
ActiveSheet.Paste

Does this work on a PC?

Thanks.

Mike Dixon
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA for Dependents shortcut menu 0
Macro Error 6
Big dataset - batch process 1
Run Macros 11
variable number of rows. 3
Excel Macro delete certail column's 1
1004 error when using ATPVBAEN.XLAM!Regress 7
Recorded macro 4

Top