Thread: MOREFUNC
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips[_3_] Bob Phillips[_3_] is offline
external usenet poster
 
Posts: 2,420
Default MOREFUNC

You can write your own UDF

Function Concat(Delim As String, ParamArray rng())
Dim i As Long
Dim tmp As String
Dim cell As Range

For i = LBound(rng) To UBound(rng)

For Each cell In rng(i)

tmp = tmp & cell.Value & Delim
Next cell
Next i

Concat = Left(tmp, Len(tmp) - 1)
End Function


--
__________________________________
HTH

Bob

"lehigh46" wrote in message
...
Hi All:

For some reason Morfunc is not working.
I tried re-installing it, but after that Excel does not recognize it
anywhere.
I spcificly need it for MCOCAT

I am using XP Pro & Excell Office 2007

Thanks for any help that anyone can give me.

Tom