![]() |
|
#3
|
|||
|
|||
|
Greg, Thanks for your reply. Good idea! I didn't know it was possible. I will try it on Monday at work. In the mean time, I will have to study what you wrote with a good book, "Mastering VBA for Microsoft Office 2016" by Richard Mansfield.
But I get the idea, I think. You made what was highlighted/selected - a variable, oRng. Then you trim it. Then you copy it into the clipboard. Finally you put any spaces back into the highlighted text on the document. But I don't see any use for the first statement: Dim oClipboard As DataObject Is it necessary? Thank you so much! |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Clipboard error Win10 Pro 64 | bkcell | Windows | 1 | 03-24-2018 04:20 AM |
| clipboard error freezes workbook | bkcell | Excel | 4 | 06-18-2017 08:00 PM |
| Do you want to keep your clipboard? | Cam-Bean | Word | 0 | 06-14-2017 02:55 AM |
| Getting the clipboard value: Dataobject error | arjfca | Word VBA | 0 | 12-04-2014 01:51 AM |
Get clipboard Image
|
janith | Word | 2 | 05-27-2012 07:33 AM |