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.
You can do it without a macro using copy/paste-values.
If if has to be a macro you can have something like
dim rng as range