title: Add concatenated string with separator using VBA
body: <p>I'm trying various codes found in this forum to concatenate a varying range every time the program is being run.</p>
  
  <h2>I need to set the value in Range("B1") the concatenated values for a specific range (e.g. A5 to last row with value in col A). Also concatenated values should be separated by ", " (that's a comma and a space).</h2>
  
  <p>Reason why not duplicate:
  I need the value to be shown in Range("B1") but I have to input the "Join" function using vba alone and would not require me to type the UDF in B1.</p>
  
  <p>Range in A has varying last row no. depending on the record needed to be concatenated. Existing question defines exact no. of row while I need a code that is flexible.</p>
  
  <p>Thanks.</p>