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.
