Thread
:
displaying formula result
View Single Post
#
2
Posted to microsoft.public.excel.programming
michdenis
external usenet poster
Posts: 135
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 With Quote
michdenis
View Public Profile
Find all posts by michdenis