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.
7 answers
http://www.mrexcel.com/archive2/44100/51159.htm
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
click on the cell containing the formula
copy (right mouse click)
select target cell
paste special (right mouse click)
choose values
OK
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.
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
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
Thank you Writeacher
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
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
msip tydrpnswe gphykla okhqwapt htjidvson xnczod vzyuicgkp
1 answer