help deleting a formula

Sharkie21

Active Member
Joined
Nov 2, 2005
Messages
319
I created a macros that sets the value in "majority" of the cells to be the value of the cell above it with Range(cell).value = "= " & cellAboveValue. I did this because I don't know the value the cell will be until maybe 10 records later.

Now I want to convert the formula in each cell with the actual number it is.

ex:
A3.value = "=" & A2
A2.value = "=" & A1
A1.value = 3

Now I want it to be
A3.value = 3
A2.value = 3
A1.value = 3
 

Some videos you may like

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).

Watch MrExcel Video

Forum statistics

Threads
1,118,055
Messages
5,569,946
Members
412,299
Latest member
agentless
Top