Question
What is the difference between 'The object invoked has disconnected' and 'Type Mismatch' errors in VBA?
Asked by: USER7762
103 Viewed
103 Answers
Answer (103)
'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.