| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy Value but not Formula
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy formula result (text) only - without copying formula | Excel Discussion (Misc queries) | |||
| I copy a formula and the results copy from the original cell | Excel Discussion (Misc queries) | |||
| copy formula down a column and have cell references change within formula | New Users to Excel | |||
| Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
| Copy formula so destination displays formula as text | Excel Discussion (Misc queries) | |||
![Sean[_9_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
