DDE formula

  • Thread starter Thread starter Thomas
  • Start date Start date
T

Thomas

Hello! I have a formula that grabs a number from a cell
fed by my DDE, but I want the number that it grabs to be
static after its taken, not continue to change according
to the feed. I'm currently using:

=IF(AND(MAX(D2:D18)>A21,MAX(D2:D18)<
(A21+0.0006944444)),B2,)

MAX(D2:D18)>A21,MAX(D2:D18)<(A21+0.0006944444) represents
the time frame in which the feed number should be taken,
which works fine, but when the time frame ends it goes
back to zero, but I want to keep the static number.

Thomas
 
You would have to write a macro to Copy and PasteSpecial the value so that
the formula is overwritten. Otherwise the formula will keep updating as the
referenced cells change.
 
Back
Top