View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
joel joel is offline
external usenet poster
 
Posts: 9,101
Default Variable Not Defined

I've seen this problem with arrays

Dim abc as variant
and
Dim abc() as variant

are two diffferent variables.

"Barb Reinhardt" wrote:

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