Pasting to Sheet
 

When pasting text from the clipboard, the data is parsed
and spaces between each word causes each word to placed in
separate cells. Is this an option in VBA ?

TIA
Nigel

Pasting to Sheet
 

Is this an option in VBA?

Not really. I think what you're seeing (the parsing) is a side effect of
having used the Text Wizard, as explained he

http://support.microsoft.com?kbid=127132

So the pasting (manual or macro) will parse or not parse on it's own
depending on having used the wizard. Where you want parsing and haven't
gotten it you can use the range TextToColumns method.

--
Jim Rech
Excel MVP

Pasting to Sheet
 

Thanks Jim, we spent some time looking for an option that we had changed!!

This explains it all. Cheers
Nigel

"Jim Rech" wrote in message
...
Is this an option in VBA?

Not really. I think what you're seeing (the parsing) is a side effect of
having used the Text Wizard, as explained he

http://support.microsoft.com?kbid=127132

So the pasting (manual or macro) will parse or not parse on it's own
depending on having used the wizard. Where you want parsing and haven't
gotten it you can use the range TextToColumns method.

--
Jim Rech
Excel MVP






----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeed.com The #1 Newsgroup Service in the World! 100,000 Newsgroups
---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =---