Variables

The UK's most regular instructor-led training courses.
Training information: excel courses · Excel training course · Microsoft Excel Training UK
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

Variables

Wendy has attended:
Excel VBA course

by - delegate Wendy [1 post] (2008 Feb 7 Thu, 16:38) Reply

What is the difference between a variant and a variable

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2009 Jan 9 Fri	Bloomsbury	1	book now	£240	£245
2007	2009 Jan 14 Wed	Bloomsbury	5	book now	£235	£245
2002/XP	2009 Jan 14 Wed	Tooting	0	FULL
2003	2009 Jan 16 Fri	Southwark	0	FULL
2007	2009 Jan 21 Wed	Bloomsbury	3	book now	£240	£245
2003	2009 Jan 21 Wed	Southwark	2	book now	£235	£240
Full Schedule: See all 114 Excel Advanced course dates. Bookings currently available until 31st March 2010.

RE: Variables

by - trainer Stephen gold contributer [394 posts] (2008 Feb 9 Sat, 11:27) Reply

Hi Wendy

Thankyou for your question

A variable is anything that you define at the start of a module or procedure, the value of which will vary throughout the execution of your code.

Variables can be of a range of different types which specify the type of data they can hold. String variables can hold text and numbers, while Byte can only hold numbers in the range 0-255.

Variant is a type of variable. It is a catch all and can hold numeric as well as text and date data.

Hope this is useful

Regards

Stephen