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