#### ilikered100

##### New Member

- Joined
- May 29, 2013

- Messages
- 46

Here is the VBA code for the formula that is being entered. When I run the code, the formula shows in the cell(s) and not the value(s).

Range("B2:B2000").Formula = "=iferror(if(VLOOKUP(A2,WorkingData!$A$2:$A$2000,1,FALSE)<>"""",TRUE),"""")"

Here's what I've tried so far without success:

- Made sure the worksheet with the formulas has all cells formatted to General
- Made sure the worksheet that the vlookup is pulling from has all cells formatted as General
- Removed all the formulas. Saved and Closed. Re-opened and re-entered the formulas

The only thing that has been successful is if I go to each cell with a formula, select the cell and then hit enter, but there are thousands of cells and I can't find a way to do this in VBA.

Any help is much appreciated as I've spent far too long on this and I'm sure it is going to be something very simple that I have overlooked.

Thank you,

Carolyn