WorksheetFunction.Bin2Dec (Excel)

Converts a binary number to decimal.

If number is not a valid binary number, or if number contains more than 10 characters (10 bits), Bin2Dec generates an error value.

Bin2Dec (Arg1)

Arg1: The binary number that you want to convert. Number cannot contain more than 10 characters (10 bits). The most significant bit of number is the sign bit. The remaining 9 bits are magnitude bits. Negative numbers are represented by using two's-complement notation.

Dim strBin2Dec As String
strBin2Dec = WorksheetFunction.Bin2Dec(Arg1:=)