Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 =--- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pasting into a filtered sheet | Excel Discussion (Misc queries) | |||
Why can't I use SUM when pasting HTML code into new sheet. | Excel Worksheet Functions | |||
Copying and Pasting from One Sheet to Another | Setting up and Configuration of Excel | |||
Pasting Into new sheet | Excel Discussion (Misc queries) | |||
a problem with pasting into Excell sheet | Setting up and Configuration of Excel |