Formula spoiling the code?

[jackandjill]

Hi i am not sure if putting a formula in the cell is causing the below code preventing it from running, before anymore details please take a look at the code below which is working perfectly fine after the code i will explain what it does...

Please Login or Register  to view this content.

ok basically this code makes sure that whenever there is a change in A column for range of A1 to A27 it will take a mean value from D column and then the max value will be placed inside the respective B column and minimum value will be placed in C.
Run the code for your self to get a better understanding if you are a forex trader you will understand it faster that's the only benefit.
For those pro's and administrators who understand this code well, here is my question.
There is a change happening whenever there is a change of value in A and the code runs perfectly fine. Problem is when i apply this formula in A 1 lets say A1's formula is =F1.
So by logic when ever there is a change in F1 there will be a change in A1 too which is good, but according to the code there should be a change occurring in B and C as well but there is no change its like the code is never being initiated

[pike]

That right
it is trigger by user change not formula change

[snb]

If F1 changes, the worksheet_change event will be triggered.
The target is beyond the range you want te code to be executed. (column A or columnD); so the code won,'t be executed if F1 has been changed.
The change in A1 because of the formula won't trigger the Worksheet_Change event.
So by changing F1 the target in the eventprocedure will never meet the specified criteria for running the code.

[jackandjill]

so i there another code that i can overcome this problem and yet achieve the same result? tks

[pike]

how do you enter values in F1

[DonkeyOte]

FWIW - this thread has since been duplicated (and responded to)

http://www.excelforum.com/excel-prog...a-formula.html

jackandjill, do not duplicate threads - this simply increases the risk of people wasting their freely donated time.

[jackandjill]

oh no as you can see that this was merely to confirm that what i presumed to be right... so in the other thread i will be posting more code than just answers in order to find a solution to this.
If it appeared to be such that to duplicate thread then pardon me..