-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
VBA Variant question
- Thread starter Pjam
- Start date
prabby25101981
Active Member
- Joined
- Jul 28, 2010
- Messages
- 348
Yes. Variant data type has a numeric storage size of 16 bytes and can contain data up to the range of a Decimal, or a character storage size of 22 bytes (plus string length), and can store any character text. Try F1 in VBA.
Upvote
0
JackDanIce
Well-known Member
- Joined
- Feb 3, 2010
- Messages
- 9,922
- Office Version
- 365
- Platform
- Windows
I believe it does. Excel, by default assumes a variable to be a variant unless it is declared as a specific variable type (e.g. As String, As Double etc). And since a variant is of an unknown variable type, Excel allocates it maximum memory so that it can then be used to store whatever is passed to it.
This link gives a decent overview of the different variable types and probably a better explanation than me!
<html>http://www.ozgrid.com/VBA/variables.htm</html>
This link gives a decent overview of the different variable types and probably a better explanation than me!
<html>http://www.ozgrid.com/VBA/variables.htm</html>
Upvote
0
