| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Replacing Formulas with Values
ActiveCell.formula = ActiveCell.Value
would replace the cell with the value produced by the link. Replace activeCell with a reference to the cell with the link. -- Regards, Tom Ogilvy "Raman325" wrote in message ... Hi, I would like to replace a formula that brings in a value from a linked cell into the value of the linked cell. Is there a way to do this? Thanks in advance. Raman -- Raman325 ------------------------------------------------------------------------ Raman325's Profile: http://www.excelforum.com/member.php...o&userid=24748 View this thread: http://www.excelforum.com/showthread...hreadid=396167 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Replacing Formulas with Values
Thanks. I tried doing that before and it wasn't working. Maybe I'm doin something else wrong -- Raman32 ----------------------------------------------------------------------- Raman325's Profile: http://www.excelforum.com/member.php...fo&userid=2474 View this thread: http://www.excelforum.com/showthread.php?threadid=39616 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Replacing formulas with its value | Excel Worksheet Functions | |||
| Replacing Linked Cell Values w/ Current Values | Excel Worksheet Functions | |||
| replacing just the sheet names within formulas | Excel Worksheet Functions | |||
| Replacing formulas in Excel | Excel Programming | |||
| Replacing formulas in Excel | Excel Programming | |||
Linear Mode
