Exceltechie.com

Easiest way to learn excel on the planet
Facebook-exceltechie Twitter-exceltechie Linkedin-exceltechie
|| Novice || Beginner || Intermediate || Advanced || Specialist || Expert ||

Variable is a named value used to allocate space in the memory and is used to
store temporary information that is used for execution within the Procedure, Module.

Sample of a memory address is 0x401000.


If there is no data type specified the default data type is taken

There are different data types
Integer - Whole numbers without decimal and 0 + 65536 ( both + and - )
Double ( decimal numbers)
Long (high precision decimal numbers)
Boolean
String
Array
In General, We have 2 Data Types
Number and String

Variable Names - Rules

A Variable name must start with a letter.
A Variable name can be no longer than 250 characters.
A Variable name cannot be of Excel key words.
Numbers , Underscore is allowed eg. Num1, first_name, Address1.