VBA : Creating Custom Data type

here is a code to Create your own type of variable :

VBA Special cells

VBA special cells make your life easy, instead of writing multiple lines of code and looping the the entire range of cells, this special cell types select in less than a second.

For more info visit msdn link below.
http://msdn.microsoft.com/en-us/library/office/aa213567%28v=office.11%29.aspx