If then & DDE

[Frodo]

Hopefully someone can help with this:

I receive data in excel though a DDE link. What I am trying to do is
take the value of a cell (A1) at 9:45 and place it into a blank cell
(A2) where it stays for the remainder of the day so the value can be
referenced for other calculations. The cell that is reveiving the data
via DDE (A1) will continue to change after 9:45 but I do not want the
reference cell (A2) to change after 9:45.

Thanks



------------------------------------------------


-- View and post Excel related usenet messages directly from http://www.ExcelTip.com/forum
at http://www.ExcelTip.com/
------------------------------------------------

 

[Jean-Paul Viel]

Hi,



Put this code in the module of the sheet where you want the result:



Private Sub Worksheet_Change(ByVal Target As Range)

If Time <= "9:45" Or Time >= "9:46" Then Exit Sub

Range("a2").Value = Range("a1").Value

End Sub