What causes MS VB Run-time Error -2147417848 (80010108) in Excel Macro

Question

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.

Answer 1

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