Text to Columns with Active Cell and not a fixed cell

[gab037]

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:

Please Login or Register  to view this content.

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

[mike7952]

Give this a try

Please Login or Register  to view this content.

[gab037]

Thanks for the tip, it now works using something very similar to what you suggested.

Best,
Gabriel