I believe you are correct. As soon as the “False” condition exists the values arrived at through the formulas in each cell is lost. I’ve never done a VBA macro before so bare with me. When you mentioned “constant values”, could these values be derived by the same math used in the existing cell formulas?
As a simple example, lets say I’m using the following formula in cell F5:
( =IF (D5=30, (M5/(M4+M3))

So when D5 is “True” at the 30 minute interval whatever the values are at that time in cells M3, M4, and M5 will enter the formula and provide a new value result in cell F5 (that I want to keep). As each new time interval arrives the values in the “M” will also change and produce another new value in F5.

My thinking was to dedicate a series of cells for each time interval so that the result from each interval is retained and wouldn’t get lost or overwritten by each succeeding interval.

Could you inform me as to how a VBA macro would handle something like this?
Thanks

FOLLOW UP:
I just read through an interesting VBA tutorial on creating and using Custom Functions. If I’m not mistaken it looks like I might be able create the “constant value” you mentioned as each Time Interval arrives. This constant value would then be inserted into a designated cell. This way each of the existing dependent Formula cells (F5, F6, F7, etc.) would refer to that cell value instead of continually changing Time cell (D5).

As long as the value remains constant I should never lose the data created. I guess I'll also have to incorporate a way to reset the constant values (to maybe "0") after an entire Timing cycle is completed.
Does that sound about right?

Sam,
I'm having a rather busy day but if you post back an example of the
formulas you want to use for F5:F15 that would be helpul. Better yet if
you can attach your file or a link to where I can download it.

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc

GS wrote on 2/1/2012 :
Sam,
I'm having a rather busy day but if you post back an example of the formulas
you want to use for F5:F15 that would be helpul. Better yet if you can attach
your file or a link to where I can download it.

I see that this is duplicate in cols G:H and so I'll need those
formulas as well.

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc

Hi Garry
I really appreciate your offer, but with your initial advice I had already gotten one of my friends involved who is also very familiar with VB. He’s sending me the VB code that I’ll need to create those custom functions.
Thanks again!

Sam Spade expressed precisely :
'GS[_2_ Wrote:
;1291952']GS wrote on 2/1/2012 :-
Sam,
I'm having a rather busy day but if you post back an example of the
formulas you want to use for F5:F15 that would be helpul. Better yet if
you can attach your file or a link to where I can download it.-

I see that this is duplicate in cols G:H and so I'll need those
formulas as well.

--
Garry

Free usenet access at http://www.eternal-september.org

ClassicVB Users Regroup! comp.lang.basic.visual.misc
Hi Garry
I really appreciate your offer, but with your initial advice I had
already gotten one of my friends involved who is also very familiar with
VB. Hes sending me the VB code that Ill need to create those custom
functions.
Thanks again!

Sam,
No problem! Let me know how you made out...

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc