Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Option Explicit possible problem

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions

Option Explicit possible problem

Resolved · Low Priority · Version 2003

Reply Fri 28 Jan 2011, 17:00Delegate Robert said...

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.

For upcoming training course dates see: Pricing & availability

Reply Tue 1 Feb 2011, 14:03Trainer Anthony said...

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

Tue 8 Feb 2011: Automatically marked as resolved.

Excel articles

· Tips for Transitioning to Excel 2007
· Microsoft Excel Training - Numerical excellence for all
· Tips to Facilitate Printing of Excel worksheets
· How To Learn From Your Excel Mistakes
· How To Create A Multiple Pie Chart In Excel

Please browse our web site to find out more about
excel computer training and other Microsoft training courses.

Excel tip:

Generating Random Numbers

To generate a random number in Excel use the = RAND() function.

The value returned will always be between 0 and 1. To convert this to some other random value, you will need to multiply the result by the highest number you want to consider. For example, if you wanted a random number between 1 and 25, you could use the following code line:
= INT(25 * RAND()+ 1)

Since RAND() will always returns a value between 0 and 1 (but never 1 itself), multiplying what it returns by 25 and then using the Integer function INT on that result will return a whole number between 0 and 24.

Finally, 1 is added to this result, so that x will be equal to a number between 1 and 25, inclusive

View all Excel hints and tips