Option Explicit and For Each... Construct

  • Thread starter Thread starter Richard Winston
  • Start date Start date
R

Richard Winston

When you use Option Explicit, must you always make a forward declaration
of the Element that you define in your For Each... statement ? I've
been getting errors, something about variable not declared. When I
Dim'd the Element as an Object prior to the For Each...statement, the
message went away.


Thanks.
 
Thats right - when you use Option Explicite you must also dclare your
variables.
Doing so - certainly gives you much better control.
 

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

Similar Threads

For Each Type mismatch 5
Object declarations 10
Option Explicit 5
Access Microsoft Access - Subtotals for each page 0
Error messages as if "Option Explicit" were declared, but it isn't 4
Option Explicit 4
>> Early binding and late binding with attachment 2
Can't get length of a variant array passed to a subroutine 6

Back
Top