How do I convert cell contents that are Hex to binary?

[KarenSue33]

I want to process a column at a time, so I need a main function.

 

[Tom Ogilvy]

You can loop through all the cells -

Sub ConvertColumnK()
On Error Resume Next
For Each cell In Range(Cells(1, 11), Cells(Rows.Count, 11))
cell.Value = CDbl("&H" & cell.Value)
Next
On Error GoTo 0
End Sub

In your post in Misc you said convert to Decimal. Hex2Bin converts to
binary.