Ramzi has attended:
Excel VBA Intro Intermediate course
Variable vs variant
whats a difference between a variable & a variant?
RE: variable vs variant
Hi Ramzi
A Variable is a place to store a piece of information in the computer's memory.
Just as you might store a person's telephone number in your memory, you can store information in a computer's memory. Variables are a way of accessing the computer's memory and setting aside memory space to store the information.
A Variant is essentially a universal data type.
It can contain any kind of information internally, and represent any data type
Regards
Carlos