vba courses london - Variable, Variant

Resolved · Low Priority · Version Standard

Thu 18 Jan 2007, 16:04 Delegate David said...

David has attended:
Excel VBA Intro Intermediate course

Variable, Variant

What is the difference between a variable and a variant

Tue 23 Jan 2007, 09:25 Edited on Tue 23 Jan 2007, 09:26 Trainer Carlos said...

RE: Variable, Variant

A Variable is a name used to represent a value.

The variable name represents a unique location in memory where the value is stored temporarily.

A Variant is a data type.

If a Variable is declared and the data type ommited a generic type called Variant is used a default

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

vba courses london - Variable, Variant

Variable, Variant

RE: Variable, Variant

VBA articles

VBA tip:

Add A New Sheet at the end of the Workbook