Dear all,

First off, I understand according to the forum rules I have to advise that I crossposted here:

http://www.ozgrid.com/forum/showthread.php?t=153807&goto=newpost. I will omit the other thread and continue from here.

Here is my sheet layout and contents of the cells as promised.

A1=DDELinkDataA1 B1=DDELinkDataB1 C1=DDELinkDataC1 and 17 more columns follow

A2=DDELinkDataA2 B2=DDELinkDataB2 C2=DDELinkDataC2 and 17 more

columns follow

and 48 more rows

Eventually it is a 50rowx20column matrix of cells which are updated several times a second from a feed

On the same sheet there are following functions which get live data from some of the cells above.

U1=Function1(A1,B1,C1, etc as necessary) V1=Function2(A1,B1,C1, etc) and 8 more functions

U2=Function1(A2,B2,C2, etc as necessary) V2=Function2(A2,B2,C2, etc) and 8 more functions

... and 48 more rows

This is a 50rowx10 column matrix of functions. There is a separate function for each column and these functions get data from the same row as parameters. These functions make a lot of calculations using the cell values from the first DDE matrix above and create new values for each row about which I need to keep track of and see on the fly by putting them into other cells on the very same Excel sheet such as:

AF1=ResultAF1 AG1=ResultAG1 AH1=ResultAH1 and 6 more columns

AF2=ResultAF2 AG2=ResultAG2 AH2=ResultAH2 and 6 more columns

and 48 more rows

This becomes a 50rowx9column of results matrix.

Here are my problems and in fact comments to your suggestions:

1-Event subs won't work out as there are many cells changing instantly and that would cause huge calculation traffic

2-ByRef call won't work out because actually none of these functions need to return a value to the cell they are called from. Actually, all functions are expected to make calculations, create some values and put them into the cells that form the Results matrix.

Puff! I hope I managed to make it clear. I know what I want is not something common and seems against how functions/subs/events work. I am just trying to use excel sheet to feed my functions and use the values calculated by functions for debugging on the fly, all on the very same Excel sheet.

Any different approach as to how to manage it?

Many thanks and regards,