Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Arguments of Excel functions
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Arguments of Excel functions
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Arguments of Excel functions
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Errors on Functions with many arguments | Excel Worksheet Functions | |||
arguments in MATCH and OFFSET functions | Excel Worksheet Functions | |||
Why do functions not allow commas to seperate arguments | Excel Worksheet Functions | |||
Need know what are valid SUMPRODUCTS arguments and functions | Excel Worksheet Functions | |||
Arrays as Arguments in Functions | Excel Programming |