Delimited macro with a variable column

[alonso1111]

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!

Please Login or Register  to view this content.

[Mordred]

Hi alonso1111, you have to assign a range to col first. For instance, to assign a range or cell you would have something like

Please Login or Register  to view this content.

Now, for your particular problem, I'm not sure how to apply this because I don't know what the "Selection" would be. Perhaps you could upload a mock workbook with some mock data in it with a before and after scenario as well.

[alonso1111]

umm.what i meant was if i can make the range of the col as variable. with regards to what u posted,u let range of col be A1:A20.So it would be fixed as that right? i was thinking if its possible to make the range of the col variable, that is i can select which column of data to do the delimited macro

[Mordred]

I'm going to say yes but you'd probably have to use the Worksheet_Change event if you want col to be dynamic. I can either show you a generic version of this event or you can upload a mock workbook with non-sensitive or private data with a before and after type scenario. That would be preferable and would reduce the guess work from me and others on the forum.