I run a spread sheet with DDE links that are updating continuously,
every 1-3 secs and more often I need to monitor a given criterea and
sample the data every 15 mins if the condition is valid then copy the
data to another sheet.

The OnTime function seems to fit this criterea to run the copy and
paste function, but I can not get the syntax to call the Copy Sub at
the designated times.

This will run 72 calls per day, in theory but how do you set out the
relationship of OnTime syntax and the Subroutine.

Any help appreciated... does anyone have experience of OnTime and DDE
as in relation to if it stops the DDE function as I have tested
Application.Wait functions but this stops the DDE link until it times
out.