title: Text To Columns VBA Destination onto new sheet
body: <p>I'm having a problem with Excel VBA Text To Columns. Apparently the function is fixated on putting the destination on the same sheet when I want it to be on a new sheet.</p>
  
  <pre><code>Worksheets("RawData").Columns(ID).TextToColumns Destination:=Worksheets("Regular").Columns("C"), DataType:=xlDelimited, _
      TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=False, _
      Semicolon:=False, Comma:=True, Space:=False, Other:=True, _
      OtherChar:="(", _
      FieldInfo:=Array(Array(1, 1), Array(2, 1), Array(3, 1)), TrailingMinusNumbers:=True
  </code></pre>
  
  <p>Apparently this will just dump it on Column C of raw data rather than the worksheet of "Regular" where i want it to be. </p>