Macro - Sum highlighted cells and copy

[Houstonking]

Hello, I need a macro that will sum any cells I selected, copy the sum value of it, and remember it so I can paste it wherever I want.

Please help.

 

[JGordon11]

Sub SumToClipboard()
    'Must enable Forms Library: Checkmark Tools > References > Microsoft Forms 2.0 Object Library
    Dim obj As New DataObject, n As Double
    n = Application.Sum(Selection)
    obj.SetText n
    obj.PutInClipboard
End Sub

 

[Alex Blakenburg]

Please update your account details to show what version of Excel you are using.
If you are using MS 365 do you really need a macro for that ?
When you select your values the Sum (Average, Count and some other calculations you can display) will show in the Status bar.
A "Single Click" on the value in the Status bar will copy it into the clipboard. Ctrl+V to paste it wherever you want to place the result.