What causes MS VB Run-time Error -2147417848 (80010108) in Excel Macro
34,866
I found that the error is caused by 'Freeze Panes'. If you are in the sliding part of the panel you get the crash, if you are in the frozen bit everything works fine. The solution is: first change the active cell to a cell in the frozen pane, e.g. Range("A1").Activate
Author by
Admin
Updated on June 16, 2020Comments
-
Admin almost 4 years
I have a macro which runs fine on my machine but when I try to run it on another machine it gives the following error.
Microsoft Visual Basic
Run-time Error -2147417848 (80010108)
Automation Error
The Object invoked has disconnected from its clients.