Variable Not Defined

B

Barb Reinhardt

I just received a report from a user testing a workbook in work, that a
variable is not defined in the procedure. What's strange is that the
variable is defined. Has anyone else seen this problem and what is the
solution.

FWIW, I have option explicit on every module and when I compile the code,
there are times when errors like this aren't captured. Has anyone seen that
as well?

Thanks,
Barb Reinhardt
 
J

Joel

I've seen this problem with arrays

Dim abc as variant
and
Dim abc() as variant

are two diffferent variables.
 
B

Bob Phillips

I have definitely seen the situation where I have Option Explicit, as I
always do, and a non-declared variable is not picked up on compile. When
executing the code, it only gets picked up when that path is traversed. I
have never been able to spot a common situation, but it is far more regular
than I would like.



Bob
 
B

Bob Phillips

Oh, as an aside I have a line similar to this in all procedures

Const mpProcedure As String = "procedure_name"

which also fails regulalrly on compile, and I have to remove that line and
re-type it. Then all is well (?).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top