What is the difference between 'The object invoked has disconnected' and 'Type Mismatch' errors in VBA?

Responsive Ad Header

Question

Grade: Education Subject: Support
What is the difference between 'The object invoked has disconnected' and 'Type Mismatch' errors in VBA?
Asked by:
103 Viewed 103 Answers

Answer (103)

Best Answer
(317)
'The object invoked has disconnected' indicates a connection problem, while 'Type Mismatch' indicates an incorrect data type being used. 'Disconnected object' means the object is no longer available, whereas 'Type Mismatch' means the code is trying to perform an operation on a value that isn't of the expected type.