Hi Folks,

In Excel 2003, after copying a cell, I frequently used a little macro (below) to paste just its comments into another cell (selected before invoking the macro). However, in Excel 2010, I get an error: "Run time error '1004': PasteSpecial method of Range class failed".

Here's my macro code:

Sub Paste_Comment()
Selection.PasteSpecial Paste:=xlPasteComments, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
End Sub

Any ideas on what to do differently (and why it's failing now)?

Many thanks!

Tom