Pasting to Sheet

  • Thread starter Thread starter Nigel
  • Start date Start date
N

Nigel

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
 
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 here:

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.
 
Thanks Jim, we spent some time looking for an option that we had changed!!

This explains it all. Cheers
Nigel
 
Back
Top