How do I copy the value from a cell without copying the formula?

C

Captain

I'm trying to, as my question states copy the value of a cell without copying
the formula, that way my simple macro can repeat. Is this possible?
 
P

Pete_UK

Click <copy> on the cell with the formula in. Move to where you want
the value to appear, then use Edit | Paste Special | Values (check) OK
then press <Esc> or <Enter>. This fixes the value in the second cell.

Hope this helps.

Pete
 
S

sandernoteborn

Don't know if I get your problem but maybe you should just use:

Copy and then Paste Special.

Right click and choose PASTE SPECIAL. Then click Values. If it's ok it
just copy's the values and nothing more!

Goodluck!
 
Top