Data Types

A Data Type refers to how the data is stored in memory and how many bytes that data needs.
You should always try and use the data type that uses the smallest number of bytes

Data Type	CType	Default	Range	Size	Abr.	(Prefix) Comments
Byte	CByte		0 to 255	1 byte (8 bits)		(by) integers often used in conjunction with string operations Use Long instead
Currency	CCur	0	- 9.2 E+14 to + 9.2 E+14	8 bytes (64 bits)	@	(c) scaled integer Use Double instead
Decimal*	CDec		- 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	CDbl	0	- 1.8 E+308 to + 4.9 E+324	8 bytes (64 bits)	#	(db) double precision floating point used for high accuracy
Integer	CInt	0	- 32,768 to + 32,767	2 bytes (16 bits)	%	(i) integer Use Long instead
Long	CLng	0	- 2.1 E+9 to + 2.1 E+9	4 bytes (32 bits)	&	(l) long integer
LongLong	CLngLng					(ll) Added in Office 2010, VBA 7.0
LongPtr	CLngPtr					(lp) Added in Office 2010, VBA 7.0 Long on 32 bit LongLong on 64 bit
Single	CSng	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