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 :
(e-mail address removed)...
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

#NAME? on correct formula 4
Formula appearing instead of result 2
Vlookup in vba - how to use absolute rows not relative 1
Another Vlookup for VBA question 4
Macro autofills formula when a cell value is changed 4
Placing a formula in a cell of an unconstant row location 2
Relative references in formulas 3
Run-time error '1004': Application defined or Object defined error 2

Top