Such as:

Public Function AddAsString(ByRef v1 As Variant, ByRef v2 As Variant) As
Variant
AddAsString = CStr(v1) & CStr(v2)
End Function

So that in your cell you call the function
AddAsString(2, 2)

?


"Himszy" wrote:

Hi

I want to add two numbers together but not as in 2 + 2 = 4 but 22. Whats the
code I write?

Thanks Michael