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...
RoweeYadin Not sure what you want to achieve, but by the name of the function you want to transpose a range, Are you aware that there is a function called TRANSPOSE? Depending on your Excel version you may have to enter it with Ctrl-Shift-Enter, rather than jus Enter.