hex2bin - HEX2BIN
 

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.

hex2bin - HEX2BIN
 

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.

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.