View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default VBA text to columns

I ain't giving up on this either <bg.

NickHK wrote:

If Dave's advise has not worked, please explain why you think you have
"fixed width data", when in other posts you appear to have variable length,
space separated data.

NickHK

"Parusky" wrote in message
...
Please help. VBA Ignorant. I am trying to build a macro to convert a lot

of
fixed width data from text to columns sequentially for multiple rows. The
macro recorder will not work due its nature with arrays. The simple

keyboard
commands that do work are as follows:
Alt D
Alt e
Enter
Enter
Enter
Arrow down
Got the books on VBA but can't seem to get started on this simple

repetitive
onerous manual task. A keyboard recorder would be nice.

Thanks for your kind assistance

Parusky






--

Dave Peterson