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