Microsoft Office Forums - View Single Post - [Solved] Paste-As-Text macro

Thread: [Solved] Paste-As-Text macro

View Single Post

Old

11-20-2012, 02:28 AM

Wries

Wries is offline

Wries uses Windows XP

Windows XP Wries uses Office 2007

Wries uses Office 2007

Office 2007

Advanced Beginner

Join Date: Jun 2009

Posts: 40

Wries is on a distinguished road

Default

sorry, I haven't realized you are copying outside excel.

Please try again with this and advise if it is working from your end.

Code:

Sub Paste()
ActiveCell.PasteSpecial xlPasteAll
End Sub

Kind regards,
Wries

Reply With Quote