Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
How do I convert cell contents that are Hex to binary?
I want to process a column at a time, so I need a main function.
|
#2
|
|||
|
|||
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. -- Regards, Tom Ogilvy "KarenSue33" wrote in message ... I want to process a column at a time, so I need a main function. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding contents of one cell to a range of cells. | Excel Worksheet Functions | |||
make cell contents equal to null value - not blank, but empty | Excel Worksheet Functions | |||
Cell contents vs. Formula contents | Excel Discussion (Misc queries) | |||
Display actual contents of cell | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions |