Hi All,

I've got a problem with excel.

I am facing this problem while I enter formula in the excel sheet using vb code. I have selected a cell and then I use the code,

activecell.formulaR1C1 = "=vlookup(blah,blah...)"

and then I fill this formula to the desired range of cells.

What happens is....the formula is written in the cells as a text and the formula is not picking the value from the page mentioned in it.

In the excel sheet, in the desired cell (eg H1) the content remains as =vlookup(blah,blah...) instead of the value.

Can anyone help me out of this???