Hi -

I was wondering if it's possible to write a macro for the following:

After importing a .csv file to Excel, I use "Text to Column" to parse the
data. The problem is each line/row has more than 256 columns worth of data.
I'd like to have the rest of the data parsed into the next worksheet.

In other words, if a row contains data that will spread across 356 columns,
when I parse it, first 256 columns will be in sheet 1 and the rest 156 will
be in sheet 2.

Thanks!
Pauline