On Sun, 29 Apr 2007 22:42:01 -0700, Halim
wrote:

I've seen Concatenate in Excel builtin formula...
so you can use :
Application.Concatenate("abc"&"123")
to joining text with vba code


Did you try this code?

It does not work in VBA with Excel 2003, on my machine, and, as JMB wrote,
CONCATENATE is not listed as a Worksheet Function available to Visual Basic.
--ron