VBA : Variable Type List

Data Type	Memory	Data Range
Byte	1 Byte	0~255
Integer	2 Bytes	-32768~32767
Long	4 Bytes	-2147483648~2147483647
Single	4 Bytes	-3.4E38~-1.4E-45 1.4E-45~3.4E38
Double	8 Bytes	-1.7E308~-4.9E-324 4.9E-324~1.7E308
String	10 Bytes + String length	2^31 string
String*length	String length	2^16 = 32768 string
Boolean	2 Bytes	True or False
Variant	Value : 16 Bytes String : 22 Bytes+ String length	Value : Equal to Double String : Equal to String
Currency	8 Bytes	922,337,203,685,477.5807~ -922,337,203,685,477.5808
Date	8 Bytes	Date : January 1,100~  December 31,9999 Time : 00:00:00~23:59:59