Forum Discussion
trying this code am i missing something I can't get it to work?
Function transposeRange(Rg As Range) 'Created to put all dynamic values in one column inside one row in one cell Dim xCell As Range Dim xStr As Range For Each xCell In Rg If Not IsEmpty(xCell.Va...
You need to declare xStr as string, not range. But, if you have office 2016 or higher, you should check if you have the built-in textjoin function, which I believe will do what you need.