I have a nice little macro
But it does not work in my new Excel 2010.
Apparently I need the Microsoft Forms 2.0 Object Library,
but that's not in the list at Tools|References !
Any suggestions...?
Code:
' Copy sum of selected cells into clipboard
Dim MyDataObj As New DataObject
MyDataObj.SetText Application.Sum(Selection)
MyDataObj.PutInClipboard
Apparently I need the Microsoft Forms 2.0 Object Library,
but that's not in the list at Tools|References !
Any suggestions...?