Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

STL - Formerly Best Training Solutions Through Learning
TrustPilot
Excellent
Request Callback We will call you back
0207 987 3777 Call for assistance
Your Basket Basket is empty
vba courses london - variable variant

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

vba courses london - Variable, Variant

ResolvedVersion Standard

David has attended:
Excel VBA Intro Intermediate course

Variable, Variant

What is the difference between a variable and a variant

Edited on Tue 23 Jan 2007, 09:26

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:

Empty The Clipboard with CutCopyMode

After each Copy/Paste operation in VBA, you should use the following line of code to empty the clipboard. This ensures that the computer memory doesn't overload:

ActiveSheet.Paste
Application.CutCopyMode = False

View all VBA hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.15 secs.