Hello there...

I've written a UDF that allows me to concantenate a range of cell
values with a prefix & suffix value. See below:

Public Function ITEMLIST(ByVal CELL_RANGE As Range, Optional ByVal
ITEM_PREFIX As Variant, Optional ByVal ITEM_SUFFIX As Variant) As
String
'#### Concatenate range of cells, incorporating specified prefix &
suffix values ####

   Dim pRngCell As Range
   Dim pStrList As String

   On Error GoTo errCode

   For Each pRngCell In CELL_RANGE
       pStrList = pStrList & CStr(ITEM_PREFIX) & CStr(pRngCell.Value)
& CStr(ITEM_SUFFIX)
   Next
   ITEMLIST = pStrList
   Exit Function

errCode:
   ITEMLIST = "# Unable to list!"
End Function

The problem i have is that it works fine in an Excel Workbook, but as
soon as I save the Workbook as an Add-In the Optional variables become
Required!

If anyone can shed any light on this i'd be very grateful...

Rgds

Stuie