brothertruffle880

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.

ASKER

Thanks!

How would I add:

to your code?

I would like the hyper links to be removed from the cells also.

How would I add:

**Selection.Hyperlinks.Delet**e

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