| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
displaying formula result
Hi
My code contains a line ActiveCell.FormulaR1C1 = "=VLOOKUP(R[-6]C[-5]:R[-1]C[-4],1,FALSE)" that inserts a formula in the active cell. Is there a way in which I can insert only the result of the formula (say, "ABC") in the active cell. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
displaying formula result
Hi,
with ActiveCell .FormulaR1C1 = "=VLOOKUP(R[-6]C[-5]:R[-1]C[-4],1,FALSE)" .value = .value End with "Utkarsh" a écrit dans le message de groupe de discussion : ... Hi My code contains a line ActiveCell.FormulaR1C1 = "=VLOOKUP(R[-6]C[-5]:R[-1]C[-4],1,FALSE)" that inserts a formula in the active cell. Is there a way in which I can insert only the result of the formula (say, "ABC") in the active cell. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| The Formula is displaying, not the result | Excel Discussion (Misc queries) | |||
| formula result is not displaying | Excel Discussion (Misc queries) | |||
| Formula result not displaying in cell | Excel Worksheet Functions | |||
| result of formula not displaying | Excel Worksheet Functions | |||
| displaying formula result | Excel Worksheet Functions | |||
Linear Mode
