Dim HexString as String, Counter as Long, InterestedColumn as Integer

InterestedColumn = <whatever column #

For Counter = 1 to UsedRange.Rows.Count
HexString = HexString & Cells(Counter, InterestedColumn).Value
Next Counte

--
crispb
-----------------------------------------------------------------------
crispbd's Profile: http://www.excelforum.com/member.php...fo&userid=1088
View this thread: http://www.excelforum.com/showthread.php?threadid=27465