Question

I have no idea on how to copy and paste a cell with value only.

It will be appricated if anyone call show me a sample.

Answer 1

http://www.mrexcel.com/archive2/44100/51159.htm

Answer 2

Do you really want a macro or just to be able to cut and paste a value? If the latter then
click on the cell containing the formula
copy (right mouse click)
select target cell
paste special (right mouse click)
choose values
OK

Answer 3

Another way is to click on the cell you want to copy, press Ctrl + C, then click where you want to place that value, press Ctrl + V.

Answer 4

Thank you for both of your information.

I really want a macro.
The link given by bobpursley is quite useful.

activecell.offset(0,1).value = activecell.offset(1,0).value
It is what I want to know ..... ^.^

Thank you so much

Answer 5

Thank you Writeacher

Answer 6

Another way is to click on the cell you want to copy, press Ctrl + C, then click where you want to place that value, press Ctrl + V.

No. This will not work as it will paste the formula as well. If you want short cut keys then:
click on cell
ctrl C
click on target cell
alt E
alt ops key S
alt ops key v
return

Answer 7

msip tydrpnswe gphykla okhqwapt htjidvson xnczod vzyuicgkp