I am looking for code to turn a formula into a label, then move down on
cell. Also code to undo (unlabel) the cell.

The purpose of this is to see the effect on a sum, or to temporaril
"turn off" formula cells. For example -

In the column below, where all numbers are formulas -

10 (this cell is the formula =+A1)
20 (this cell is the formula =+A2)
30 (this cell is the formula =+A3)
-----
60
-----

10
20
=+A3 < this is what I want the VBA macro to do
-----
30
-----

I tried "Edit" "Home" " ' " "Enter" interactively, but I couldn't ge
it to work.

The equivalent in Lotus would be {EDIT}{HOME}'~{D

--
brandtboo
-----------------------------------------------------------------------
brandtboo0's Profile: http://www.excelforum.com/member.php...fo&userid=3457
View this thread: http://www.excelforum.com/showthread.php?threadid=54344