Quick Links ▼

Bookmark page

Printable version

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » VBA

	98.1 % recommend us
	More live stats...

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

Training information:

VBA

Resolved · Low Priority · Version Standard

Reply Thu 7 Feb 2008, 16:36Delegate Stuart said...

Stuart has attended:
Excel VBA Intro Intermediate course

VBA

what is the difference between a variable and a variant?

For upcoming training course dates see: Pricing & availability

Reply Tue 19 Feb 2008, 16:16Trainer Carlos said...

RE: VBA

Hi Stuart

A Variable is used to store temporary information that is used for execution within the Macro or Module

On the other hand a Variant is a Variable Data type.

Id the Variable is declared without a data type the computer defaults the data type to Variant.

Hope this helps

Carlos

Excel articles

· What's mine is yours: Sharing data in Excel
· Microsoft Excel Features and Functions for Accountants
· How To Add A Second Axis To An Excel Line Chart
· Advanced Excel Training - takes you to the next level
· The Mysteries Of Excel Explained

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

Excel tip:

Freeze Rows and Columns to keep lables displayed

You can freeze rows and columns in your worksheet so they don't move.

This allows you to keep row and column labels displayed on your screen as you move through a large worksheet.

Click below and/or to the right of the cell(s) you want to freeze. (NB. Excel freezes ALL the rows above and ALL the columns to left of the selected cell)

Click on the 'Windows' menu and selct 'Freeze Panes'.

Lines appear in your worksheet. The required rows and columns are frozen and remain on your screen as you move through your worksheet.

To unfreeze rows and columns, click on 'Window' menu and select 'Unfreeze Panes'.

View all Excel hints and tips