hex2bin - HEX2BIN
;D.... that's what I get for multitasking. Sorry, I meant to say HEX2DEC.
I'll try this and see if this is what I'm trying to do. Thanx much!
"Tom Ogilvy" wrote:
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 read the values from a cell, rather than hardcoding in hex
values
in a "hexvalue" formula. If the hex value is in K78, I'd like to take
the
value from K78 and convert it. [i.e. Hex2Bin(K78)] I want to process
columns at a time, not just cells at a time.
|