Paste Special Macro

[Guest]

I'm trying to record a macro with the Edit | Paste Special | Unformatted Text
command. When I run the macro, it seems to perform a standard Paste. When
editing the macro, Visual Basic would write the same code as a standard Paste
operation. Any suggestions?

 

[Jay Freedman]

I'm trying to record a macro with the Edit | Paste Special |
Unformatted Text command. When I run the macro, it seems to perform
a standard Paste. When editing the macro, Visual Basic would write
the same code as a standard Paste operation. Any suggestions?

The recorder never gets that one right. :-(

See
http://groups-beta.google.com/group/microsoft.public.word.vba.general/msg/6be9ad83e7d37f71?hl=en
for the correct code.

 

[Anne Troy]

Hi, Mike. Try this:
http://www.vbaexpress.com/kb/getarticle.php?kb_id=18
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com