run-time error 2147417848

F

ffreesefh

Joined
Apr 22, 2014
Messages
2
Reaction score
0
Folks,
For the past several weeks I have been struggling to resolve a run-time error in Excel:
"Run-time error '-2147417848 (80010108)
Method 'ListFillRange' of object 'IMdcList' failed"
The error appears when I try to load the Analysis ToolPak in my workbook. I'm using Win 7 and Office 2010 Professional. The workbook is the zip file and the two jpg files are the error code and the error message.
Thanks for any help....
Frank
 

Attachments

  • runtime error.png
    runtime error.png
    7.2 KB · Views: 229
  • code with error.png
    code with error.png
    73.2 KB · Views: 253
  • Analysis_Revised.zip
    102 KB · Views: 150
F

ffreesefh

Joined
Apr 22, 2014
Messages
2
Reaction score
0
I had some code in the wrong event - everything is fine. I'm running Office 2010
Thank you
 

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

Run-time error when copying entire row! 5
Run-time error ‘-2147417848(8001 2
Run-time Error '-2147417848 (80010108)' 1
Problem with excel macro - getting automation error 3
Run-time error 2147417848 (80010108) 1
'-2147417848' - 'Automation error The object invoked has disconnected from its clients.' 1
VBA - Run time error when modules combined??? 7
Runtime Error -2147417848(80010108) 1

Top