Hi there,

I am using excel 2010, and i would like to know how to setup a macro to copy + paste the value instead of the formula.

excample


A1 Cell : =A2+A3

A1 = 3
A2 = 2
A3 = 1

I press a button, and then it copy's cell A1 to B1 with only the value not the formula.

Thanks for reading.