| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I copy the FORMULA in a cell to a different cell?
I would like to copy the formula from 1 cell to a different cell. I want to
do this ONLY if there is a formula. For instance, I might have a formula in column D and F on worksheet "Test" in each row I would like to, on worksheet "Test2" to copy the actual formula into a give cell. How can I TEST for the presence of a formula, and then how can I copy the actual "=function()" to my new cell (preferably with a delimiter infront so I can actually see the formula. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Code to copy the formulae of one cell to all the cell in the rangewith the specific cell and columnnumber changing Options | Excel Discussion (Misc queries) | |||
| How do i copy a colored cell to another cell using a formula | Excel Discussion (Misc queries) | |||
| I copy a formula and the results copy from the original cell | Excel Discussion (Misc queries) | |||
| Copy exact value from one cell to new formula in another cell | Excel Discussion (Misc queries) | |||
| copy contains from cell to cell w/ formula | Excel Worksheet Functions | |||
![Phillips[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
