calculating the sum for a selected range

[pavankotharu]

When a user selects any particular range in the worksheet and click the submit button which i have created, i need to display the sum of the selected range. I used the below but its not working:

.Range("O3").Formula = "=MIN(ActiveWindow.RangeSelection.Address)"

O3 is the cell where the value is displayed.

Any help appreciated.

Thanks
PK