terminology

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

Terminology

resolvedResolved · Low Priority · Version 2003

Abigail has attended:
Excel VBA Intro Intermediate course

Terminology

what is the difference between a variant and a variable?

RE: Terminology

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

 

Training courses

 

Training information:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Copying Formulae Quickly

There is a quicker way of copying a formula down a column.

Just point and double click on the black autofill handle in the right hand corner of a cell.

This will work providing you have some data in the column to the left of the column.

Sandy

View all Excel hints and tips


Server loaded in 0.07 secs.