=Hex2bin("2b")

displays

101011

You have to have the analysis toolpak installed.

If that isn't the answer, then you need to restate your question in a
different way so we can understand it.

--
Regards,
Tom Ogilvy

"kuch68" wrote in message
...
I was just wondering if there was some code or function that exists to
convert hex to binary in vB. My program takes a 8 bytes of hex and
converts
them to binary populating each Bit in a column (64 columns). I need an
easy
way instead of using more columns to perform the HEX2BIN worksheet
function.

thanks
Josh