How to use TEXTJOIN in vba

[capson]

Hello,

I am trying to use TEXTOIN in vba

Sub AAA()
Dim str As String


    str = WorksheetFunction.TextJoin(" ", False, "E2:E6")
    MsgBox str


End Sub

This gives "E2:E6" as the return

If I try this instead:
str = WorksheetFunction.TextJoin(" ", False, E2:E6)

I get error

Is there a way to use TEXTJOIN in vba?

Thanks

 

[Sakshine]

Because I want to use this function for every month in a year and for so many employees and that's why i can't just put the formula and drag down for each and every month.
I would be very grateful for any help on this.

 

[RoryA]

I don't understand that. Why won't it work specifically? If you can't fill down a formula, how would you be able to fill down the equivalent VBA function?