Hello,
I am trying to create a macro that selects the range from the active cell in col A all the way down to the last non-empty cell in col A, and then does text to column from the initial selected (active) cell.
For the moment, the recorded macro I have is as follows:
Sub TextToCols()
Range(Selection, Selection.End(xlDown)).Select
Selection.TextToColumns Destination:=Range("A429"), DataType:=xlDelimited, _
TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=True, Tab:=False, _
Semicolon:=False, Comma:=False, Space:=True, Other:=False, FieldInfo _
:=Array(Array(1, 1), Array(2, 1), Array(3, 1), Array(4, 1), Array(5, 1), Array(6, 1), _
Array(7, 1), Array(8, 1)), TrailingMinusNumbers:=True
End Sub
Now the problem with this is: I don't want the text to columns to happen in cell A429, I want it to happen in the cell I originally selected.
If anyone can help me with that, I would be most grateful.
Thanks,
G
Bookmarks