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
Bookmarks