Tom,
Thanks for the help. It worked like a charm.

Bob.

On Fri, 29 Aug 2003 19:56:27 -0400, "Tom Ogilvy"
wrote:

Public Function func(range1, range2)
Dim r1, r2 As String
r1 = range1.Value
r2 = range2.Value
func =r1+r2
End Function

Put the code in a general module, not in the Sheet module.

you get a general module by doing insert=Module in the VBE with your
workbook the active project in the VBE.