Hi,

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

or use:
"abc" & "123"
like JMB wrote...

--

Regards,

Halim


"JMB" wrote:

Either

Application.Worksheetfunction.Count(.....)
Application.Count(....)
Worksheetfunction.Count(....)

But I don't think Concatenate is available. You could just use &

"abc" & "123"



"Yehuda" wrote:

This is problably a very basic question, How do I use an excel built in
functtion, such as CONCATENATE(), in my own macro?

Thank You