vba courses london - variable vs variant
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft VBA Training and help » vba courses london - Variable vs Variant

vba courses london - Variable vs Variant

resolvedResolved · Low Priority · Version Standard

replyReply Fri 30 Mar 2007, 16:40Delegate Jean said...

Variable vs Variant

What is the difference between the variable and the variant?

For upcoming training course dates see: Pricing & availability

replyReply Thu 5 Apr 2007, 10:13Trainer Garry said...

RE: Variable vs Variant

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

 

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


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard