I am not cumputer savvy whatsoever. Could you possibly put this in lamens'
terms? For instance, do I type:
Private Sub Worksheet_Change(ByVal Target As Range)
With Worksheets("Sheet1")
.Range("A2") = "=" & .Range("A1")
End With
End Sub
in the formula bar? or where? and shouldit be done with cell A1 have this
or A2? Please instruct as though you were doing it to the actual worksheet
because I can always not save if it doesn't work. Thank you.


"AlfD" wrote:


Hi!

Try this in the code page behind your worksheet (I've called it
Sheet1):

Private Sub Worksheet_Change(ByVal Target As Range)
With Worksheets("Sheet1")
.Range("A2") = "=" & .Range("A1")
End With
End Sub

Each time you change A1, its calculated value will appear in A2.


Alf


--
AlfD
------------------------------------------------------------------------
AlfD's Profile: http://www.excelforum.com/member.php...fo&userid=4785
View this thread: http://www.excelforum.com/showthread...hreadid=468361