title: Turn Excel range into VBA string
body: <p>I would like to turn values in given range into VBA string where original cell values are separated by any chosen column delimiter and row delimiter. Delimiters could be one character or longer strings. The row delimiter is the string at the end of the line. The string should be done just as we read text from left top corner, from left to right, to bottom right corner.</p>
  
  <p>Here is an example of the VALUES in range A1:C5:</p>
  
  <pre><code>+----+----+----+
  | A1 | B1 | C1 |
  +----+----+----+
  | A2 | B2 | C2 |
  +----+----+----+
  | A3 | B3 | C3 |
  +----+----+----+
  | A4 | B4 | C4 |
  +----+----+----+
  | A5 | B5 | C5 |
  +----+----+----+
  </code></pre>
  
  <p>Desired results is a VBA string:</p>
  
  <pre><code>A1,B1,C1@$A$2,$B$2,$C$2@A3,B3,C3@A4,B4,C4@A5,B5,C5@
  </code></pre>
  
  <p>For the sake of readability I will show it like this:</p>
  
  <pre><code>A1,B1,C1@
  A2,B2,C2@
  A3,B3,C3@
  A4,B4,C4@
  A5,B5,C5@
  </code></pre>
  
  <p>As a column delimiter I have chosen <code>,</code> (comma), and as a row delimiter <code>@</code> sign. Of course these could be any characters like <code>\r\n</code>.</p>
  
  <p>The reason why I want fast cooking of the string from range is because I want to to send it to SQL Server through ADO connection. As I have tested so far it is the fastest way to transfer lots of data on the fly. The twin question how to split this string on SQL Server is here: <a href="https://stackoverflow.com/questions/39752188/split-string-into-table-given-row-delimiter-and-column-delimiter-in-sql-server">Split string into table given row delimiter and column delimiter in SQL server</a> </p>
  
  <p><strong>Solution 1.</strong> Loop through all rows and columns. Question is if there be any more elegant way then just looping through all rows and columns? I would prefer VBA solution, not formula one. </p>
  
  <p><strong>Solution 2.</strong> Suggested by Mat's Mug in comment. CSV file is desired results. I would like to do it on the fly without saving. But good point - imitate CSV is what I want but I want it without saving. </p>
  
  <p><strong>Edit after bounty</strong></p>
  
  <p>Answer of Thomas Inzina works crazy fast and his solution is portable. Ordinary VBA loop turned out to be way faster then worksheet functions like JOIN on large data sets. I do not recommend using worksheet functions in VBA for that purpose. I have voted up everybody. Thank you all.</p>