title: VBA String.Split Remove Empty Entries
body: <p>In C#, you can do something like this:</p>
  
  <pre><code>string s = "1--2--3";
  s.Split(new char[] {'-'}, StringSplitOptions.RemoveEmptyEntries);
  </code></pre>
  
  <p>and instead of getting {1, ,2, ,3}, you'd get {1,2,3}</p>
  
  <p>I'm trying to do the same in VBA, but I don't see a StringSplitOptions.RemoveEmptyEntries. What's the easiest way to do this?</p>