Hi
Picture you have some cells displaying a number based on a formula. When a copy of this cell is made and you then whant to paste only the value into another cell, you use the paste special option i excel.
My question is how do i write this code in VBA? I like to make a button when clicked it copies only the value from one cell to another disregarding that the value is based upon a formula.
Thanks in advance.
Picture you have some cells displaying a number based on a formula. When a copy of this cell is made and you then whant to paste only the value into another cell, you use the paste special option i excel.
My question is how do i write this code in VBA? I like to make a button when clicked it copies only the value from one cell to another disregarding that the value is based upon a formula.
Thanks in advance.