VBA won't help you overcome the 256 column limit, per se.

I presume you want to take data that would be in columns beyond IV and put
it somewhere else? Where would that else be? On another sheet? On another
row on the same sheet - if so, how much further down the sheet (next row, or
way on down somewhere)?

Or you could wait for Excel 2007 with its 65000+ columns available?

" wrote:

Hi,

I have a string of numbers, each separated by a space, in a single
cell. I want to take that string, do a text-to-columns, and then
copy-paste special-transpose into a single column. I tried recording
this macro, but I have too many numbers and it will exceed the 256
column limit when I do text to columns. How can I do this through VBA?

Thanks!

Brett