Copy Value but not Formula

[Sean]

I was wondering if it is possible thru VBA to copy the contents of a cell
and paste them to another, but not have the cell change every time the
original cell (which has a formula) changes. For instance if C5 has a
formula: =(R5-S5)*2

I want to be able to copy the resulting value of C5 to, say, B5. But I only
want the value, not the formula. So that B5 doesn't change everytime C5, R5,
or S5 does. I want to be able to run this macro anytime I need to make
B5=C5.

--
______________________________
Thank you, Sean
Artist/Production Manager
Please visit us at www.oatesflag.com
502-267-8200
502-267-8246 fax

 

[Ron de Bruin]

You can use this to copy only the value

Range("B5").Value = Range("C5").Value