Is "Quantity1" a cell on a spreadsheet?
VarType is supposed to be used with a variable.
You would have to create a variable, let's say x.
x = Range("Quantity1").Value
If VarType(x)......