Forum Discussion
Combine 2 spilled range to one
A1# and E1# are spilled range, and I want to combine them to A7#. Number of row and column might change so you cannot hard code them. VBA is not allowed. Actually I can do this with Sequence()...
You could consider joining the Office Insider Beta channel. MS has recently released some neat new functions one of which that does just that (HSTACK).
Thank you for the information! Would you by any chance have a link for that? I just tried but cannot find the link.