Microvellum Community

RANGETOSTRING works for rows (not just columns)

I was under the impression this function could work both directions, but I can't seem to get it to return anything other than a column's worth of data in a string.  I tried a horizontal row and a full grid, but only ever get what is in the first column.  Since you can tell it the # of rows and # of columns to return, it seems like it should be able to go either direction.  I could really use it horizontally, not just vertically.

Let me know if I am doing something wrong...


UPDATE:  I was doing something wrong... forgot the last parameter, which is "FALSE" for horizontal.  See comments for more info.


    Toolbox BSB Survey



    Have you been using Toolbox BSB? We'd love to hear what you think!

    Take the Survey

      MVU eLearning



      Grow Your Knowledge
      Follow along with RJ as he takes you on a journey to build your foundational knowledge of Toolbox.


        Follow us on:

                 

          ERP for Millwork Shops


          Discover how Microvellum and INNERGY streamline operations for cabinet shops and millwork manufacturers.