Object reference not set to an instance of an object

[leonlai]

Hi,

I use a Try-Catch block to catch errors in my code.
This is not strictly VBA code, but VB.NET code which is very similar.
I am not sure this is the appropriate forum.

I use a general exception to trap my error:

Try
Catch ex As Exception
End Try

When the error I have in mind happens, I always get this error message:

Object reference not set to an instance of an object

The error happens when a range is not selected when it is required to be selected.
Here is the code:

For Each CmtCell In SelectedRange
       If Not CmtCell.Comment Is Nothing Then CountCmts = CountCmts + 1
Next

I wish to use a more specific Exception to catch this type of error for 2 reasons:
(a) I can display a more specific and helpful message
(b) I can keep the general Exception to trap all other exceptions

Can anybody tell me which exception can be used?

I tried:

Catch ex As NullReferenceException     '// this works & gives the same message

Catch ex As ObjectDisposedException   '// this does not work

Thanks
Leon

 

[Jaafar Tribak]

Can you show us the vba code you have ... Not the VB.net code .

 

[leonlai]

Hi, Jaafar

Thanks for your reply.

Unfortunately, there is no VBA code. Try-Catch applies only for VB.NET.
My question is more of a general type than a specific problem.

I used IntelliSense in Visual Studio to test all kinds of Exceptions, and it seems that only the NullReferenceException can replace the general Exception.

As I cannot ask my question more precisely, I prefer to close this thread which is too vague.

Best Regards,
Leon