Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy/Text To Columns/Transpose in VBA
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 |