peteywarner
10-30-2007, 02:22 AM
Hi, I was hoping someone may be able to help me here.
I am trying to add to a macro script, a part that will convert text to columns. Currently I run a small macro that sorts the data and deletes what I don't want, and then it uses formulae in excel cells to manipulate the data into columns. I wanted if possible to get the macro to do all of it, as excel falls over once I reach about 25,000 lines; due to the number of formulae involved (excel 2000). From the one text field I extract fourteen different columns, obviously each formulae is different mostly due to Left, Mid and Right combinations; but there are other varying IF statements also.
Thanks in advance.
Pete :help
I am trying to add to a macro script, a part that will convert text to columns. Currently I run a small macro that sorts the data and deletes what I don't want, and then it uses formulae in excel cells to manipulate the data into columns. I wanted if possible to get the macro to do all of it, as excel falls over once I reach about 25,000 lines; due to the number of formulae involved (excel 2000). From the one text field I extract fourteen different columns, obviously each formulae is different mostly due to Left, Mid and Right combinations; but there are other varying IF statements also.
Thanks in advance.
Pete :help