Robert has attended:
Excel VBA Intro Intermediate course
Option Explicit possible problem
When writing code in today's course Option Explicit even though on did not seem to stop non existent variables being used.
Is this a problem of the machines used or is it a wider problem.
RE: Option Explicit possible problem
Hi Bob, thanks for your query. We are still investigating this and believe it to be a consequence of running two versions of Excel on the same machine. Some misspelt variables appear to be declared as variants when they should be trapped by Option Explicit. We believe this to be a problem for us on our training machines rather than an application error but if you spot it happening elsewhere let us know on the forum.
All the best,
Anthony