Hi all, I want to do a text to column, then delimit on a column of my data. I could probably do it if its a fixed column but what I really want to do is to have the column that is to be delimited to be variable,ie, i could choose column A or B or C etc to do the macro. I paste whatever i have as of now below.Thanks for any help! I tried to have a variable called "col",but i am not able to integrate it into this macro. Also, for the Destination, is col.select correct? Thanks again for the help!

Sub ExampleSplit1()
Dim col as Range

    Selection.TextToColumns _
      Destination:=col.select, _
      DataType:=xlDelimited, _
      TextQualifier:=xlDoubleQuote, _
      ConsecutiveDelimiter:=False, _
      Tab:=False, _
      Semicolon:=False, _
      Comma:=False, _
      Space:=False, _
      Other:=True, _
      OtherChar:="*"

End Sub