D
dreastman
Hi All,
I am trying to assign the value the following VBA statement to a cell
Sheets("Sheet2").Range("F1").Formula = "=VLOOKUP(" & Mid(x.Value, 20, 4) &
",Sheet2!$A$1:$C$72,3)"
It currenlty puts the formula in the cell. The only way that I have found to
work around this is to put this formula into a temporary cell and then assign
the value of it to the cell where I really want it.
How to I force the statement to evaluate the vlookup before assigning it to
the cell?
Any Help would be greatly appreciated.
~Dennis~
I am trying to assign the value the following VBA statement to a cell
Sheets("Sheet2").Range("F1").Formula = "=VLOOKUP(" & Mid(x.Value, 20, 4) &
",Sheet2!$A$1:$C$72,3)"
It currenlty puts the formula in the cell. The only way that I have found to
work around this is to put this formula into a temporary cell and then assign
the value of it to the cell where I really want it.
How to I force the statement to evaluate the vlookup before assigning it to
the cell?
Any Help would be greatly appreciated.
~Dennis~