Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
OK, I can't get this function to return anything other than #VALUE! What am
I doing wrong? The function is in a module, and the input parameter is a reference to a cell containing an integer. Function my_digit_patt(a) As Integer Dim ct(9) As Integer For i = 1 To Len(a) ct(Val(Mid(a, i, 1))) = ct(Val(Mid(a, i, 1))) + 1 Next b = 0 For i = 0 To 10 b = b + ct(i) * 10 ^ (10 - i) Next my_digit_patt = b End Function |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Simple Sum function question | Excel Worksheet Functions | |||
Probably simple question on AVG function | Excel Discussion (Misc queries) | |||
Simple Function question? | Excel Worksheet Functions | |||
Simple Simple Excel usage question | Excel Discussion (Misc queries) | |||
Simple Function question | Excel Programming |