displaying formula result

U

Utkarsh

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.
 
M

michdenis

Hi,

with ActiveCell
.FormulaR1C1 = "=VLOOKUP(R[-6]C[-5]:R[-1]C[-4],1,FALSE)"
.value = .value
End with




"Utkarsh" <[email protected]> a écrit dans le message de groupe de discussion :
4cf607f1-9dea-43dc-ba52-48460371ab83@k17g2000yqh.googlegroups.com...
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.
 
Top