Hi R,

Dim x As New DataObject is not recognized in Excel 2003.

My omission!

In the VBE: Tools | References | Locate and check 'Microsoft Forms 2.0
Object Library'

---
Regards,
Norman



"rdaugherty" wrote
in message ...

The reason why I needed
F2
Ctrl-V (edit/paste)
Enter

was because I had a user that was copying a paragraph of table text
from MS Word into cells that were already formatted to Wrap Text. For
whatever reason, though, the wrap text feature would turn off and then
the cell contents would spread across the page or be covered up.

He had to do this a number of times so I thought I would whip up a
quick macro to just hit a keystroke or button. And he couldn't just
copy the table into Excel because he was selecting only parts of each
MS Word table cell text. And he had to copy into different rows and
columns, so he didn't want to copy and paste and then format the whole
sheet later to Wrap Text.

Again, I thought it would be easy to create this simple 3-step macro.
It should be, but I'm missing a very basic concept I think.

So, yes, I was pasting from the Clipboard.

I tried a few things that were suggested (not the lengthy one, though)
but none of them seem to work.

Dim x As New DataObject is not recognized in Excel 2003.

I stopped trying others since some of you may have a better way of
doing this.


--
rdaugherty
------------------------------------------------------------------------
rdaugherty's Profile:
http://www.excelforum.com/member.php...o&userid=28043
View this thread: http://www.excelforum.com/showthread...hreadid=475515