Excel VBA

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

Resolved · Low Priority · Version Standard

Excel VBA

Xavier has attended:
Excel VBA course

by - delegate Xavier [3 posts] (2008 Feb 14 Thu, 16:33) Reply

What is a variant?

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Aug 28 Thu	Southwark	0	FULL
2002/XP	2008 Aug 29 Fri	Tooting	0	FULL
2003	2008 Sep 2 Tue	Bloomsbury	4	book now	£207	£215
2003	2008 Sep 4 Thu	Bayswater	5	book now	£195	£205
2007	2008 Sep 4 Thu	Bloomsbury	0	FULL
2003	2008 Sep 9 Tue	Bloomsbury	4	book now	£207	£215
Full Schedule: See all 139 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: Excel VBA

by - trainer Stephen gold contributer [326 posts] (2008 Feb 15 Fri, 15:24) Reply

Hello Xavier

Thank you for your question

When you declare a variable in VBA, you normally define the type of variable. For example,

Dim varDate as Date, creates a variable varDate and sets it so it will only accept date data.

Variant is a catch all data type. It can contain any kind of data except fixed length string data. You can use it when you when the type of data that a variable is to take will vary depending on cionditions that may alter as the procedure runs

Hope this helps

Regards

Stephen

RE: Excel VBA

by - delegate Xavier [3 posts] (2008 Feb 15 Fri, 18:02) Reply

thanks

· MS Excel: Excel At Making The Most Of Your Christmas
· An Introduction to Microsoft Excel: Top Features for the Excel Novice
· 5 Microsoft Excel Charts for Creating Stunning Business Documents
· Microsoft Excel Training: Not Just for Newbies Anymore
· How to Create Better Excel Spreadsheets: Part Two

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

Excel tip:

Get to the end of the used range

What’s the quickest way to get to the bottom right of the used range in your spreadsheet? The two-handed method is Ctrl+End (hold down Ctrl and press End). The one-handed method is End Home (press and release End, and then press and release Home).

The last cell so selected may appear to be empty. However, there is a cell in that row that has an entry or a format and there is a cell in that column that has an entry or format.

View all Excel hints and tips