Here is what I have:
I want to use =MyFunct for that rng. How do I do that?![]()
Dim Rngx2 As Range Set Rngx2 = Sheets("Sheet2").Range("A1:A" & Range("A1").End(xlDown).Row) Sheets("Sheet1").Range("A3").Formula = "=MyConcat(Rngx2)"
Something like... =MyFunct(rng) ... but it won't work.
Bookmarks