You can run the "TextToColumn" feature on an entire column by first
highlighting the entire column, then doing Data TextToColumns etc
etc.............no macro required, unless you specifically want one for
automation purposes.......

hth
Vaya con Dios,
Chuck, CABGx3



"hioncaffiene" wrote:

I am trying to use the text to column tool on over 1200 seperate rows. How
can I make the macro do this? I tried to "record" but it uses the specific
to the original cell information. I need it to say "active cell" then
actually run the formula that is text to column for what ever is in the
current cell. Any body have any ideas. Thanks in advance - this project is
huge and this is only the begining.