On Thu, 5 Nov 2009 12:10:03 -0800, Andrey Kazak
wrote:

Greetings, dear Experts!

I want to select range and run such Command/Tool that modifies current
values of the range by simple formula (+, -, *, /) and pastes result values
instead the original ones.
Is this possible by the standard means of Excel?

Thank you in advance for propmt reply...


If you want to Add, Subtract, Multiply, Divide
the content of all cells in a range with a constant value you can do
like this:

1) Put the constant, e.g. 7, in an unused cell.
2) Right click on the cell and chose "Copy"
3) Select the range
4) Right click and chose "Paste Special..."
5) In the dialog, chose the wanted Operation, e.g. Add
6) Click on OK
7) All values in the range have now been changed and you can delete
the constant

Hope this helps / Lars-Åke