title: Vba Left Function not working
body: <p>I'm trying to delete the last  character of a string because I populate the string with a loop that automatically adds a "," after every new string added, like: </p>
  
  <pre><code>Do Until EOF(1)
      ...
      (get string)
      ...
      Ref = Ref + String
      Ref = Ref + ","
  Loop
  Ref = Left(Ref, Len(Ref) - 1)            (Delete last "," of ref)
  </code></pre>
  
  <p>When trying to run this I get a "Wrong number of arguments or invalid property assignment" error on the LEFT function. </p>
  
  <p>I've tried to research this error but the only thing I can find is about tools-references are missing, which they aren't (to my knowledge). 
  The threads I find are all for vba for excel which isn't the case here, this is code for a script running in a reflection workspace.</p>
  
  <p>Is there another way of deleting the last char of my string? Or is there something wrong that warrants this error? I can't seem to figure this out.</p>
  
  <p>Thanks for your time. </p>