VBA Numbers - Data Types

Data Type	Default	Range	Size	Abr.	Comments
Byte		0 to 255	1 byte (8 bits)		(by) integers often used in conjunction with string operations Use Long instead
Currency	0	- 9.2 E+14 to + 9.2 E+14	8 bytes (64 bits)	@	(c) scaled integer Use Double instead
Decimal*		- 7.9 E+28 to + 7.9 E+28	14 bytes		(dec) Variant subtype Must be declared as a Variant and then converted using the CDec function
Double	0	- 1.8 E+308 to + 4.9 E+324	8 bytes (64 bits)	#	(db) double precision floating point used for high accuracy
Integer	0	- 32,768 to + 32,767	2 bytes (16 bits)	%	(i) Use Long instead
Long	0	- 2.1 E+9 to + 2.1 E+9	4 bytes (32 bits)	&	(l) long integer
LongLong					Added in Office 2010, VBA 7.0
LongPtr					Added in Office 2010, VBA 7.0 Long on 32 bit LongLong on 64 bit
Single	0	- 1.3 E+38 to + 1.3 E+38	4 bytes (32 bits)	!	(sng) single precision floating point used when you have fractional numbers Use Double instead