Custom Number Format from Range

5/9/2015 - 4:50 PM

Sub NumberFormat()

	' Range should be formatted as "TEXT";"TEXT"
	Range("B2:B19").NumberFormat = Range("C2:C19").Value


End Sub

Cacher is the code snippet organizer for pro developers