calculate only once

[The Idea Dude]

Lets say cell C1 is the result of a condition, say =if(H1=1,1,0) I want Cell C2 to look at the value of Cell B4 as soon as C1 = 1 (note, as soon as C1=1 it won't change any more). Cell C2 will then = this value, but only on this occasion. Cell B4 will change its value, but I do not want cell C2 to update. In plain language, I want C2 to take a freeze of B4 when C1 becomes 1

Confusing

Thanks

 

[Derek]

Hi there
You could try this event macro:

Right click your sheet tab, left click View Code and paste this in the white area

Private Sub Worksheet_Change(ByVal Target As Range)
If [C1] = 1 Then [C2].Formula = [C2].Value
End Sub

This should convert C2 to a permanent value when C1 equals 1

You will need a formula like this in C2
=IF(C1=1,B4,"")


regards
Derek
This message was edited by Derek on 2002-10-14 23:11

 

[The Idea Dude]

Thankds Derek it worked like a charm.

Any idea on this Q. While your here

http://www.mrexcel.com/board/viewtopic.php?topic=25019&forum=2&9

 

[Derek]

Hi again
link tells me it is unavailable
What was the question?
regards
Derek

 

[The Idea Dude]

On 2002-10-14 23:47, Derek wrote:
Hi again
link tells me it is unavailable
What was the question?
regards
Derek

Whoops,

External Data - Macro Question

Cheers from Western Oz

 

[Derek]

Hi again
External Data - Macro Question??????
Not sure I follow you, can you rephrase your question.
regards
Derek

 

[The Idea Dude]

Sorry Derek, I was pointing you to the subject line of my question. It is probably on page 2 now, and it would be easier for you to track it down, than for me to re do the Q