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.
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.
ASKER
Thanks!
How would I add:
Selection.Hyperlinks.Delet
to your code?
I would like the hyper links to be removed from the cells also.
How would I add:
Selection.Hyperlinks.Delet
to your code?
I would like the hyper links to be removed from the cells also.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You can do it without a macro using copy/paste-values.
If if has to be a macro you can have something like
Sub cnv2values()
dim rng as range
set rng=range(selection,select
rng.value=rng.value
end sub