Mon 6 Jul 2009, 16:41Delegate Rabi said...
Rabi has attended:
Excel VBA Intro Intermediate course
Sub procedures
What is a variant?
Thu 9 Jul 2009, 10:17Trainer Anthony said...
RE: sub procedures
Hi Rabi, thanks for the query. A variant is a data type. When you declare your variables at the start of your code remember that you declare their type as well, e.g. text, boolean, value etc. When you set you data type to be variant it can be any data type. You'd use it when you don't initially know the type of data the variable will hold, or when you expect it you contain multiple data types.
Hope this helps,
Anthony
