Arguments of Excel functions

[Guest]

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?

 

[crispbd]

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

 

[Niek Otten]

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