calculating the sum for a selected range

**pavankotharu** · 05-20-2010, 04:28 PM

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:

Please Login or Register  to view this content.

O3 is the cell where the value is displayed.

Any help appreciated.

Thanks
PK

**shg** · 05-20-2010, 04:47 PM

Welcome to the forum.

Please Login or Register  to view this content.

Please take a few minutes to read the forum rules so you can use CODE tags next time.

**pavankotharu** · 05-20-2010, 05:01 PM

Thank You for the message. It solved my problem but why are we using & in the beginning and end of the syntax?

Thanks

**shg** · 05-20-2010, 05:05 PM

This is a literal text string:

"=MIN(ActiveWindow.RangeSelection.Address)"

This is the catenation of a literal text string, the result of a function, and another literal text string:

"=sum(" & ActiveWindow.RangeSelection.Address & ")"