Macro for paste special

[BonzaiMaster]

I've recorded a marco to do a 'Edit/Paste Special.../Unformatted Text" and
assigned it to a keyboard shortcut.

However it simply does a normal paste instead.

This is the recorded VBA:

Sub pastespecial()
'
' pastespecial Macro
' Macro recorded 20/10/2005
'
Selection.PasteAndFormat (wdPasteDefault)
End Sub

Can anyone help please?

 

[Jay Freedman]

I've recorded a marco to do a 'Edit/Paste Special.../Unformatted
Text" and assigned it to a keyboard shortcut.

However it simply does a normal paste instead.

This is the recorded VBA:

Sub pastespecial()
'
' pastespecial Macro
' Macro recorded 20/10/2005
'
Selection.PasteAndFormat (wdPasteDefault)
End Sub

Can anyone help please?

The macro recorder has many bugs, and this is one of them. Use this line
instead:

Selection.PasteSpecial DataType:=wdPasteText

 

[BonzaiMaster]

Selection.PasteSpecial DataType:=wdPasteText

That did it. Thanks very much.