ilikered100
New Member
- Joined
- May 29, 2013
- Messages
- 46
I've spent hours trying to resolve this problem and read several posts about it, but there is something I am obviously missing.
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:
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
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