vba courses london - Variable & Variant

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

Resolved · Low Priority · Version Standard

Variable & Variant

Peter has attended:
Excel VBA course
Excel VBA course

by - delegate Peter [1 post] (2007 May 15 Tue, 09:53) Reply

What is the difference between a variable and a variant in VBA?

RE: Variable & Variant

by - trainer Carlos gold contributer [360 posts] (2007 May 23 Wed, 13:57) Reply

A Variable is a place to store a piece of information in the computer's memory.

Declaring a variable reserves an area in memory to store the value connected with the variable. When declaring a variable you have to declare adata type eg. Currency

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

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

Vba tip:

Add A New Sheet at the end of the Workbook

To add a new sheet at the end of the workbook you need to count the sheets in the workbook using:

Sheets.Count

Then use this value as the rank of the sheet after which you want to add the new sheet:

Sheets.Add After:=Sheets(Sheets.Count)

View all VBA hints and tips