WorksheetFunction.Convert (Excel)

Converts a number from one measurement system to another. For example, Convert can translate a table of distances in miles to a table of distances in kilometers.

Convert (Arg1, Arg2, Arg3)

Dim dblConvert As Double
dblConvert = WorksheetFunction.Convert(Arg1:=, Arg2:=, Arg3:=)


Arg1, Arg2, Arg3

Arg1 - The value in from_units to convert

Arg2 - The units for number

Arg3 - The units for the result. Convert accepts the following text values (in quotation marks) for from_unit and to_unit, which are listed in the Remarks section