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. |
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. |
All times are GMT +1. The time now is 05:36 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com