View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_3_] Bob Phillips[_3_] is offline
external usenet poster
 
Posts: 2,420
Default Variable Not Defined

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 (?).

--
__________________________________
HTH

Bob

"Barb Reinhardt" wrote in message
...
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