Xavier has attended:
Excel VBA Intro Intermediate course
Excel Advanced - Formulas & Functions course
PowerPoint Intermediate Advanced course
Excel VBA
What is a variant?
RE: Excel VBA
Hello Xavier
Thank you for your question
When you declare a variable in VBA, you normally define the type of variable. For example,
Dim varDate as Date, creates a variable varDate and sets it so it will only accept date data.
Variant is a catch all data type. It can contain any kind of data except fixed length string data. You can use it when you when the type of data that a variable is to take will vary depending on cionditions that may alter as the procedure runs
Hope this helps
Regards
Stephen