vba courses london - Variable vs Variant

The UK's most regular instructor-led training courses.
Training information: vba courses london · Excel london

Resolved · Low Priority · Version Standard

Variable vs Variant

Jean has attended:
Excel VBA course
Excel VBA course

by - delegate Jean [1 post] (2007 Mar 30 Fri, 16:40) Reply

What is the difference between the variable and the variant?

RE: Variable vs Variant

by - trainer Garry gold contributer [188 posts] (2007 Apr 5 Thu, 10:13) Reply

A variable is a place to store a piece of information. Just as you might store a persons telephone number in your memory, you can store information in a computer's memory. Variables are a way of accessing the computer's memory.

A "Variant" is essentially a universal data type. It can contain any kind of information internally as represent any data type

· What Is Microsoft Excel VBA and How Can It Help You Work Smarter?
· Company Roles in Visual Basic Training

Vba tip:

Count the Rows and Columns in a Selection

If you need to count the number of rows or columns in a worksheet use the following code:

Selection.Rows.Count - Returns the number of rows in the selection

Selection.Columns.Count - Returns the number of columns in the selection

Selection.CurrentRegion.Rows.Count - Returns the number of rows in the current region of the selection

View all VBA hints and tips