Excel 2010 VBA - convert formula in a cell into the value of that formula.
I would like to have VBA code do the following:
1. edit the current cell (F2).
2. turn the formula inside that cell into the final value (press F9)
3. move down to next cell.
4. If the next cell is empty. end execution of macro.