• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1068
  • Last Modified:

vba error 94 invalid use of null - how to find

A very large vba program, processing thousands of records. Somewhere in the vba I'm getting this error.
I'm looking for a way to trap or display the statement that is producing this error. Is this info stored anywhere
where it is accessible?
0
jsgould
Asked:
jsgould
1 Solution
 
peter57rCommented:
Hi jsgould,
In any module in design view go to Tools>options and on the general tab make sure you have 'Break On All Errors' selected.
That will cuase the code to be high;ighted on the line that causes the error.

Pete
0
 
jsgouldAuthor Commented:
thanks for the quick response!!!!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now