Copying values not formula

  • Thread starter Thread starter Martin
  • Start date Start date
M

Martin

Hi Group

I have a cell which contains a value which is generated by a formula. I want
to be able to copy that value elsewhere but when I do a copy and paste it is
the formula that gets copied, not the value it generates. How do I copy the
value?

Thanks for any help anyone may be able to give on this one.
 
Martin said:
Hi Group

I have a cell which contains a value which is generated by a formula.
I want to be able to copy that value elsewhere but when I do a copy
and paste it is the formula that gets copied, not the value it
generates. How do I copy the value?

Thanks for any help anyone may be able to give on this one.
Click to expand...


Use Paste Special from the right click menu, and then select 'Values' from
the options.
 
Hi Martin,
If you want to this often you might want to create a macro so
you can use a shortcut key combination. Suggest Ctrl+SHIFT+V

Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False

an example of a full macro is in
Paste/Pasting
http://www.mvps.org/dmcritchie/excel/paste.htm#values
If not famililar with installing/using macros see my page
http://www.mvps.org/dmcritchie/excel/getstarted.htm

The Red Cardinal said:
Use Paste Special from the right click menu, and then select 'Values' from
the options.
Click to expand...
Martin said:
I have a cell which contains a value which is generated by a formula.
[clipped] How do I copy [only] the value?
Click to expand...
Click to expand...
 
Back
Top