asked on 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.
Microsoft ExcelVB ScriptVisual Basic.NET
Last Comment
Saqib Husain
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
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
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