Please stay in your original thread.
What do you call a single digit hex number? Why is it hex?
You can pass a range of 64 cells to a function:

Function AddCells(a As Range) As String
Dim i As Long
For i = 1 To 64
AddCells = AddCells + CStr(a(i))
Next i
End Function


--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"soonh" wrote in message
...
I like to program a function which will read 64 of single digit hex numbers
from 64 consecutive rows of the same column and concatenate them all as a
single text string. Anyone has any idea what is the best way to do this?