Terminology

The UK's most regular instructor-led training courses.
Training information: excel courses · Excel course london · VBA courses London

Resolved · Low Priority · Version 2003

Terminology

Abigail has attended:
Excel VBA course

by - delegate Abigail [1 post] (2008 Jul 17 Thu, 16:34) Reply

what is the difference between a variant and a variable?

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Nov 25 Tue + 26 Wed	Bayswater	6	book now	£455	£515
2003	2008 Nov 26 Wed + 27 Thu	Bloomsbury	2	book now	£495	£495
2003	2008 Dec 1 Mon + 2 Tue	Bloomsbury	2	book now	£495	£495
2003	2008 Dec 4 Thu + 5 Fri	Bloomsbury	5	book now	£450	£485
2007	2008 Dec 11 Thu + 12 Fri	Bayswater	5	book now	£475	£515
2007	2009 Jan 8 Thu + 9 Fri	Bloomsbury	6	book now	£450	£475
Full Schedule: See all 37 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: Terminology

by - trainer Roy bronze contributer [28 posts] (2008 Jul 21 Mon, 16:14) Reply

A variable is a named storage location in your code - typically within a Sub or Function.
For example, 'i' in: Dim i As Integer.

Variant is a 'don't-know-what-it-is' data type.
For example: Dim dunno As Variant.
You sometimes see Variant when arrays are being used.

/Roy

· Microsoft Excel Training Course
· Excel and Inventory Management
· Do You Really Need Excel VBA Training?
· Advanced Excel Training - takes you to the next level
· Excel in the Home Office

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